cancel
Showing results for 
Search instead for 
Did you mean: 
KevinY
Sisense Team Member
Sisense Team Member

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:

 

Relevant Background Information:

As per Sisense documentation: https://documentation.sisense.com/docs/connecting-to-dynamodbSteps 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

vo12tex2_0-1665155295065.jpeg

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.

vo12tex2_1-1665155295067.jpeg
vo12tex2_2-1665155295086.jpeg
 
3. Extract the file named java.sql.Driver to view. 
vo12tex2_3-1665155295051.jpeg

 

4. Open java.sql.Driver in a text editor.

vo12tex2_4-1665155295050.jpeg

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/

 

Rate this article:
Version history
Last update:
‎02-09-2024 11:11 AM
Updated by: