Desktop Intelligence reports pointing to an ODBC connection

building reports desktopintelligence
1

How do I point my Desktop Intelligence reports to use a new ODBC connection that I created against production database.
Just FYI - I also have an existing ODBC connection pointing DEV database.

Any input is greatly appreciated. Thanks a lot!!

BIDeveloper (BOB member since 2009-08-19)

2

Hi,

Do your reports use free-hand SQL or a universe?

If they are based on a universe then you need to open the universe in Designer and change its connection where you specify which ODBC to use.

If the reports are based on free-hand SQLs then you need to open each and every report in DeskI and change the connection parameters for every single data provider.

By the way, if possible, avoid using ODBC connections. It’s better to use native database connectivity (Oracle client for Oracle DB, OLEDB for SQL server, …). But if you don’t have a choice then ODBC should work as well.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi Mark,
Thankyou very much for the reply.
My report actually has a combination of data providers from universe as well as free hand SQL.
Followed what you said about the Universe connection parameters, but didn’t quite understand how and where to change the connection parameters in free hand sql data provider, can you please clarify in little more detail. Thanks again for your reply!!
Dont have much fliexibility to use OLEDB. Thanks for the suggestion though!!

BIDeveloper (BOB member since 2009-08-19)

4

Edit the freehand SQL data provider in the data manager…

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

5

Thanks Marek, Mak1. Issue is resolved.

Thanks for your help.

BIDeveloper (BOB member since 2009-08-19)