Our next-gen architecture is built to help you make sense of your ever-growing data Watch a 4-min demo video!

Back to All Docs

Tableau Plugin Tableau Plugin

Last Updated: Dec. 15, 2022

The Coralogix JDBC driver allows you to investigate your log data with your favorite database tool using SQL queries.

While using the Kibana querying language syntax would usually be the quickest way to search your logs, using SQL allows you to express queries and aggregations that would sometimes be more difficult to write using Kibana visualizations. With the Coralogix JDBC driver, you can quickly get started on performing SQL queries against the data already stored in your Coralogix account.

JDBC, which stands for “Java Database Connectivity”, is a common standard for database drivers, and many popular querying tools support it. In this tutorial, you’ll find instructions on using the Coralogix JDBC driver with Tableau.

Getting Started

    1. Place the .jar files in the folder for your operating system. (You need to create the folder if it doesn’t exist already)
      OS Path
      Windows C:\Program Files\Tableau\Drivers
      Mac ~/Library/Tableau/Drivers
      Linux /opt/tableau/tableau_driver/jdbc
    2. Copy the coralogix.tdc file to ~/Documents/My Tableau Repository/Datasources For more details consult Tableau documentation
    3. Create a file coralogix.properties and add an entry with your apiKey. You will get it from Coralogix dashboard Data Flow -> API Keys -> Logs Query Key
      apiKey=<Logs Query Key>
      
    4. On the main screen in To a Server section choose Other Databases (JDBC)
    5. Set URL to 
      Team URLRegionURLs
      team-name.coralogix.comIrelandjdbc:coralogix://grpc-api.coralogix.com
      team-name.coralogix.usUSjdbc:coralogix://grpc-api.coralogix.us
      team-name.app.coralogix.inIndiajdbc:coralogix://grpc-api.app.coralogix.in
      team-name.app.eu2.coralogix.comSwedenjdbc:coralogix://grpc-api.app.eu2.coralogix.com
      team-name.app.coralogixsg.comSingaporejdbc:coralogix://grpc-api.app.coralogixsg.com
    6. Set Dialect to MySQL and Leave Username and Password blank. Click on Browse next Properties file and choose coralogix.properties you created
    7. Click on Sign In

The Coralogix SQL support is based on the OpenDistro SQL interface. Refer to its documentation for further references on supported SQL features.

On this page