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.
- 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
- Copy the coralogix.tdc file to
~/Documents/My Tableau Repository/DatasourcesFor more details consult Tableau documentation
- Create a file
coralogix.propertiesand add an entry with your
apiKey. You will get it from Coralogix dashboard
API Accesstab ->
Logs API Key
apiKey=<YOUR API KEY>
- On the main screen in
To a Serversection choose
Other Databases (JDBC)
jdbc:coralogix://grpc-api.coralogix.comfor Europe or
jdbc:coralogix://grpc-api.app.coralogix.infor India or
Passwordblank. Click on
Properties fileand choose
- Click on
The Coralogix SQL support is based on the OpenDistro SQL interface. Refer to its documentation for further references on supported SQL features.