Amazon RDS for Oracle connection
To access your data in Amazon RDS for Oracle, create a connection asset for it.
Amazon RDS for Oracle is an Oracle relational database that runs on the Amazon Relational Database Service (RDS).
Supported Oracle versions and editions
- Oracle Database 19c (19.0.0.0)
- Oracle Database 12c Release 2 (12.2.0.1)
- Oracle Database 12c Release 1 (12.1.0.2)
Create a connection to Amazon RDS for Oracle
To create the connection asset, you'll need these connection details:
- Either the Oracle Service name or the Oracle System ID (SID) for the database.
- Hostname or IP address of the database
- Port number of the database. (Default is
1521
)
- SSL certificate (if required by the database server)
For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.
- In a catalog
- Click Add to catalog > Connection. See Adding a connection asset to a catalog.
- In a deployment space
- Click Add to space > Connection. See Adding connections to a deployment space.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Where you can use this connection
You can use Amazon RDS for Oracle connections in the following workspaces and tools:
Projects
- Data Refinery (Watson Studio or Watson Knowledge Catalog)
- DataStage (DataStage service). See Connecting to a data source in DataStage.
Catalogs
- Platform assets catalog
- Other catalogs (Watson Knowledge Catalog)
Note: Preview, profile, and masking do not work for this connection in Watson Knowledge Catalog.
- Watson Query service
- You can connect to this data source from Watson Query.
Amazon RDS for Oracle setup
To set up the Oracle database on Amazon, see these topics:
Learn more
Parent topic: Supported connections