Using the EPM Integration Agent to execute a SQL statement against a delimited file
(Doc ID 2922689.1)
Last updated on MARCH 14, 2024
Applies to:
Oracle Financial Consolidation and Close Cloud Service - Version 22.12.54 and laterOracle Enterprise Planning and Budgeting Cloud Service - Version 22.12.54 and later
Oracle Account Reconciliation Cloud Service - Version 22.12.54 and later
Oracle Enterprise Profitability and Cost Management Cloud - Version 22.12.54 and later
Information in this document applies to any platform.
Goal
There are cases where a customer is processing a text file with Data Integration, and they require functionality that is not provided by either expressions or mapping, or cases where the user wants to only process a portion of the input file. In the current version of Data Integration, you must load the entire file, and then use expressions, mapping, or IGNORE commands to transform the data file before loading to the target Cloud EPM business process.
To assist with some of these requirements, users are able to use an open source JDBC driver that treats a text file as a database table, and will allow simple SQL statements to filter a file, or perform simple transformations with a SQL statement. Actions like combining source columns, text functions like UPPER, and other SQL functions are supported.
This is a JDBC driver that is available as an open source solution, is not supported by Oracle, and the user can utilize at their discretion. This JDBC driver is used in conjunction with the EPM Integration Agent, and it treats the data file as a database table. See below for instructions on how to use this option with the Agent.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |