Oracle (optimized) connection
To access your data with the Oracle (optimized) connection, create a connection asset for it. This connection works with the DataStage Oracle (optimized) connector, which has exclusive features for DataStage.
Oracle is a multi-model database management system.
- Oracle 23c
- Oracle 21c
- Oracle 19c
- Oracle 18c
- Oracle 12.2.0 and 12.1.0
- Oracle 11.2.0
Create a connection to Oracle with the Oracle (optimized) connection
To create the connection asset, you need these connection details:
- Hostname or IP address
- Port number
- Service name or Database (SID)
- Username and password
Choose the method for creating a connection based on where you are in the platform
Next step: Add data assets from the connection
Where you can use this connection
You can use the Oracle (optimized) connection in the following workspaces and tools:
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Platform assets catalog
Running SQL statements
To ensure that your SQL statements run correctly, refer to the Oracle Supported SQL Syntax and Functions for the correct syntax.
Parent topic: Supported connections