Contact usConsole
© 2023 Nebius Israel Ltd
Data Transfer

Configuring an Oracle source endpoint

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 type: 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.

    • 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.

  • User: 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.

  • Included tables: Data is only transferred from listed tables. This option is specified using regular expressions.

  • Excluded tables: Data from the listed tables is not transferred. This option is specified using regular expressions.

    The lists include the name of the schema (description of DB contents, structure, and integrity constraints) and the table name. 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 the "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.