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 > Connect to a data source. See Adding a connection to a project.
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

Projects

You can use Amazon RDS for Oracle connections in the following workspaces and tools:

  • Data Refinery (Watson Studio)
  • Decision Optimization (Watson Studio and Watson Machine Learning)
  • SPSS Modeler (SPSS Modeler service)
  • Watson Machine Learning Accelerator (Watson Machine Learning Accelerator service)

Catalogs

  • Platform assets catalog

Federal Information Processing Standards (FIPS) compliance

The Amazon RDS for Oracle connection cannot be created in a FIPS environment.

For Amazon RDS for Oracle connections in the Watson Machine Learning Accelerator service, see Known issues on FIPS-enabled clusters.

Amazon RDS for Oracle setup

To set up the Oracle database on Amazon, see these topics:

Learn more

Amazon RDS for Oracle

Parent topic: Supported connections