Creating Oracle Applications Connections

You can create connections to Oracle Applications and use those connections to source data in projects.

To create Oracle Applications connections:
  1. Launch the Add a New Connection dialog using one of these actions:
    • On the Data Sources page, click Connections, and then Add Connection.
    • In the project Data Sources pane, click the Add Data Source link, then Create a New Source, and then From Oracle Applications.
    • In the project Data Elements pane, right-click anywhere in the pane and select Add Data Source.
  2. In the Add a New Connection dialog, enter the connection name, catalog URL, user name, and password.

    Note:

    Http and Https URLs are supported. Connection names must be unique and cannot contain any special characters.

    Note:

    You can get the connection URL by opening the Oracle Applications, displaying the catalog folders that contain the analysis you want to use as the data source for projects, and copying the browser URL into the New Connection dialog, making sure to strip off anything after /analytics. For example, http://www.example.com:9704/analytics.
  3. Click Save.
    You can now begin creating data sources from the connection. For more information, see Composing Data Sources From Oracle Application Connections.

Note:

The connection is only visible to you (the creator), but you can create and share data sources for it.