Connectors
Operations Applications
Oracle Fusion Applications
5 min
oracle fusion cloud applications have everything you need to optimize your business, make faster and better decisions, and outpace change best of breed apps for your entire business—in any industry, next generation cloud infrastructure designed for saas applications, all on a standards based applications platform to easily extend, personalize and integrate applications dlh io just happens to be your best chance for getting data from oracle fusion cloud applications the way you need it applications supported dlh io currently supports several oracle fusion cloud applications, and the ability to integrate with other applications as well based on request these include financials and supply chain management oracle fusion financials docid\ yu5rxpz5w3s1ticg btrj human capital management oracle fusion hcm docid 3nauiju8zcyc5d63ohrud dlh io supports rest api and business intelligence cloud connector (bicc) capabilities which makes the dlh platform the optimal data integration platform for synchronizing your data inside or outside of oracle ask our customer success team about pushing data into your oracle fusion application systems in addition to exporting and synchronizing data how it works & syncs depending on your option to use the bicc approach or the rest api approach, both having their own merited use cases, the instructions differ rest api integration is the easiest to set up but depending on your data needs it can more engaged development to get core answers from joining the data to answer questions for your use case the benefit is that you get all the data you could possibly need from your fusion application using the bicc integration approach provides curated oracle extract data sets that are closer to having modeled relationships, where data engineering work is still required for building analytical reporting but conversely it is an easier lift than using data from the rest api integration for bicc sync configuration at a high level, you need to sign into your oracle fusion and bicc configuration ui and select the offerings (ex hcm) required for the data you need to have extracted configure the storage as oracle cloud storage (i e oci object storage) here’s a high level check list that you’ll run through for the initial bicc setup for dlh io configure an oracle cloud storage (i e oci object storage) bucket location extract data based on the required offerings or specific objects run an initial bicc extract and confirm data is landing in your oracle storage bucket connect dlh io to your oracle fusion bicc using the dlh io fusion bicc connector run incremental extracts if you need only the data that changed since your last extract monitor extracts and review logs on your fusion account manage refresh metadata and specify dates for incremental refresh comparison schedule bicc extracts to run at specified intervals using bicc dlh connects to your oracle fusion cloud instance and creates the necessary jobs for extracting data and observing and extracting primary keys that corresponds to changing data within your fusion apps this is typically only two new jobs created during your oracle fusion app bicc setup of the dlh connector job a creates a data extract job, dlh data extract \<app name> job b creates a current pks job, dlh current pks \<app name> all data lifecycles for incremental loading, etc are handled by dlh io when the dlh io sync bridge runs, the sync brige provides any updates to the jobs as required to filter for the incremental data (the deltas) to increase the speed of synchronization dlh io handles the seamless automation from the external object storage through to your target destination we understand that many oracle customers have unique busienss cases with their data and we are here to help even though the platform is self service, don't be scared if this is your case, just reach out to our customer success team one of the easiest ways to do so is to schedule a meeting on our calendar right now, on this link