# Data connections
URL: https://docs.datarobot.com/en/docs/classic-ui/data/connect-data/data-conn.html

> Learn how to integrate with a variety of data sources using the 

# Data connections

> [!NOTE] Note
> If your database is protected by a network policy that only allows connections from specific IP addresses, have an administrator add all [allowed IPs for DataRobot](https://docs.datarobot.com/en/docs/classic-ui/data/connect-data/data-conn.html#allowed-source-ip-addresses) to your network policy. If the problem persists, contact your DataRobot representative.

The DataRobot connectivity platform allows users to integrate with their data stores using either the DataRobot provided connectors or uploading the JDBC driver provided by the data store.

The "self-service" database connectivity solution is a standardized, platform-independent solution that does not require complicated installation and configuration. Once configured, you can read data from production databases for model building and predictions. Connectivity to your data source allows you to quickly train and retrain models on that data, and avoids the unnecessary step of exporting data from your database to a CSV file for ingest into DataRobot. It allows access to more diverse data, which results in more accurate models.

Users with the technical abilities and permissions can configure and establish data connections. Other users in the org can then leverage those connections to solve business problems.

> [!NOTE] Availability information
> The ability to [add, update, and remove JDBC drivers](https://docs.datarobot.com/en/docs/platform/admin/manage-cluster/manage-drivers.html) and connectors is only available on Self-Managed AI Platform installations.
> 
> Required permission: Can manage JDBC database drivers

This page describes the following workflows:

- An overview of the database connectivity workflow .
- Steps for creating new connections .
- Steps for adding data sources .
- Steps for sharing data connections .

## Database connectivity workflow

By default, users can create, modify (depending on their [role](https://docs.datarobot.com/en/docs/reference/misc-ref/roles-permissions.html#shared-data-connection-and-data-asset-roles)), and share data connections. You can also create [data sources](https://docs.datarobot.com/en/docs/reference/glossary/index.html#data-source).

DataRobot's database connectivity workflow, described below, has two fundamental components. First, the administrator uploads JDBC drivers and configures database connections for those drivers. Then, users can import data into DataRobot for project creation and predictions, as follows:

1. From theData Connectionspage, createdata connectionconfiguration(s).
2. From the sameStartscreen or theAI Catalog, createdata sources—from the data connections—to use for modeling and predictions. Once configured, your data sources are available for both ingest from theStartscreen and for predictions from theMake Predictionstab.
3. (Optional) Depending onrole,sharedata connections with others.

There are additional opportunities to launch the data source creation dialogs, but these instructions describe the process used in all cases.

## Allowed source IP addresses

Any connection initiated from DataRobot originates from an allowed IP addresses. See a full list at [Allowed source IP addresses](https://docs.datarobot.com/en/docs/reference/data-ref/allowed-ips.html).

## Create a new connection

To create a new data connection:

1. From the account menu on the top right, selectData connections. You can also create a new data connection using theAI Catalogby selectingAdd to catalog>New Data Connection. All existing connections are displayed on the left. If you select a configured connection, its configuration options are displayed in the center.
2. To add a new data connection, clickAdd new connection.
3. Select the tile for the data store you want to use. Self-Managed AI Platform installationsFor Self-Managed AI Platform installations, you might not see any data stores listed. In that case, clickAdd a new driverand add a driver from thelist of supported connections.
4. Name the data connection (1), select an authentication method (2), and fill in the required fields (see the documentation for your specific data store). Note that the visible configuration options are the required parameters for the selected data store; therefore, these options vary for each data store. You can add more parameters underShow advanced options(3). Saved credentialsIf you previously added credentials for your datastore via theCredentials Managementpage, you can clickSelect saved credentialsand choose them from the list instead of adding them manually.
5. ClickAdd from connection; once selected, theSchematab opens.
6. TheSchematab lists the available schemas for your database—select a schema from the list. Once selected, theTablestab opens. To use a SQL query to select specific elements of the named database, click theSQL querytab.
7. Select the table(s) you want to register in the AI Catalog and clickProceed to confirmation. Each table will be registered as a separate catalog asset.
8. UnderSettings, select the appropriate policy (1) and data upload amount (2), then review and confirm your selections by clickingRegister in the AI Catalog.

> [!NOTE] Note
> Any connection that you create is only available to you unless you [share](https://docs.datarobot.com/en/docs/classic-ui/data/connect-data/data-conn.html#share-data-connections) it with others.

#### Data connection with parameters

The parameters provided for modification in the data connection configuration screen are dependent on the selected driver. Available parameters are dependent on the configuration done by the administrator who added the driver.

Many other fields can be found in a searchable expanded field. If a desired field is not listed, open Show advanced options and click Add parameter to include it.

Click the trash can icon ( [https://docs.datarobot.com/en/docs/images/icon-wb-delete.png](https://docs.datarobot.com/en/docs/images/icon-wb-delete.png)) to remove a listed parameter from the connection configuration.

> [!NOTE] Note
> Additional parameters may be required to establish a connection to your database. These parameters are not always pre-defined in DataRobot, in which case, they must be manually added.
> 
> For more information on the required parameters, see the [documentation for your database](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/index.html).

### Test the connection

Once your data connection is created, test the connection by clicking Test connection.

In the resulting dialog box, enter or [use stored](https://docs.datarobot.com/en/docs/platform/acct-settings/stored-creds.html) credentials for the database identified in the JDBC URL field or the parameter-based configuration of the data connection creation screen. Click Sign in and when the test passes successfully, click Close to return to the Data Connections page and create your [data sources](https://docs.datarobot.com/en/docs/classic-ui/data/connect-data/data-conn.html#add-data-sources).

Snowflake and Google BigQuery users can set up a data connection using OAuth single sign-on. Once configured, you can read data from production databases to use for model building and [predictions](https://docs.datarobot.com/en/docs/classic-ui/predictions/batch/batch-dep/batch-pred-jobs.html).

For information on setting up a data connection with OAuth, the required parameters, and troubleshooting steps, see the documentation for your database: [Snowflake](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-snowflake.html) or [BigQuery](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-bigquery.html).

### Modify a connection

You can modify the name, JDBC URL, and, if the driver was configured with them, the parameters of an existing data source.

1. Select the data connection in the left-panel connections list.
2. In the updated main window, click in the box of the element you want to edit and enter new text.
3. ClickSave changes.

### Delete a connection

You can delete any data connection that is not being used by an existing data source. If it is being used, you must first delete the dependencies. To delete a data connection:

1. From theData Connectionstab, select the data connection in the left-panel connections list.
2. Click theDeletebutton in the upper right ().
3. DataRobot prompts for confirmation. ClickDeleteto remove the data connection. If there are data sources dependent on the data connection, DataRobot returns a notification.
4. Once all dependent data sources are removedvia the API, try again to delete the data connection.

## Add data sources

Your data sources specify, via SQL query or selected table and schema data, which data to extract from the data connection. It is the extracted data that you will use for modeling and predictions. You can point to entire database tables or use a SQL query to select specific data from the database. Any data source that you create is available only to you.

> [!NOTE] Note
> Once data sources are created, they cannot be modified and can only be deleted [via the API](https://datarobot-public-api-client.readthedocs-hosted.com/page/reference/data/database_connectivity.html).

To add a data source, do one of the following:

- From theStartscreen, clickData Sourceand select the connection that holds the data you would like to add. See how toimport from an existing data source.
- From theAI Catalog, selectAdd to catalog>Existing Data Connection. See how toadd data from external connections.

## Share data connections

Because the user creating a data connection and the end-user may not be the same, or there may be multiple end-users for the data connection, DataRobot provides the ability to set user-level permissions for each entity. You can accomplish scenarios like the following:

- A user wants to set permissions on a selected data entity to control who has consumer-level, editor-level, or owner-level access. Or, the user wants to remove a particular user's access.
- A user that has had a data connection shared with them wants the shared entity to appear under their list of available entities.

When you invite a user, user group, or organization to share a data connection, DataRobot assigns the default role of Editor to each selected target (not all entities allow sharing beyond a specific user). You can change the role from the dropdown menu.

To share data connections:

1. From the account menu on the top right, selectData Connections, select a data connection, and clickShare:
2. Enter the email address, group name, or organization you are adding and select arole. Check the box to grant sharing permission.
3. ClickShareto add the user, user group, or organization.
4. Add any number of collaborators and when finished, clickCloseto dismiss the sharing dialog box.

Depending on your own permissions, you can remove any user or change access as described in the table of [roles and permissions](https://docs.datarobot.com/en/docs/reference/misc-ref/roles-permissions.html).

> [!NOTE] Note
> There must be at least one Owner for each entity; you cannot remove yourself or remove your sharing ability if you are the only collaborating Owner.

---
