Determine Driver's Class Name for JDBC Connector

[KevinY]

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.
• https://www.sisense.com/data-connectors/
• https://www.cdata.com/solutions/bi/sisense/
• A download of the specific JDBC driver is required.
  • https://docs.sisense.com/main/SisenseLinux/connecting-to-custom-connectors-with-jdbc-drivers.htm

 

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.

3. Extract the file named java.sql.Driver to view. 

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/