Connecting to Your Database

This final part walks you through using the wallet and SQLcl to establish a secure connection to your RDS ADW database. You will select a schema and service name, set the TNS_ADMIN variable, and verify successful connectivity.

In order to connect to your database, you will need:

  • a schema name and password

    • Choose a schema name and password from your schemas.json file.

  • a service name
    • Choose a service name from tnsnames.ora, something like <name>_low.
Login to your RDS ADW database using:
sql mfcs_rds_custom@<name>_low