Skip to content

On-premise users: click in-app to access the full platform documentation for your version of DataRobot.

Data > Data connections > Supported connections > Oracle

Oracle

There are two data connection types for Oracle Database: Service Name and SID. Use the appropriate parameters for the connection path you use to connect to Oracle Database.

Supported authentication

  • Username/password for both Service Name and SID

Prerequisites

The following is required before connecting to Oracle in DataRobot:

  • Oracle Database account

Required parameters

Service Name

The table below lists the minimum required fields to establish a connection with Oracle (Service Name):

Required field Description Documentation
address The connection URL that supplies connection information for Oracle. Oracle documentation
serviceName Specifies name used to connect to an instance. Oracle documentation

SID

The table below lists the minimum required fields to establish a connection with Oracle (SID):

Required field Description Documentation
address The connection URL that supplies connection information for Oracle.

Example:		 Oracle
SID A unique identifier for your database. Oracle documentation
port A unique identifier for your database. Oracle documentation

Troubleshooting

Problem Solution Instructions
When attempting to execute an operation in DataRobot, the firewall requests that you clear the IP address each time. Add all allowed IPs for DataRobot. See Allowed source IP addresses. If you've already added the allowed IPs, check the existing IPs for completeness.
Updated December 3, 2024