Introducing Oracle Data Transforms - Oracle Data Integrator (ODI) powered ELT tool on Oracle Cloud Marketplace

April 23, 2021 | 3 minute read
Anuradha Chepuri
Consulting User Assistance Developer, Oracle
Text Size 100%:

Guest Post by Chandralekha Balachandran, Senior User Assistance Developer, ODI

Are you looking for an easy, flexible, and yet a robust tool for performing all your data transformations on cloud platform? Do you want to get rid of writing complex codes to transform your data? If your answer is yes, then try our new Oracle Data Transforms application, deployed using ODI Web Edition listing on Oracle Cloud Marketplace.

What is Oracle Data Transforms?

A new evolution in data transformation, an enterprise class-web-based integration platform to build solutions to load and transform data by using an Extract Load Transform (ELT) model. It is a new successor to Oracle Data Integrator (ODI) which is a market leader in Data Integration on both on premise and cloud platforms.

Here is an architecture overview of Oracle Data Transforms Application:

Image Courtesy: Jayant Mahto, Software Development Senior Manager, Oracle Data Integrator

Some of the key features of Oracle Data Transforms Application are:

  • A brand new, simple, easy-to-use graphical user interface for data integration
  • Allows to design and execute Data Flows and Workflows on the fly
  • Execute the Data Flows and Workflows immediately or schedule to execute them at a later time
  • Easy to deploy and no need of high infrastructure and support
  • Regular ODI listing available in parallel which has full capability of the product
You can perform the following functions through Oracle Data Transforms application:

Connections help you to connect the Data Transforms to various technologies on Oracle Cloud Marketplace. Oracle Data Transforms supports many data sources other than Oracle DB, such as Oracle Fusion Applications and third party databases.

Here's a snapshot on creating Connections:

After the database connection is successfully established, import the data entities to read the tables/columns metadata.

Once the data entities are imported you can you can drag and drop the required data entities and transformation components on the design canvas to create a Data Flow or Workflow.

The data flow defines how the data is moved and transformed between different systems, while the workflow defines the sequence in which the data flows are executed.

Here is how a Data Flow or Workflow Editor looks:

After your Data Flow or Workflow is ready you can run it immediately or schedule it to run for a later time.

Watch this video that illustrates on how to create and execute a simple Data flow or Workflow using Oracle Data Transforms application:

Want to Know More?

Reviewed and Approved by: Jayant Mahto, Software Development Senior Manager, Oracle Data Integrator,  Aslam Khan, Senior User Assistance Development Manager, and Anuradha Chepuri, Principal User Assistance Developer, Oracle GoldenGate.

Anuradha Chepuri

Consulting User Assistance Developer, Oracle

As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.

Previous Post

OCI GoldenGate is first of any major cloud provider to deliver operational and analytic integration into a single data fabric

Denis Gray | 6 min read

Next Post

Scheduling tasks in Oracle Cloud Infrastructure (OCI) Data Integration

Rohit Saha | 4 min read