Tableau Plugin
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.
Getting Started
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 |
Copy the coralogix.tdc file to ~/Documents/My Tableau Repository/Datasources
. For more details, view the Tableau documentation here.
Create a file coralogix.properties
and add an entry with your apiKey
. To use this API you need to create a personal or team API key. It’s recommended to use permission presets, as they are automatically updated with all relevant permissions. Alternatively, you can manually add individual permissions.
Preset | Action | Description |
---|---|---|
DataQuerying | LEGACY-ARCHIVE-QUERIES:EXECUTE LOGS.DATA-API#HIGH:READDATA LOGS.DATA-API#LOW:READDATA METRICS.DATA-API#HIGH:READDATA SPANS.DATA-API#HIGH:READDATA SPANS.DATA-API#LOW:READDATA | Query Data from the Archive Query Frequent Search Logs Query Monitoring & Compliance Logs Query Metrics Query Frequent Search Spans Query Monitoring & Compliance Spans |
- On the main screen in
To a Server
section, selectOther Databases (JDBC)
. - Set
URL
to [table id=106 /]. - Set
Dialect
toMySQL
and leave theUsername
andPassword
blank. Click onBrowse
nextProperties file
and choosecoralogix.properties
you created. - 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.
Support
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].