CData Wasabi-Tableau Connector With Wasabi

Prev Next

How do I use the CData Wasabi-Tableau Connector with my Wasabi storage?

CData is a software company that specializes in data access and connectivity solutions. CData offers a number of drivers specially designed to enable you to connect to Wasabi. This article provides information about the Wasabi-Tableau Connector driver. The driver leverages real time data access and metadata discovery to provide you with the most up to date and accurate picture of your Wasabi footprint. (For example, see which of your users store the most data, see the largest or smallest objects in a particular bucket, and so on.)

Be sure that you are running Tableau 2020.3 or later. If you are not, use this JDBC driver instead. You will also need Java 6 or above.

  1. Download the driver.  

    Screen_Shot_2021-02-16_at_12.03.03_PM.png

  2. Run the 'Setup.jar' Java file. Follow the instructions provided. Select the location of the application and install. The connector should be visible immediately in Tableau.

  3. In the Tableau connection menu, notice the Wasabi by CData option.  

    Screen_Shot_2021-02-15_at_4.16.25_PM.png

  4. Select Wasabi by CData. A connection string input option will appear.    

    Screen_Shot_2021-02-15_at_4.22.06_PM.png

  5. Go back to your Finder or File Explorer, open the CData Wasabi-Tableau application folder, then the 'lib' folder, and run the 'cdata.tableau.wasabi.jar' Java file.  

    Screen_Shot_2021-02-15_at_4.11.37_PM.png

  6. Running this will open the CData Connection builder.  

    Screen_Shot_2021-02-15_at_4.47.48_PM.png

  7. Input your Wasabi Access Key and Secret Access Key of choice. Copy the Connection String to your clipboard. Navigate back to Tableau.

  8. Paste the Connection String that was built in the Connection Builder.  

    Screen_Shot_2021-02-15_at_4.51.59_PM.png

    Your string should look similar to the example below, depending on the information you filled out in the Connection Builder.

  9. Select Sign In.  

    Screen_Shot_2021-02-15_at_4.56.22_PM.png

  10. You will have the option to build out sample data sheets once you select a Table. Using the pre-built tables will only show you a limited number of results, based on the first table that CData finds. To analyze your objects or buckets completely, select New Custom SQL.

  11. You can query for exact information (for example, all of the items in a bucket):  

    SELECT * FROM OBJECTS WHERE Bucket = 'mybucket';

  12. Drag New Custom SQL to Drag Tables Here (similarly to how you would drag any other table) and begin analyzing your data.

  13. If you have any further questions, consult the 'help.htm' file in the application files.  

    Screen_Shot_2021-02-16_at_12.16.59_PM.png

For additional support, contact CData Support.