Creating Query-based Data Source Application

Before creating the query-based data source application, you must create a query. For details, see Creating an SQL Query. The parameters you specify in the query must match the column names.

To create a query-based data source application:

  1. On the Data Integration home page, from the Actions menu, click Setup and then click Applications.

  2. Click Image shows the Add icon (Add icon).
  3. Specify the following:
    • Category: Select Data Source.
    • Type: Select Oracle Autonomous Database – Direct (Query).
    • File: Upload the header file.
    • Prefix: Specify a prefix to make the application name unique. The prefix is concatenated with the application name to form a unique application name. For example, if you want to name an application with the same name as an existing one, you can assign your initials as the prefix.
  4. Click Save.
  5. Edit the application details and the integration-level filters. For details, see: