Access all of your data on demand and with any tool via JDBC drivers. All your data is open and readable and can be accessed from anywhere using secure connections.\

CoolaData JDBC driver allows you to query your data on CoolaData using external applications. It can be integrated with any visualization tool to run over the data stored in CoolaData.
Installation varies between applications. Download the latest version of the driver here:  https://github.com/cooladata/JDBC

Special URL parameters

The following applies to all apps;

The connection URL for CoolaData’s JDBC is: jdbc:gdata:sql//app.cooladata.com/v2/{PROJECT_ID}?{params}
For special functions you can append the following params to the connection URL:

  • Escape Quotes: If your query engine adds double quotes to sql queries, add escapeQuotes=trueparameter to connection URL.  This flag deletes all double quotes from SQL queries since CoolaData server works with table and column names without double quotes. For example:
    jdbc:gdata:sql//{SERVER_URL}/v2/{PROJECT_ID}?escapeQuotes=true
  • Date format: If dates in query results should be presented in GMT timezone (UTC time), add gmtTimezone=true parameter to connection URL. This flag changes default timezone to GMT. Please note: restart for query engine is required after removing gmtTimezone parameter from JDBC URL. For example:
    jdbc:gdata:sql//{SERVER_URL}/v2/{PROJECT_ID}?gmtTimezone=true
  • Log file and debug level: If you are asked to get a log of what exactly the driver execute and process, you can specify a level of debug and a log file that all debug data will be written to it. add loglevel=debug&logfile=[file path] parameters to connection URL. Please note: using the log file will slow down performance of the driver as it writes a lot of text. For example:
    jdbc:gdata:sql//app.cooladata.com/v2/123456?loglevel=debug&logfile=c:\temp\coola-jdbc-log.txt
About Cooladata
We make it easy to track, capture and analyze each customer’s journey and turn them in actionable insights to improve engagement, retention and monetization. Built to collect data from any source. Cooladata’s big data infrastructure covers all components from tracking, managed data warehousing, and ETL – all the way to the visualization layer.
< BACK TO INTEGRATIONS
Full-Stack Analytics in Action
Request a Demo