The Data Transforms Page
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.
- 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.
- Database Actions Data Studio: Navigate to Database Actions Data Studio Page, and click Data Transforms in the Database Actions page.
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.
If you do not see the Data Transforms card then your database user is missing the required DATA_TRANSFORM_USER role.
- 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.
Topics
- 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. - Data Loads
A data load allows you to load multiple data entities from a source connection to a target connection. - 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. - Variables
A variable is an object that stores a single value, which can be a string, a number or a date. - Machine Learning (ML) Models
Data Transforms supports the use of ML Model in a data flow. Learn how to create and use Machine Learning (ML) Models in data flows. - 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 and Import Objects
You can move Data Transforms objects between environments. You require an Object Storage connection to store the exported file. You then need to use the same Object Storage connection to import the objects. - Reference
Get additional information about using Oracle Data Tranforms on an Autonomous Database.
Parent topic: Transform Data Using Data Studio