Databases and Relevant Drivers

In this blog we are listing down the supported database drivers and relevant dependecy jar files, if any. Some of the databases are well tested but we are not able to include within the application by defaul because of CopyLeft/GPL etc kind of licensing issues. Hence you can download from here, then upload and start using within Helical Insight application.

  1. MYSQL: To connect to MySQL database download the JDBC driver from here MYSQL 5.1.6 version or MYSQL 8.0.13 version. If you are using MySQL db till version 5.5 you can download MySQL 5.1.6 version and for the other latter versions you could use MySQL 8.0.13 version.
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on MySQL icon, in case if it not appearing please refresh the page.

  2. SQL Server: To connect to SQL Server database download the JDBC driver from here sybasejtds-1.3.1 or sqljdbc4 or SQLServer JDBC.In case if you are using SQL Server 2008 then use sybase or sqljdbc driver. Whereas in case if you are using SQLServer 2014 or SQLServer 2017 you can use any of the drivers which have been shared above.Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on SQLServer icon, in case if it not appearing please refresh the page.

    3. Note: JTDS Driver, by default, is present in Helical Insight application.In case user uninstall/ remove SQLServer driver and again user wants to upload you have to follow the steps as mentioned above.

  3. Oracle: To connect to Oracle database download the ojdbc6.jar from here for 11.2.0.2.0 XE version or ojdbc8.jar from here for oracle 18c version. You may have to register and then only you will be able to download.
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Oracle icon, in case if it not appearing please refresh the page.
    Visit this blog to learn how to connect to Oracle using SID. (https://forum.helicalinsight.com/t/connect-to-oracle-database/1074)

  4. MariaDB: To connect to MariaDB database download the JDBC driver from here 10.2 version
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on MariaDB icon, in case if it not appearing please refresh the page.

    5. Note: MariaDB Jdbc driver, by default, present in Helical Insight application. In case if you have uninstalled, you can again install by following the steps mentioned above.

  5. Presto: To connect to Presto database download the JDBC driver from here presto-server-0.187 version
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Presto icon, in case if it not appearing please refresh the page.

  6. Dremio: To connect to Dremio database download the JDBC driver from here Dremio 3.0 version

    7. After download of the driver make sure you remove SLF4J before uploading because it is already available in Helical Insight application.

      Steps to remove slf4j from dremio JDBC driver

    1. Download jar file from the provided link
    2. Right click on jar file
    3. Click on open with winRARarchiver/ 7-Zip tool
    4. Click on org folder select slf4j and delete slf4j folder
    5. Close winRARarchiver/ 7-Zip tool
    6. Now upload dremio jar file without slf4j to Helical Insight Application

  7. Apache Drill: By default apache drill is present with the application. In case if it has been removed you can follow the below steps. To connect via Apache Drill, you must have installed Apache Drill on same/other server. On that server where you have installed apache drill navigate to the location “../jars/jdbc-driver/drill-jdbc-all-.jar and this folder will have a JDBC JAR file. Alternatively you can also download the driver from here Apache Drill Driver.Now from this JAR you have to remove SLF4J and then upload on to Helical Insight application.
      Steps to remove slf4j

    1. Right click on jar file
    2. Click on open with winRARarchiver/ 7-Zip tool
    3. Click on org folder select slf4j and delete slf4j folder
    4. Close winRARarchiver/ 7-Zip tool
    5. Now upload dremio jar file without slf4j to Helical Insight Application

  8. Apache Derby: To connect to Apache Derby database download the JDBC driver from here Apache Derby – 10.12.1.1 version
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Apache Derby icon, in case if it not appearing please refresh the page.

    9. Note: Apache Derby Jdbc driver, by default, present in Helical Insight application.

  9. Hive: Hive driver is by default present in the location “…\Helical Insight\hi\hi-repository\System\Plugins\hive”

    10. Note: Hive Jdbc driver by default present in Helical Insight application. In case if you have installed you can download the zip file here Hive Zip and upload via the frontend.

  10. PostgreSQL: To connect to PostgreSQL database download the JDBC driver from here PostgreSQl 10.1 version
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on PostgreSQL icon, in case if it not appearing please refresh the page.

    11. Note: PostgreSQL Jdbc driver, by default, present in Helical Insight application.

  11. SQLite: To connect to SQLite database download the JDBC driver from here SQLite 3.19.3 version
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on SQLite icon, in case if it not appearing please refresh the page.

    12. Note: SQLite Jdbc driver, by default, is present in Helical Insight application. In case user uninstalls/ removes SQLite driver and again user wants to upload SQLite driver you have to follow the same process to upload driver.

  12. Informix: To connect to Informix database download the JDBC driver from here Informix
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Informix icon, in case if it not appearing please refresh the page.

  13. IBM Db2: To connect to IBM Db2 database download the JDBC driver from here IBM Db2 10.1
    Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on IBM Db2 icon, in case if it not appearing please refresh the page.

  14. MS Access: To connect to MS Access database download this zip from here MS-Access.ZIP and upload.
    Then you will be able to use MS Access as a database as well.

  15. Firebird SQL: To connect to Firebirdsql database download the JDBC driver from here FirebirdSQL.zip Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Firebirdsql icon, in case if it not appearing please refresh the page.
  16. Teradata: To connect to Teradata database download the JDBC driver from here Teradata driver. Exact file name which is to be downloaded is TeraJDBC__indep_indep.16.20.00.12.zip (please note that registration might be required before you are able to download the driver). Once the download is completed, you have to unzip the folder and upload the terajdbc4.jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Teradata icon, in case if it not appearing please refresh the page.

  17. Amazon Redshift: To connect to Amazon redshift download the JDBC driver from here Redshift driver. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Redshift icon, in case if it not appearing please refresh the page.

  18. Google BigQuery: To connect to Google BigQuery download the JDBC driver from here Google BigQuery. Once the download is completed extract the zip content, put the extracted zip content into a single folder and then zip it. Then please upload the zip file to Helical Insight Application. Then verify the green tick mark at the top corner on Google BiqQuery icon, in case if it not appearing please refresh the page.

  19. ClickHouse Clickhouse JDBC driver 2.0 comes by default with Helical Insight. If it is not present, download the JDBC driver from here ClickHouse. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on ClickHouse icon, in case if it not appearing please refresh the page.

  20. Vertica: To use Vertica database, download Vertica. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Vertica icon, in case if it not appearing please refresh the page.

  21. Dynamo DB: To connect to Dynamo DB download the JDBC driver from the link here (registration might be required) Dynamo DB.
    1. Once zip file is downloaded extract the zip file.
    2. Run the setup based on your respective OS like Windows Linux etc.

      3. For Example: To run on windows you can either double click and install or execute the following command in command prompt (to be run in Admin mode)

      java -jar setup.jar

      Whereas to run in Linux execute the following commands

      java -jar setup.jar

    3. Once installation is done navigate to CData installation location. For example path might be something like (“C:\Program Files\CData\CData …\lib”). Now zip this ‘lib’ folder along with the license file
    4. Once the zip is completed, we have to upload the file to Helical Insight Application. Then verify the green tick mark at the top corner on Amazon Dynamo DB icon, in case if green tick icon is not appearing please refresh the page.

      Once you have made the connection, connect to DynamoDB using the below method in the URL.
      jdbc:amazondynamodb:Access Key=xxx;Secret Key=xxx;Domain=amazonaws.com;Region=OREGON;
      Note : if connections gets success but schemas are not loaded then use below connection string : 
      jdbc:amazondynamodb:Access Key=xxx;Secret Key=xxx;Domain=amazonaws.com

  22. Athena: To connect to Athena database download the JDBC driver from here Athena. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Athena icon, in case if it not appearing please refresh the page.

  23. Celerdata: To connect to Celerdata database download the JDBC driver from here Celerdata. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Celerdata icon, in case if it not appearing please refresh the page.

  24. Cockroach: To connect to Cockroach database download the JDBC driver from here Cockroach. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Cockroach icon, in case if it not appearing please refresh the page.

  25. Databricks: To connect to Databricks database download the JDBC driver from here Databricks. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Databricks icon, in case if it not appearing please refresh the page.

  26. Duckdb: To connect to Duckdb database download the JDBC driver from here Duckdb. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Duckdbicon, in case if it not appearing please refresh the page.

  27. Elasticsearch: To connect to Elasticsearch database download the JDBC driver from here Elasticsearch. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Elasticsearch icon, in case if it not appearing please refresh the page.

  28. Sap Hana: To connect to Sap Hana database download the JDBC driver from here Sap Hana. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Sap Hana icon, in case if it not appearing please refresh the page.

  29. Snowflake: To connect to Snowflake database download the JDBC driver from here Snowflake. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Snowflake icon, in case if it not appearing please refresh the page.

  30. Trino: To connect to Trino database download the JDBC driver from here Trino. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Trino icon, in case if it not appearing please refresh the page.

  31. Yugabyte: To connect to Yugabyte database download the JDBC driver from here Yugabyte. Once the download is completed, we have to upload the jar file to Helical Insight Application. Then verify the green tick mark at the top corner on Yugabyte icon, in case if it not appearing please refresh the page.

Please refer below link to learn how to create a Data source and upload a new Driver in Helical Insight application

How to Add Database Driver

For more information you can email on support@helicalinsight.com

You May Also Like

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered