Toad allows you to connect to the presentation layer of an Oracle Business Intelligence Enterprise Edition (OBIEE) data source.
See also, About Oracle BI Enterprise Data Sources .
Note: This feature is available in the Toad Data Point Professional Edition only.
To create an Oracle Business Intelligence Enterprise connection
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
Enter the URL to the Oracle Business Intelligence Enterprise data source to which you want to connect.
Note: You must include the port number in the URL as in the following examples:
Enter the password to use when connecting.
Tip: After connecting, you can set a master password to further secure your connection in Tools | Options| Environment | Security.
Select a row limit to enforce for query results.
default = 500,000
|Category||(Optional) Select an existing category or create a new one. |
Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature.
Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
You must incorporate the port into the OBIEE database connection URL in the following format:
An example URL is http://server01.mycompany.com:80/analytics/saw.dll