Version 23.0.9145

• Connecting to Other Data Stores
  • .NET Edition
  • Java Edition

After you deploy CData API Server, you need to define the connection to your data store from the API Server Administration Console. API Server supports connecting to relational databases, file stores, and back-end services such as other APIs. Any JDBC driver or ADO.NET provider can supply connectivity to the underlying data source. However, several drivers and providers are installed already.

To connect, follow these steps:

1. Select Settings > Connections in the admin console. Then, click Add Connection.

2. Select the connection type (driver). Then, specify a name for the connection.

3. Enter authentication values and other connection properties.

Connecting to Other Data Stores

If API Server does not contain a driver for your data source already, see the following sections.

Note: You can add CData drivers only (no third-party drivers).

.NET Edition

After you install the ADO.NET provider for your data source, you can select the data source as follows:

1. Download and install the CData .NET provider for this data source.

2. Restart API Server.

3. Select the data source from the Connections menu.

Java Edition

To select a data source:

1. Copy the JDBC driver to the lib folder of your Java web server.

2. Restart API Server.

After the server restarts, you can select the data source under the Applications & NoSQL or Other categories.