Defining an On-Premises Data Source Application

You create an on-premises data source application when you need to extract data from your on-premises data sources and then load the data directly to the Oracle Enterprise Performance Management Cloud using the EPM Integration Agent. The EPM Integration Agent executes a query against an on-premises relational database and then loads the data to the EPM Cloud.

To create and register an on-premise data source application created for an extraction, you must create a file that contains only sample data with one header record. The file cannot not contain the application name or SQL query etc. The name of the file must be the name of the application.

Note:

For more information, see Extracting Data from On-premises Data Sources.

To create an on-premises data source application:

1. From the Data Integration home page, and then Actions, select Applications.

2. On the Applications page, click (Add icon).

3. On the Create Application page, and then Category, select Data Source.

   

4. From Type, select On Premise Database.

5. From File, specify the file that contains only sample data with one header record to be used for the on-premises application.

   The header row must exactly match the dimension name in the target dimension. You can use an alias for a column name in the SQL query to the dimension name.

   Click to search for a file from the File Browser page.

6. Optional: In 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.

7. Click OK.