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
Parent topic: Supported connections