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)
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
Projects
You can use Amazon RDS for Oracle connections in the following workspaces and tools:
- Data Refinery (Watson Studio or IBM Knowledge Catalog)
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Decision Optimization (Watson Studio and Watson Machine Learning)
- Metadata import (IBM Knowledge Catalog). See Supported data sources for metadata import, metadata enrichment, and data quality rules.
- SPSS Modeler (Watson Studio)
Catalogs
-
Platform assets catalog
-
Other catalogs (IBM Knowledge Catalog)
Note:Preview, profile, and masking are not certified for this connection in IBM 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