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.
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:
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:
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.
As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.