The Coralogix JDBC driver allows you to investigate your log data with your favorite database tool using SQL queries.
JDBC, which stands for Java Database Connectivity, is a common standard for database drivers, and many popular querying tools support it. With the Coralogix JDBC driver, you can quickly get started on performing SQL queries against the data already stored in your Coralogix account.
This tutorial provides instructions on using the Coralogix JDBC driver with Tableau.
STEP 1. Place the .jar files in the folder for your operating system. Create a 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 |
STEP 2. Copy the coralogix.tdc file to ~/Documents/My Tableau Repository/Datasources
. For more details, view the Tableau documentation here.
STEP 3. Create a file coralogix.properties
and add an entry with your apiKey
. In your navigation pane, select Data Flow > API Keys > Logs Query Key.
apiKey=<Logs Query Key>
To a Server
section, select Other Databases (JDBC)
.URL
to
Team URL | Region | URLs |
---|---|---|
team-name.coralogix.com | Ireland | jdbc:coralogix://grpc-api.coralogix.com |
team-name.coralogix.us | US | jdbc:coralogix://grpc-api.coralogix.us |
team-name.app.coralogix.in | India | jdbc:coralogix://grpc-api.app.coralogix.in |
team-name.app.eu2.coralogix.com | Sweden | jdbc:coralogix://grpc-api.app.eu2.coralogix.com |
team-name.app.coralogixsg.com | Singapore | jdbc:coralogix://grpc-api.app.coralogixsg.com |
Dialect
to MySQL
and leave the Username
and Password
blank. Click on Browse
next Properties file
and choose coralogix.properties
you created.Sign In
.The Coralogix SQL support is based on the OpenDistro SQL interface. Refer to its documentation for further references on supported SQL features.
Need help?
Our world-class customer success team is available 24/7 to walk you through your setup and answer any questions that may come up.
Feel free to reach out to us via our in-app chat or by sending us an email to [email protected].