BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Business Objects Security

Goto page 1, 2  Next
 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
nasha
Forum Member
Forum Member



Joined: 02 Sep 2009

Posts: 9



PostPosted: Wed Sep 02, 2009 10:05 am 
Post subject: Business Objects Security

Hey All,

I am working with Business Objects XI Release 2. I am trying to fetch encrypted data from SQL Server 2008. This data is Pass Phrase encrypted. Hence I need a mechanism to pass the "pass phrase" to SQL Server. Please let me know if there is any hook in Business Objects to do the same.

It would be great if I can prompt the user to enter the pass phrase.

Any help would be appreciated.

Thanks.

- Nasha.
Back to top
bension
Forum Associate
Forum Associate



Joined: 01 Sep 2005

Posts: 735
Location: San Diego, CA



PostPosted: Wed Sep 02, 2009 11:56 am 
Post subject: Re: Business Objects Security

Are you trying to query the system database directly? This is not possible, you need to use the query builder or SDK.

If you are talking about a separate source database that is encrypted, I don't think I can answer that.
Back to top
nasha
Forum Member
Forum Member



Joined: 02 Sep 2009

Posts: 9



PostPosted: Wed Sep 02, 2009 12:00 pm 
Post subject: Re: Business Objects Security

Nope this is not a system databse this is a normal user made databse in SQL -Server that holds encrypted data.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19315
Location: Bratislava


flag
PostPosted: Wed Sep 02, 2009 12:02 pm 
Post subject: Re: Business Objects Security

Welcome to Bicon_mrgreen.gifB!

Can you let us know how do you get the encrypted data from a database when you use a query tool other than BO? What kind of query you need to run in a query tool to get the data?

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
nasha
Forum Member
Forum Member



Joined: 02 Sep 2009

Posts: 9



PostPosted: Wed Sep 02, 2009 12:05 pm 
Post subject: Re: Business Objects Security

From the application I call a store procedure passing the pass phrase to it as a parameter. This store proc decrypts and returns the data back.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19315
Location: Bratislava


flag
PostPosted: Wed Sep 02, 2009 12:11 pm 
Post subject: Re: Business Objects Security

Then how about using the same stored procedure in a data provider with the parameter being passed using a report prompt ( @prompt() function) ?
_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
nasha
Forum Member
Forum Member



Joined: 02 Sep 2009

Posts: 9



PostPosted: Wed Sep 02, 2009 12:17 pm 
Post subject: Re: Business Objects Security

I was told by my local BO dev that BO XI Version 2 does not support Store procedures.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19315
Location: Bratislava


flag
PostPosted: Wed Sep 02, 2009 12:26 pm 
Post subject: Re: Business Objects Security

Hi,

You can use stored procedures as data sources in DeskI reports. You can't use them in WebI reports.

Maybe your BO developer was talking about WebI reports.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Steve Krandel
Forum Devotee
Forum Devotee



Joined: 24 Jun 2002

medal_bronze.gifspeaker.gif*7
Posts: 12414
Location: San Jose, California


flag
PostPosted: Wed Sep 02, 2009 12:27 pm 
Post subject: Re: Business Objects Security

You can call stored functions. You will have to make each column refer to a function that does what you want.

In the select portion of EVERY object you're going to need something like:
Code:
decrypt_me(table.column, passcode)
Be careful, your performance may not be very good.
_________________
Image link Steve Krandel
Manager, Enterprise BI Tools
Image link
Back to top
nasha
Forum Member
Forum Member



Joined: 02 Sep 2009

Posts: 9



PostPosted: Wed Sep 02, 2009 12:30 pm 
Post subject: Re: Business Objects Security

These reports will be viewed using DI. I was told that Version 2 does not support store procedures hence this question arised.

Sorry, I myself I am working on BO for the firsrt time hence I dont know its capabilities. Thanks for the pointer. I will check with my dev and let you know.

Thanks for all your help. Appreciate it !

- Nasha.
Back to top
Steve Krandel
Forum Devotee
Forum Devotee



Joined: 24 Jun 2002

medal_bronze.gifspeaker.gif*7
Posts: 12414
Location: San Jose, California


flag
PostPosted: Wed Sep 02, 2009 12:48 pm 
Post subject: Re: Business Objects Security

nasha wrote:
These reports will be viewed using DI.
Does DI mean Data Integrator or Desktop Intelligence.

If you are talking about Desktop Intelligence, then you should be fine. Desktop Intelligence does support Stored Procedures.

This is a universe issue. You can build derived tables in you universe which decrypt. Then, none of this matters.

_________________
Image link Steve Krandel
Manager, Enterprise BI Tools
Image link
Back to top
nasha
Forum Member
Forum Member



Joined: 02 Sep 2009

Posts: 9



PostPosted: Wed Sep 02, 2009 2:44 pm 
Post subject: Re: Business Objects Security

Please let me know how to call store procedures in Business Object XI Version 2 ? My team believes its NOT SUPPORTED. It would be great if someone could clarify this.

Also is it possible to read a file from the disk or call a web service from business objects. As if we cannot call the procedure then we would like to call a webservice that can perform this

Thanks once again for all your help.

- Nasha
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19315
Location: Bratislava


flag
PostPosted: Wed Sep 02, 2009 3:17 pm 
Post subject: Re: Business Objects Security

nasha wrote:
Please let me know how to call store procedures in Business Object XI Version 2 ? My team believes its NOT SUPPORTED. It would be great if someone could clarify this.

Please do a search and you will find topics that discussed this already.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Steve Krandel
Forum Devotee
Forum Devotee



Joined: 24 Jun 2002

medal_bronze.gifspeaker.gif*7
Posts: 12414
Location: San Jose, California


flag
PostPosted: Wed Sep 02, 2009 4:35 pm 
Post subject: Re: Business Objects Security

Again. Are you trying to have stored proc as a source for a report? If so, then you can't.

If you are calling a function that does the work, then yes.

_________________
Image link Steve Krandel
Manager, Enterprise BI Tools
Image link
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19315
Location: Bratislava


flag
PostPosted: Wed Sep 02, 2009 5:47 pm 
Post subject: Re: Business Objects Security

Steve,

You can use a stored procedure as a data source for a DeskI report.

In a New Data Wizard or New Table Wizard, in the Specify Data Access window you do not select Universe radio button but Others and then you
select Stored Procedures from the drop down menu.

There is even a way how to use a stored procedure in a WebI report if you use a certain database:
http://www.forumtopics.com/busobj/viewtopic.php?t=94285

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0319 seconds using 18 queries. (SQL 0.0032 Parse 0.0010 Other 0.0277)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo