Determine Driver's Class Name for JDBC Connector
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/
