Determine Driver's Class Name for JDBC Connector
Question
How do you determine the Driver’s Class Name from the JDBC driver file that is installed with the Sisense JDBC Connector?
Prerequisites:
- Sisense Data Administrator may require a separate JDBC Connector to connect to a specific data source.
- A download of the specific JDBC driver is required.
Relevant Background Information:
As per Sisense documentation: https://documentation.sisense.com/docs/connecting-to-dynamodb. Steps are described in this document for installing a DynamoDB JDBC driver:
- Reference in the document section: Adding DynamoDB Tables to your ElastiCube
- (Step 7) The document provides the Driver’s Class Name to use.
cdata.jdbc.amazondynamodb.AmazonDynamoDBDriver
- The document provides the Driver’s Class Name but does not contain details on how to obtain it.
Answer
1. Let's use for example the SalesForce Marketing Cloud JDBC Driver
https://www.cdata.com/drivers/salesforcemarketing/jdbc/
Open the JDBC driver file as an archive file.
Filename: cdata.jdbc.sfmarketingcloud.jar
Note: You can use any other application like Winzip, 7zip, or Winrar, to extract the jar file contents.
2. Navigate to the META-INF/services/ subdirectory within the archive.
4. Open java.sql.Driver in a text editor.
Driver’s Class Name: cdata.jdbc.sfmarketingcloud.SFMarketingCloudDriver
Additional Notes:
These steps can be applied to installing any JDBC driver that can be supported with Sisense.
If you need additional help, please contact Sisense Support or create a Support Case.
Document References:
https://www.sisense.com/data-connectors/
https://www.cdata.com/solutions/bi/sisense/
https://docs.sisense.com/main/SisenseLinux/connecting-to-custom-connectors-with-jdbc-drivers.htm
https://documentation.sisense.com/docs/copying-a-cdata-jar-file-installed-locally-to-a-remote-server
https://www.cdata.com/drivers/salesforcemarketing/jdbc/
