About Data Transforms

Design graphical data transformations such as data flows and workflows to move and transform data between systems.

Data Transforms concepts

Whether you’re new to Data Transforms or have past experience with Oracle Data Integrator, it’s helpful to familiarize yourself with these concepts before starting with OCI GoldenGate Data Transforms. See Terminology Information in the Using Data Transforms guide to learn more.

Supported connection types for Data Transforms

See Supported Connection Types for a full list of connections that you can use with OCI GoldenGate Data Transforms.

Tip: For each connection type used with OCI GoldenGate Data Transforms, you must create a Generic connection, and assign the connection to the Data Transforms deployment.

After you assign the Generic connection(s) to the Data Transforms deployment, launch the console from the deployment details page and log in. In the Data Transforms deployment console, create a connection for each data source using the Host name(s) provided for the Generic connection(s).

Sizing considerations for Data Transforms

Ensure that you review the information in Metering and billing for OCI GoldenGate deployments about Oracle Compute Unit (OCPU) selection and scaling.

OCI GoldenGate Data Transforms OCPU usage is calculated based on the following factors:

While there are many other factors that impact performance, Oracle recommends starting with the following configuration:

After some real world testing, you can either keep the existing configuration or scale the deployment up or down manually.