Forum Discussion
Connect to OBIEE RPD using ODBC Connection
arify, By database parameter, do you mean the last page of configuring the DSN where you select a database and input login credentials?
If so, then no I did not do that. I have tried to in the past, but everytime I do it, it pops up with a dialog box and a yellow "!". After checking the settings again, it doesn't look like the credentials were saved or anything.
Example:
That.. looks sad. It doesn't look like this is a properly working driver. Luckily we have other things to try as a workaround :)
- You can try connecting via using connection string instead of DSN. In PBI, when you click ODBC, instead of picking a DSN, you would type a connection string. I'm guessing it would be like: Driver={yourdrivername}; Host=yourservername; Database="Procurement and Spend - Purchase Orders"
It probably won't work on your first try, you might need to add more parameters or change some of the keys (for example Server (or Hostname) instead of Host, or Db instead of Database etc.) Unfortunately I don't know about OBIEE and I couldn't find an example connection string on the internet (I only looked for a few minutes).
2. (This is probably easier) On the PBI's ODBC dialog where you pick the DSN, after picking the DSN, you can expand "Advanced Options" and enter a SQL query (e.g. select * from db.tablename)