Creating Query-based Data Source Application

You can extract data from the Oracle Autonomous Database by executing a relational database SQL query against a database in the Oracle Autonomous Database.

Prerequisites

Before creating the query-based data source application, you must do the following:

  • Create a file that contains one header row from the source data. The header row must exactly match the dimension name in the target dimension. Save the file as a CSV format file with a header row. You must upload this file when creating a query-based data source application.
  • Create a query. For details, see Creating an SQL Query. The parameters you specify in the query must match the column names. You can use an alias for a column name in the SQL query as the dimension name.

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 you've created.
    • 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: