What's supported
Deployment types
When you create a deployment, you select a deployment type for your specific data management needs:
- Data replication
- Data transforms
- Stream analytics
The following lists detail the source and target technologies supported by each deployment type.
Connections supported in 23ai
Table - Connections supported by each deployment technology type
Technology type | Connection types supported |
---|---|
Oracle Database |
Note: Ensure that you apply the latest patches for the databases you use with OCI GoldenGate as recommended by Oracle Support. |
Big Data |
|
Db2 for z/OS |
|
Microsoft SQL Server |
|
MySQL |
|
PostgreSQL |
|
Generic |
|
For more information on build versions, see OCI GoldenGate Versions.
Connections supported in 21c
A connection contains the network connectivity details to a data source or target.
Table - Connections supported by each deployment technology type
Technology type | Connection types supported |
---|---|
Oracle Database |
Note: Ensure that you apply the latest patches for the databases you use with OCI GoldenGate as recommended by Oracle Support. |
Big Data |
|
Microsoft SQL Server |
|
MySQL |
|
PostgreSQL |
|
Generic |
|
For more information on build versions, see OCI GoldenGate Versions.
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 assigning 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).
Supported connection types for Stream Analytics
Table - Connections supported by Stream Analytics
Source or Target | Connection types supported |
---|---|
Sources |
|
Targets |
|
For more information on build versions, see OCI GoldenGate Versions.