Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Connecting to an Oracle Data Warehouse Source Database

Use the following procedure to connect to your Oracle data warehouse source database with the AWS Schema Conversion Tool (AWS SCT).

To connect to an Oracle data warehouse source database

  1. In the AWS Schema Conversion Tool, choose Connect to Oracle DW.

    
                        Connect to source database

    The Connect to Oracle dialog box appears.

    
                        Oracle connection information
  2. Provide the Oracle Data Warehouse source database connection information. Use the instructions in the following table.

    For This Parameter Do This
    Type

    Choose the connection type to your database. Depending on your type, provide the following additional information:

    • SID

      • Server name: The DNS name or IP address of your source database server.

      • Server port: The port used to connect to your source database server.

      • Oracle SID: The Oracle System ID (SID). To find the Oracle SID, submit the following query to your Oracle database:

        SELECT sys_context('userenv','instance_name') AS SID FROM dual;

    • Service Name

      • Server name: The DNS name or IP address of your source database server.

      • Server port: The port used to connect to your source database server.

      • Service Name: The name of the Oracle service to connect to.

    • TNS Alias

      • TNS file path: The path to the file that contains the Transparent Network Substrate (TNS) name connection information.

      • TNS file path: The TNS alias from this file to use to connect to the source database.

    • TNS Connect Identifier

      • TNS identifier: The identifier for the registered TNS connection information.

    User name and Password

    Type the user name and password to connect to your source database server.

    Note

    AWS SCT uses the password to connect to your source database only when you create your project or choose the Connect to source option in a project, where source is your source database. To guard against exposing the password for your source database, AWS SCT doesn't store the password. If you close your AWS SCT project and reopen it, you are prompted for the password to connect to your source database as needed.

    Use SSL

    Select this option if you want to use SSL to connect to your database. Provide the following additional information, as appropriate, on the SSL tab:

    • SSL Authentication: Select this option to use SSL authentication for the connection.

    • Trust Store: The location of a trust store containing certificates.

    • Trust Store Password: The password for the trust store.

    • Key Store: The location of a key store containing a private key and certificates. This value is required if SSL Authentication is selected and is otherwise optional.

    • Trust Store Password: The password for the key store. This value is required if SSL Authentication is selected and is otherwise optional.

    Oracle Driver Path

    Type the path to the driver to use to connect to the source database. For more information, see Installing the Required Database Drivers.

    If you store the driver path in the global project settings, the driver path doesn't appear on the connection dialog box. For more information, see Storing Driver Paths in the Global Settings.

  3. Choose Test Connection to verify that you can successfully connect to your source database.

  4. Choose OK to connect to your source database.

Related Topics

On this page: