Connector settings

Connectors are essential part for connecting with various datasources. All connectors are JDBC based, except REST, CSV and Excel connectors.

Connector

Adding JDBC drivers

Press the “Add new connector” button
Choose driver type and select the driver’s JDBC JAR file to be used
Click “Add new connector” button
Click “Load connectors” button
The application will restart and initialize added drivers/connectors
Check that added connector status is OK If the status check fails then please check that the correct driver file is uploaded.
New connections can now be added using the selected driver.

List of available connectors

BigQuery – included
ClickHouse
CSV – included
Databricks
Exasol
Hive
MariaDB
MySQL
OpenEdge Progress – Included in OpenEdge server installation under C:\Progress\OpenEdge\java\openedge.jar
Oracle: thin
PostgreSQL
Redshift
REST API – included
SAP Hana
SAP IQ (jConnect)
Snowflake
SQL Server
SQL Server jTDS
Teradata
Vertica

Last modified: 21 October 2024