Connecting to Oracle Applications Data Sources

You can connect to Oracle Applications and create data sources that help you visualize, explore, and understand your Oracle Applications data.

Creating Oracle Applications Connections

You can create connections to Oracle Applications and use those connections to create data sources.

Use the Oracle Applications connection type to build connections to Oracle Fusion Applications with Oracle Transactional Business Intelligence and to Oracle BI EE. After you build the connection, you can access and use subject areas and analyses as data sources for your projects.
  1. In the Data Sources page, go to the Create pane, and click Connection.
  2. In the Create New Connection dialog, click the Oracle Applications icon.
  3. In the Add a New Connection dialog, enter a name for the connection, the Oracle Fusion Applications with Oracle Transactional Business Intelligence or Oracle BI EE URL, the login name, and login password.
  4. In the Authentication field, specify if you want the users to be prompted to log in to access data from the Oracle Applications data source. If you select Always use this username and password, then the login name and password you provide for the connection is always used and users aren’t prompted to log in. If you select Require users to enter their own username and password, then users are prompted to enter their user names and passwords to use the data from the Oracle Applications data source. Users required to log in see only the Oracle Applications data that they have the permissions, privileges, and role assignments to see.
  5. Click Save.
    You can now create data sources from the connection. See Composing Data Sources From Oracle Application Connections.

Note:

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

Composing Data Sources from Oracle Applications Connections

After you create Oracle Applications connections, you can use those connections to create data sources to use in projects.

You must create the Oracle Applications connection before you can create a data source for it. See Creating Connections.

  1. In the Data Sources page, go to the Create pane, and click Data Source.
  2. In the Create New Data Sources page, click the connection to the Oracle Applications that you want to use for your data source.
  3. In the Create Source dialog, browse or search for and select the analysis that you want to use. Note the following options:
    • Click Enter Logical SQL to display the Logical SQL Statement field. Use this field to write a SQL statement to fetch the data that you want to use in your data source.
    • Click Refresh Data to view a snapshot of the data in the analysis you selected.
    • Click a column’s gear icon to view its data type, specify if you want to treat the column as a measure or attribute, or set its aggregation type.
    • Click the General icon at the top of the dialog to specify a name and description for the data source.
  4. Click OK.
    The new data source is created and is included in the Oracle Applications section of the Display pane. The data source contains a cached copy of the data in the analysis that you selected, and you can refresh the data and metadata from that data source, as needed.

Editing Oracle Applications Connections

You can edit Oracle Applications connections. For example, you must edit a connection if your system administrator changed the Oracle Applications login credentials.

  1. In the Data Sources page, go to the Display pane, and click Connections.
  2. Locate the connection that you want to edit and click its Options icon and select Edit.
  3. In the Edit Connection dialog, edit the connection details. Note that you can’t see or edit the password that you entered when you created the connection. If you need to change the connection’s password, then you must create a new connection. See Creating Oracle Applications Connections.
  4. Click Save.

Deleting Oracle Applications Connections

You can delete an Oracle Applications connection. For example, if your list of connections contains unused connections, then you can delete them to help you keep your list organized and easy to navigate.

Note:

If the connection contains any data sources, you must delete the data sources before you can delete the connection. Oracle Applications connections are only visible to the user that creates them (connections aren’t shared), but a user can create data sources using those connections, and share the data sources with others.
  1. In the Data Sources page, go to the Display pane, and click Connections.
  2. Locate the connection that you want to delete and click its Options icon and select Delete.
  3. When asked if you want to delete the connection, click Yes.