Skip to main content

Oracle

Integrate Your Data using Oracle Data Integration Platform Cloud

Oracle Data Integration Platform Cloud (DIPC)

DIPC is a unified, powerful, data-driven data integration platform on cloud which can accept data in any format from any source system either on premise or on cloud and process that data as per organization needs. With DIPC, you get all the capabilities of most popular E-LT (Extract – Load Transform) tool – Oracle Data Integrator. You also get otherwise time-consuming Data processing features like Data Synchronization, Data Replication and Data preparation with just a few clicks.

Make sure you have a Database Cloud Service already configured and then use Data Integration Platform Cloud Service to create a DIPC instance on Oracle Cloud.

Data Integration, Data Quality and Data Governance have been successfully unified in DIPC. Below is a screenshot of a typical DIPC home page.

  • Catalog – You can create connections, tasks, jobs etc.
  • Monitor – You can monitor your running jobs, tasks etc.
  • Agents – By default, a cloud agent is created to be able to run the tasks/jobs. You can also create agents.
  • Policies – You can configure job/task fail/pass/start/complete notifications
  • Admin – You can track the Default Object storage and data processing usage statistics
Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

 

DIPC Data Processing Methods

Please refer to Catalog Create options in the screenshot

  • Create Connections to Oracle, MySQL, Salesforce, Microsoft SQL Server, files, Kafka connect etc.
  • Create Synchronize Data task to synchronize data between a source and a target system with flexibility to pick and choose the Data elements to synchronize
  • Create ODI (Oracle Data Integrator) Execution Task to call any ODI scenario and perform any operation which can be performed via ODI
  • Create Replicate Data task to replicate data from one source to a new target system with flexibility to pick and choose the Data elements to synchronize
  • Create Data Lake Builder task to start loading data from different source systems to an already configured Data Lake
  • Create Data Preparation task to prepare or transform data from a source system before loading it to a target system

ODI Console

  • ODI is an Oracle owned premium and highly flexible scalable E-LT tool which works on Pushdown Methodology.
  • Using DIPC, you can create ODI Mappings/Packages/Scenarios using ODI Console.
  • On the top right corner of DIPC home page, Please click on your profile pic to see Open ODI option.  Click Open ODI open to open ODI Console.

  • Use Browse tab to build a project, Reverse engineer model, define Physical and Logical architecture in topology, Configure variables
  • Use Management tab to configure security and other repository level tasks

 

 

Please stay tuned for more detailed topics around DIPC in my future posts.

 

 

Thoughts on “Integrate Your Data using Oracle Data Integration Platform Cloud”

  1. Does the DIPC ODI Console open up in the internet browser window or do we need to install odi console as a client software locally?

  2. pradip devadiga

    Mazen,
    Thank you for the question. DIPC ODI Console opens up in the internet browser without any installation. On the right hand top corner of DIPC home page, if you click on the profile pic, you will see Open ODI option. If you click on that option, ODI Console will open up in a new internet browser tab.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.