There are many additional DB that don't come as part of Sisense out of the box, however Sisense has a partnership with CDATA a data access and connectivity solutions company. Using Sisense Generic JDBC connection we can connect to all JDBC connectors provided.
A full list of the drivers Sisense and CDATA have certified for use with Sisense can be found here:
Sisense Certified Connectors
We recommend you start with this page of connectors in case there is a native Sisense connector before using the Generic JDBC driver from CDATA or another Technology Partner: Sisense Data Connectors
How to Connect
- Download the relevant JDBC connection from the CDATA site.
First start with this webpage to download the driver directly: CDATA Sisense Certified Connectors
For example, you can directly download the Instagram driver as shown below:
You can also easily find the connector by web searching for <connector DB> JDBC cdata for example "instagram JDBC cdata", Enter the CDATA site and download the JDBC connector > download the trial
You will get a zip file which you should extract
- Download an install java if you don't have it on your computer here
- Open Command Prompt and run the command
java -jar <location of the Cdata setup.jar> for example java -jar c:\Temp\setup.jar
- Install the connector
- Run the jar file of the connector library
java -jar "c:\Program Files\CData\CData JDBC Driver for<connector name>\lib\cdata.jdbc<connector name>.jar"for example
java -jar "c:\Program Files\CData\CData JDBC Driver for Instagram 2019\lib\cdata.jdbc.instagram.jar"
- A CDATA connector test will open
- Create a connection string based on the document in CDATA for that connector and fill the parameters based on the "Establishing a Connection" section
- Each driver will have additional documentation on connecting to the datasource as well as any other important information about the connection
- Follow the instructions on how to set up a JDBC connection string here: Connecting to JDBC
Some CDATA drivers allow for adding some additional logging within the connection string. For more information on how to troubleshoot JDBC connection string errors, please reference this article: Troubleshooting Generic JDBC Connections
If you run into issues with using the CDATA driver and it is on the list of Sisense Certified Connectors, please create a support ticket with our support team. In the ticket, please include the following information:
- Which driver you are trying to use
- Which Sisense version you are using
- What you have tried so far
- Relevant errors
If you run into issues with licensing or find you are at the end of a trial and are using the driver with your Sisense instance, please create a support ticket with our support team to assist.