BusinessObjects Board

WebI Rich Client

Hi Team,

Is it possible to access Webi Rich Client outside of Network without ODBC entries in local machine? (As we access Launchpad).

Please suggest…


Rajesh Kumar :india: (BOB member since 2012-03-01)

You can work in offline mode? If you want to access DB data sources then you require connectivity, either via the BOE webserver, or via ODBC on the client.


Mak 1 :uk: (BOB member since 2005-01-06)

Hi Mak.

I found something related to 3-tier architecture:

I dont want to setup ODBC connectivity for each user.
Req : User should be able to access universe thru RC. (Same as Launchpad)

Thanks…


Rajesh Kumar :india: (BOB member since 2012-03-01)

This is what i was alluding to here:-

Thing is you confused the issue by this statement above.


Mak 1 :uk: (BOB member since 2005-01-06)

Hi Mak,

I have created an OLEDB connection for SQL Server DB. And then created a Test UNX universe based on this connection.

But getting below mentioned error message when I am trying to run query based on this UNX.

Database error: (CS) “Unable to connect to the InfoStore” . (IES 10901) (WIS 10901)

Note : Able to run query in Dev but not able to run in Prod, Is this related to firewall?

Please suggest and sorry for confusion :oops:


Rajesh Kumar :india: (BOB member since 2012-03-01)

Definitely worth checking.


Mak 1 :uk: (BOB member since 2005-01-06)

Hi Mak,

Can you please tell me how can I get OLEDB middle ware for Oracle 11g?

Thanks…


Rajesh Kumar :india: (BOB member since 2012-03-01)

In short you can’t. SQL Server only…


Mak 1 :uk: (BOB member since 2005-01-06)

Thanks Mak :frowning:

So, there is no option to run reports in Rich Client via Launchpad without do TNS entry locally :frowning:

Thanks…


Rajesh Kumar :india: (BOB member since 2012-03-01)

Nope…


Mak 1 :uk: (BOB member since 2005-01-06)

I think it is possible thru Network Layer “Oracle OCI”.

Thanks.


Rajesh Kumar :india: (BOB member since 2012-03-01)

Oops, my bad…sorry, forgot about JDBC connectivity.
Steps for set up:-
http://scn.sap.com/thread/2049046


Mak 1 :uk: (BOB member since 2005-01-06)

Also there is a trick whereby the whole tnsnames entry is put within the connection. Search for smart connections, I think, which is what one person’s company calls them.


Nick Daniels :uk: (BOB member since 2002-08-15)

Vey interesting Nick, I haven’t heard of that either, before, will have to check that out 8) .

Semms like it has been around a while, but unclear whether it can still be used. I found this old post:-

https://bobj-board.org/t/17101


Mak 1 :uk: (BOB member since 2005-01-06)

Just I had a word with SAP team regarding Oracle connectivity.
He suggested me to install “Oracle Net client 32-bit” on BO Server for Rich client.


Rajesh Kumar :india: (BOB member since 2012-03-01)

It can still be used.


Nick Daniels :uk: (BOB member since 2002-08-15)