Data Transforms is an easy-to-use graphical user interface that Oracle Autonomous Database users can use to design graphical data transformations for data integration.

Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows, without requiring you to write any code. Data loads provide a convenient way of loading data into Autonomous Database, 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.

After your data flows and workflows are ready, you can execute the mappings 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.

• Access Oracle Data Transforms From Data Studio
  Data Transforms combines all the elements of data integration - data movement, data synchronization, data quality, and data management to ensure that information is timely, accurate, and consistent across complex systems.
• Data Transforms Notes
  Notes for using Data Transforms.
• Work with Connections
  Connections help you to connect Data Transforms to various technologies reachable from your OCI network.
• Create a Data Load
  A data load allows you to load multiple data entities from a source connection to a target connection.
• Run a Data Load
  After you create the data load, you are taken to the Data Load Detail page that displays the details that you need to run a data load.
• Work with Data Entities
  A Data Entity is a tabular representation of a data structure.
• Work with Projects
  A project is the top-level container, which can include multiple folders to organize your data flows or work flows into logical groups.
• Create a Data Flow
  A data flow defines how the data is moved and transformed between different systems.
• Schedule Data Flows or Workflows
  You can schedule workflows and data flows to run at specified time interval.
• Monitor Status of Data Loads, Data Flows, and Workflows
  When you run a data load, data flow, or workflow Oracle Data Transforms runs jobs in the background to complete the request. You can view the status of the job in the panel on the bottom right of the Data Load Details, the Data Flow Editor, and the Workflow Editor page.
• Introduction to Workflows
  A workflow is made up of multiple flows organized in a sequence in which they must be executed.
• Create a Variable
  A variable is an object that stores a single value, which can be a string, a number or a date. You can specify the value of the variables when you create the variable or set the value using a query expression.
• Create and Manage Jobs
  When you execute a data load, data flow or workflow Oracle Data Transforms creates a job to complete the process in the background.
• Export Objects
  You can export Data Transforms artifacts such as projects, connections, data loads, data flows, workflows, and schedules from one environment and import them to another.