Registering an On-Premises File

You register an on-premises file application when using the Quick Mode to load files using the EPM Integration Agent. This type of adapter enables customers to load very large files from on-premises file data source to the Oracle Fusion Cloud EPM. It extends the Quick Mode method where the Oracle Fusion Cloud EPM database is bypassed for staging and processing, eliminating any performance bottlenecks and improving the performance and scalability of the load process.

An on-premises file adapter requires no connection parameters or query. However, a delimited file with a header used for the import format is required for the load.

For more information on using the on-premises file data source, see Using an Agent File Adapter.

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

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

3. From Category, select Data Source.

4. From Type, select On Premise File.

   

5. From File, specify the source data file to use as the template.

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

   When selecting a file, note the following:

   • The source data file must be a delimited data file.

   • Data files used must contain a one-line header, which describes the delimited columns.

   • Both numeric and non-numeric data can be loaded.

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.