Getting Started With DbVisualizer

[intapiuser]

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 Guide