Oracle Fusion HCM

oracle fusion cloud human capital management (hcm) is a complete human resources cloud solution that connects every human resource process—and every person—across your enterprise it enables creation of a community within your organization where people feel valued, heard, and like they belong dlh io is your best option to synchronize your oracle fusion hcm 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 ( see how , 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 customer support 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 request oracle fusion hcm schema information issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com