How to Set Up a Custom Generic JDBC Connector to Imp
Sisense provides a native connector for MongoDB, which uses Insightsoftware’s Simba MongoDB JDBC Driver. However, this driver does not officially support Amazon DocumentDB, and using it may result in compatibility issues. Amazon DocumentDB is not a fully compatible MongoDB implementation—it supports only a subset of MongoDB APIs and features. As a result, the Simba driver may rely on commands or behaviors that DocumentDB does not implement. To address this, Sisense offers a certified connector: the CData JDBC Driver for MongoDB, which supports Amazon DocumentDB. This article explains how to configure a custom Generic JDBC connector in Sisense using the CData JDBC Driver for MongoDB.
Sisense provides a native connector for MongoDB, which uses Insightsoftware’s Simba MongoDB JDBC Driver. However, this driver does not officially support Amazon DocumentDB, and using it may result in compatibility issues.
Amazon DocumentDB is not a fully compatible MongoDB implementation—it supports only a subset of MongoDB APIs and features. As a result, the Simba driver may rely on commands or behaviors that DocumentDB does not implement.
To address this, Sisense offers a certified connector: the CData JDBC Driver for MongoDB, which supports Amazon DocumentDB.
This article explains how to configure a custom Generic JDBC connector in Sisense using the CData JDBC Driver for MongoDB.
Step-by-Step Guide:
- Download the Driver
Download the CData JDBC Driver for MongoDB from Sisense Certified Connectors site
- Install the Driver on Your Local Machine
- Extract the downloaded .zip file.
- Run "java -jar setup.jar" or "java -jar setup.jar -console" .
- If Java is not installed, please install the Java Runtime Environment (JRE), or run the installer on a machine where JRE or JDK is already available.
- The default installation path of version 2025 in the Windows environment is:
C:\Program Files\CData\CData JDBC Driver for MongoDB 2025”. - Configure the Connector in Sisense
- Log in to Sisense as a user with Admin privileges.
- Open Configuration Manager:
Admin > Server & Hardware > System Management > Configuration - Scroll to the bottom and click Manage Connectors.
- In the left pane, click +JDBC Connector.
- Fill in the required fields on the Create JDBC Connector page:
- Connector ID: CData_MongoDB
- Display Name: CData MongoDB
- Class Name: cdata.jdbc.mongodb.MongoDBDriver
- Upload JAR File: Upload cdata.jdbc.mongodb.jar from the /lib directory of the installed driver, e.g.:
C:\Program Files\CData\CData JDBC Driver for MongoDB 2025\lib\cdata.jdbc.mongodb.jar - Click Create to register the connector.
Conclusion
Once these steps are completed, the CData MongoDB connector will be available in your Sisense environment.
To establish a connection to Amazon DocumentDB, include the following parameters in your connection string:
- UseSSL=true;UseFindAPI=true
For additional details and connection instructions, refer to the official CData documentation:
If your Sisense server is hosted in our managed cloud, please review the SSH Tunnel section in our documentation:
References/Related Content
