Oracle Fusion Financials

https //www oracle com/erp/financials/ gives your finance team better data to increase forecasting accuracy, shorten reporting cycles, simplify decision making, and better manage risk and compliance oracle fusion cloud financials is a global financial platform that connects and automates your financial management processes, including payables, receivables, fixed assets, expenses, and reporting, for a clear view into your total financial health dlh io is your best option to synchronize your oracle fusion financials data to other target destination systems like snowflake, databricks, and oracle data warehouse setup instructions dlh io securely connects to your oracle fusion cloud system using the form in the dlh portal you'll complete the following basic steps to capture the information from your oracle cloud account follow these initial steps in order to configure the rest api the following checklist should be followed you have created your oracle fusion application instance ( https //docs oracle com/en/cloud/get started/subscriptions cloud/csgsg/create instance html , if needed) create a new oracle fusion service account user specifically for the dlh integration assign the appropriate permissions to the new service account the user should have the ora asm application impelemntation consultant job role see the oracle fusion hcm rest api security role concepts ( alt ), as needed capture the new permissions credentials and information to be used in configuring the connection in dlh io create an oracle fusion app (ex hcm, finance, etc ) connection in dlh io (datalakehouse io) by applying the correct connection information and credentials select the desired tables/entities that you wish to synchronize to your target destination connect your target connection in dlh and build a dlh sync bridge run the dlh sync bridge review your landed data in your selected target destination connection query and build on the data from your target destination create new dlh io connector to oracle fusion financials in your dlh io account click on sources and locate or search for the oracle fusion financials connector and click on the corresponding add source button enter a name or alias for this connection, in the name/alias field, that is unique from other connectors enter in the target schema prefix field, a name which will be the prefix for the schema at the target destination to where your data will sync enter in the server url your unique oracle fusion app account url this will the first part of the url in your oracle fusion application in your address bar, for example, https //xxxxxxx fa us2 oraclecloud com enter in the user field your username for oracle fusion enter in the password field your oracle fusion password click the authorize your account button once your credentials are accepted you should see a successful connection confirmation message if you require a different authorization method please contact the dlh support and customer success teams for assistance supported features this table lists out some of the features supported and potential roadmap items for this connector if you have any questions please reach out to our docid\ pbtuxndqrdogoroejbgsv team feature name supported details custom data and development yes ability to enhance connector upon request historical load yes incremental/delta load yes gets most recent records and changes column selection yes column hashing yes re sync table/entity yes selecting specific table to reload historical data on next sync bridge run custom queries yes utilizing sql data query connector schema information provided upon requests https //calendly com/datalakehouse/demo we talk data for breakfast, lunch, and dinner so, if you have any questions please send us a note on our https //support datalakehouse io