Toad Data Point 5.0 - User Guide

Create Oracle Business Intelligence Connections

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

  1. Click on the Connections toolbar (ALT+F+N).
  2. Select Oracle BI Enterprise from the Group list.
  3. Enter the connection information in the Create New Connection dialog. Review the following for additional information:

    URL

    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:

    format—http://<server path>:<port>/analytics/saw.dll

    example—http://server01.mycompany.com:80/analytics/saw.dll

    Password

    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.

    Row Limit

    Select a row limit to enforce for query results.

    default = 500,000

    Category (Optional) Select an existing category or create a new one. See Set Connection Categories for more information.

    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. See Security Options for more information.See Security Options for more information.

  4. Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.

  5. Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.

Important Information about Oracle BI Connections

You must incorporate the port into the OBIEE database connection URL in the following format:

http://<server name>:<port>/analytics/saw.dll

An example URL is http://server01.mycompany.com:80/analytics/saw.dll

Tips: 

  • Read about the considerations and limitations of working with OBIEE in Toad in About Oracle BI Enterprise Data Sources .
  • Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
  • You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.

  

Related Topics

Documentos relacionados