Connecting to Custom Connectors with JDBC Drivers

Using the Sisense Custom Connector Platform

Users can connect to any data JDBC-compatible data source. This page describes how to retrieve the relevant JDBC driver.

  1. Check whether the data source vendor has a JDBC driver. See Custom Connectors Using Vendor JDBC Drivers.

  2. If the data source does not have a JDBC driver, check whether CData has a driver for the desired data source. CData is commonly used for CRM, marketing, social, or ERP applications, or no-SQL engines, such as, Google Analytics. See CData Drivers.

The drivers are provided by the data source vendors. For example:

Data Source Driver Class
ClickHouse com.clickhouse.jdbc.ClickHouseDriver
Firebolt com.firebolt.FireboltDriver
IBM DB2 com.ibm.db2.jcc.DB2Driver
TrinoDB io.trino.jdbc.TrinoDriver

 

CData is a certified partner of Sisense that provides drivers for many of the Sisense custom connectors, without further cost. This page provides generic instructions about connecting to CData connectors that are not covered by specific instructions in Sisense documentation.

The support for the connector is provided by Sisense and will be assisted by the certification partner's support, if needed. For any support issues or additional functionality requests, contact your Sisense representative or open a request through the Sisense Help Center. For advanced inquiries specific to driver functionality, you can also contact the certification partner's support directly via support@cdata.com.

After you have downloaded the driver, you can connect to your application through a connection string in Sisense . The connection string is used to authenticate users that connect to your application's APIs. Once you have connected to the application, you can import a variety of tables from the application's API.

This page describes how to download the required driver and deploy it, how to connect to your application with a connection string, and more.

For the list of supported connectors, see Data Source Connectors.

Downloading and Installing the Custom Driver from CData for Your Application

You can download the custom driver for your application here .
For a short video about downloading the driver, see below (the video uses the Box driver as an example).

Note:

The minimum compatible Java version for the driver is Java version 17.


For a short video of the installation process, see below (the video uses the Box driver as an example).

CDATA JDBC Drivers for Cloud

If you are a cloud customer, you can also install CDATA JDBC drivers:

  1. Download the driver locally (see the first video above).

  2. Install the driver locally (see the second video above).

  3. Deploy the custom connector. In step #6, use the JAR files from the local computer (from the lib folder where the driver is installed) to populate the mandatory parameters.

Connecting to Your Application via a Connection String

To access your application from Sisense , you must create a connection string and provide it to Sisense .

See Deploying a Custom Connector and Creating a Custom Connection.

Follow the above instructions only on first connect, and then when your credentials to the application change.

To help you create a connection string and test the connection, see Connection String Builder for Certified Connectors.

If you have any issues connecting to your data source, see Troubleshooting JDBC Data Connectors.

Limitations

  • The driver samples the first X rows and determines the column type. When Sisense finds rows within the data that does not match the column type, Sisense driver returns an error.