Skip to content

Click in-app to access the full platform documentation for your version of DataRobot.

Oracle Connector for Data Prep

User Persona: Data Prep User or Data Prep Admin

Note

This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.

Configure Data Prep

The ability to connect to Oracle is part of the Data Prep JDBC Connector. This topic provides details specific to setting up a connection to Oracle Database. See also the JDBC Connector Documentation to configure the connection.

Example JDBC URI:

jdbc:oracle:thin:yourOracleHost:yourOraclePort:XE

Technical Specs

Driver Specs

  • Oracle Database driver version: 19.3

  • Supported Oracle Database versions: 12.2.0.1, 18c, 19c

Driver Documentation

FAQ/Troubleshooting/Common Issues

Data Types Handling Troubleshooting

One rare item that has the potential to cause issues during export to an Oracle Database relates to a differing in how datatypes are handled between Data Prep and Oracle Database. Data Prep is designed to handle columns with mixed data types, where Oracle is not. Data Prep determines a column data type based on the predominant data type present in the column. This becomes an issue when Data Prep identifies the datatype in a column is boolean and exports the column as a boolean even though it still contains mixed datatypes. This should be addressed in Data Prep before exporting to Oracle.


Updated October 28, 2021
Back to top