Source Connection

The migration creation process begins with providing general information and source connection details.

The migration name and description are used solely for identification purposes and can be changed at any time.

The CYBERTEC Migrator functions by querying the schema catalog of the source database. This process requires a connection string, a username and a password. Alternatively, an Oracle Wallet can be used if configured.

The connection string must adhere following format [oracle://]host[:port]/database_name[?parameter=value]

protocol optional string

Declares the DBMS. Allowed values: oracle

Default: oracle

host required string

The hostname or IP address of the target database. Ensure that the CYBERTEC Migrator can access this machine.

Default: none

port optional int

The port on which the target database is accessible.

Default: 1521

database_name required string

The SID or service name of your database.

Default: none

parameter optional string

Optional connection parameters. Multiple parameters may be split with &.

The following parameters are currently supported:

• protocol (allowed values: tcp, tcps)

Default: none

127.0.0.1/pdb1
oracle://localhost:1521/pdb1
oracle://secure-host:2484/tcps-database?protocol=tcps

The credentials to be used with the connection string. The provided user must have certain permissions.

After entering all the required information, submit the form to confirm that the CYBERTEC Migrator can establish a connection.

Should you encounter an error during this phase, please refer to our FAQ.

In order to function, the provided user requires the following permissions on Oracle:

The connection to the source database is now established, and the user’s permissions have been verified as sufficient. The next step involves selecting the schemas for migration.