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. 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/
Getting Started With DbVisualizer
Problem There are many data sources (connectors), such as web service APIs where we not familiar with their tables/fields like Facebook, Twitter, Youtube etc. Before importing your data from a web service, you should know the data in advance. This lets you: Slice unnecessary garbage data by generating custom queries Understanding the data you’re dealing with Troubleshoot problems from the data source/connector side Solution DbVisualizer is a database tool that let’s you explore your data sets before importing them into the ElastiCube. HOW DO YOU CONNECT DBVISUALIZER TO YOUR STANDALONE DATA SOURCE CONNECTOR? 1. Go to the DbVisualizer site and download and install the latest version. *Note: You can download a version with Java or without Java. To see if you have Java installed already, open the Command Prompt and type in the following command: java -version. 2. Verify that you downloaded your connector’s driver and you can locate the connection in the following directory: C:\Program Files\Sisense\DataConnectors\JVMContainer\Connectors 3. Copy your connector’s connection string in an editor where you can easily view it. For an example of a connection string, see our Facebook example: jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0; 4. Open DbVisualizer and force close "JDBC Driver Finder". 5. In DbVisualizer, go to Tools > Driver Manger and add your new connector (a) Click "+" icon to add new driver. (b) Give your connector a name. (c) Click the Driver file path and look for the JDBC driver file, and then click ok. C:\Program Files\Sisense\DataConnectors\JVMContainer\Connectors\<Your connector>\lib\cdata.jdbc.<connector> (d) Verify that the driver is loaded and you see the driver. Then, close the Driver Manager window. 6. In DbVisualizer, go to Tools>Connection wizard. (a) Give your connector name and click Next. (b) Chose the driver connector that you generated. (c) Open "C:\Program Files\Sisense\DataConnectors\JVMContainer\Connectors\<Connector>\description.json"; get the "RTK" parameter and add it to your connection string. Before: jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0; After (RTK in the end of the string): jdbc:facebook:OAuthClientId=11276856774486;OAuthClientSecret=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0;RTK=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (d) Add the connection string with the RTK to the "Database URL" and click Finish. (e) Verify that it connected successfully and you see all the Tables and views. (f) Go to SQL Commander > New SQL. (g) Change max rows to "-1" and start to explore your connector data. References Sisense connectors list DbVisualizer Users GuideConnecting to Oracle DB with Service Name (instead of Service ID - SID)
Connecting to Oracle DB with Service Name (instead of Service ID - SID) When a customer tries to connect to an Oracle DB using a Direct Connection option, there's no option in the GUI in the ElastiCube Manager to use a Service Name, only a Service ID: Solution 1) Uncheck the Use Direct Connection checkbox. 2) In the Database server location textbox, enter the following: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=$your_ip)(PORT=$your_port))(CONNECT_DATA=(SERVICE_NAME=$service_name))) The variables you need to input are: $your_ip $your_port $service_name 3) Connect to the source.
