16 Autonomous Database

Learn about how to access Oracle Data Transforms from Oracle Autonomous Database.

Topics

• Manually Register the Created Oracle Data Transforms Instance to Autonomous Database
  The RegisterODI.sh script allows you register your Oracle Data Transforms instance with Autonomous Database.
• Map Autonomous Database User to Data Transforms User
  The Administration tab of Oracle Data Transforms helps you to map the database user (created during provisioning) to Oracle Data Transforms User.
• Unregister the Oracle Data Transforms Instance from Autonomous Database
  The UnregisterODI.sh script allows you unregister your Oracle Data Transforms instance from Autonomous Database.
• Access Oracle Data Transforms From Database Actions page
  The Autonomous Database users can access the Oracle Data Transforms interface from the Data Tools tab present in Database Actions page, if the DB hosts the Oracle Data Transforms repository.
• 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.
• Enable Access to Private Data Sources from Autonomous Database
  The Autonomous Database from where you are accessing Data Transforms should be configured to use a private endpoint to be able to communicate with private database sources. Otherwise when you try to create and test such a connection, you might get a "failed to connect" error.
• Troubleshoot Mismatch with Server Cert DN Error
  For a connection on an Autonomous Database that is configured to use private endpoints, you must specify the distinguished name (DN) of the database server in the JDBC URL so that the Oracle Connection Manager (CMAN) can accept the request. Otherwise when you try to create and test such a connection, you might get a "Mismatch with Server Cert DN" error.