Connect to Oracle

On this page

About this Task

Steps
Database Connection String
Connect to Oracle
Learn More

This page shows how to save a new Oracle connection from the Connections page. You can use a saved connection for any Relational Migrator task that requires connecting to a database.

About this Task

To save a new Oracle connection in Relational Migrator, you must:

Identify your database connection string or database information.
Connect to Oracle.

Important

To plan your migration and map your Oracle schema to a MongoDB schema, you must connect using an account with the correct read permissions.

To migrate data, you must connect to your Oracle database using a service account with the required permissions.

For information on database configuration and required permissions, see Configure Oracle.

Steps

Database Connection String

The Oracle connection string looks like:

jdbc:oracle:thin:@<host:port>:SID

For example, the Oracle database running on prodHost at port 1521 with the ORCL SID uses the following connection string:

jdbc:oracle:thin:@prodHost:1521:ORCL

Alternatively, Relational Migrator can create the appropriate connection string based on user-provided database information.

Note

To learn more about Oracle connection strings, see:

Connect to Oracle

Add a connection

In the list of Relational connections, click + Add connection.

Select the database type

In the Database type drop-down, select Oracle.

To enter a connection string directly:

Above JDBC URI, enable the Enter URI manually toggle.
Paste your connection string into the JDBC URI.

To create a connection string, enter the following:

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. Required.
Identifier	One of Service Name or SID.
Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

Identify the connection

Enter a Connection name and optional Environment tag.

Environment tags color code and organize connections for convenience. Leaving the drop-down empty is the same as selecting the "None" tag.

(Optional) Click Test connection

Relational Migrator attempts to authenticate and connect to the database.

Click Save

The saved connection is available for use in all jobs and projects.

Learn More

Relational Migrator relies on the open-source Debezium connector to capture row-level changes. For more details, see Debezium Oracle
For details on enabling archive logging, see Managing Archived Redo Logs.
For additional troubleshooting and debugging information, see the Debezium Oracle help blog post.

For information about supported databases and versions, see Source Databases and Versions.
For information on managing saved connections, see Manage Database Connections.
For information on Relational Migrator projects, see Create and Manage Projects.

Back

Configure MySQL

Configure Oracle