1.1 Introduction to Oracle Data Transforms

Oracle Data Transforms allows you to design graphical data transformations in the form of data loads, data flows, and workflows. Data Loads provide a convenient way of loading data into Oracle Autonomous Database.

Oracle Data Transforms provides an easy-to-use user interface to create your data loads, data flows, and workflows without requiring you to write any code. Data flows define how the data is moved and transformed between different systems, while the workflows define the sequence in which the data flows are executed. You can drag and drop the components, that is data entities and operators, such as Join, Split, and Aggregate, on the Design Canvas of the Data Flow editor and connect them to complete you data flow. You can then add your data flows to workflows.

After your data flows and workflows are ready, you can execute them immediately or schedule to execute them at a later time. Oracle Data Transforms run-time agent orchestrates the execution of jobs. On execution, Oracle Data Transforms generates the code for you.

Oracle Data Transforms integrates with Oracle Autonomous Database (Autonomous Data Warehouse and Autonomous Transaction Processing) for repository creation as well as for loading data. The Oracle Data Transforms Repository is automatically setup at provisioning. Objects developed or configured by the users are stored in this repository.

Oracle Data Transforms has many concepts similar to Oracle Data Integrator (ODI), however, the terminology used is different. If you are familiar with ODI, then reviewing the Terminology Information section may be helpful to you. See Terminology Information.

You can launch Data Transforms in any of the following ways:

• Oracle Cloud Marketplace: Create a Data Transforms instance from Oracle Cloud Marketplace. Data Transforms is available as a separate listing on Marketplace called Data Integrator: Web Edition.
• Autonomous Database Data Tools Page: Navigate to Autonomous Database Data Tools Page, and click Data Transforms in the Database Actions page, or click the Selector icon and select Data Transforms from the Data Tools menu in the navigation pane.

  If you have already registered a Data Transforms instance from OCI Marketplace with the Autonomous Database, the Data Transforms card on the Database Actions page will continue to take you to your Marketplace instance

Access to the standard set of Data Transforms features may depend on where you launch Data Transforms from. In this documentation, certain topics could include any of the following badges to indicate content that may or may not be available for use:

• APPLIES TO: Data Transforms that is available as a separate listing on Marketplace called Data Integrator: Web Edition.
• APPLIES TO: Data Transforms instance that is registered with Autonomous Database.
• APPLIES TO: Data Transforms that is part of the suite of data tools built into Oracle Autonomous Database.