To configure Oracle as a connection for replication pipeline, the following fields need to be configured:
- Connection: Specifies the name of data connection.
- Description: Allows you to describe the purpose of the data connection.
- Connection type: Select a connection from the dropdown list. When creating a new connection from a project, only connection types that can be used in that project type are present.
- Runtime Engine: Specifies the runtime engine to determine how data is replicated from the source to the target system.
-
Add Engine: Opens the Add runtime engine window. Note: For JDBC connections, only replication servers are displayed in the list of available engines.
- Database server hostname or IP address - Fully qualified hostname (FQDN) or IP address of the Oracle database server. The values are: hostname, IPv6 or IPv4 address.
- Instance name Name of an Oracle SID or service name. This is a required field.
- Port number Any port number from lower to upper possible port values. This is a required field.
- User name User ID credentials to allow access to test the connection to the database server and data source instance. This field is required to test the connection and the input will not be stored.
- Password Password credentials to allow access to test the connection to the database server and data source instance. This field is required to test the connection and the input will not be stored.
- JDBC driver version Select a version 11g or 12c from the dropdown list. This version will be used on the database server and it is a required field.
- Enable JDBC encryption Displayed when a JDBC driver version is selected. It is unchecked by default.
- Pluggable database Indicates if the database is a pluggable database. Displayed only if Oracle 12c is selected as the JDBC driver version.