Get started
Yandex Data Transfer

Configuring an Oracle source endpoint

Written by

When creating or updating an endpoint, configure connection settings to Oracle.

settings

The settings are given for the OnPremise use case when all fields are filled in manually.

  • Connection: Select the Oracle cluster connection type.

  • For the Instance connection type:

    • Host: Enter the IP address or FQDN of the host you want to connect to.

    • Database port: Set the number of the port that Data Transfer will use for the connection.

    • Type: Specify Oracle SID or Service Name in the respective field below.

  • For the TNS connect string connection type, specify the Oracle RDBMS connection string in the respective field below.

  • Username: Specify the username that Data Transfer will use to connect to the database.

  • Password: Enter the user's password to the database.

  • PDB container: Specify the name of the PDB container to connect to. Leave the field empty if you are not using the CDB environment.

  • List of included tables: Data is only transferred from the listed tables. It is set using regular expressions.

  • List of excluded tables: Data from the listed tables is not transferred. It is set using regular expressions.

    Both lists support expressions in the following format:

    • <schema name>.<table name>: Fully qualified table name.
    • <schema name>.*: All tables in the specified schema.
    • <table name>: Table in the default schema.

  • Convert "number" type to "int64": Enable this option to convert the type from NUMBER (without parameters) to INT64. Parameterized NUMBER (precision, scale) types are automatically converted to integer types whenever possible.