Connecting to Vendor JDBC Connectors
  • 14 Aug 2022
  • 2 Minutes to read
  • Dark
    Light

Connecting to Vendor JDBC Connectors

  • Dark
    Light

JDBC is one of the most widely supported Java APIs for connecting to a variety of relational databases. With Sisense's generic JDBC driver you can leverage native JDBC connectors to connect to additional data sources.
For a complete list of supported connectors, see Introduction to Data Sources.

Downloading Vendor JDBC Connectors

The connectors are provided by the following data source vendors:

Data SourceDriver ClassJDBC URL Example
Azure Data Explorercom.microsoft.sqlserver.jdbc.SQLServerDriverjdbc:presto://{host}/mysql
ClickHouseru.yandex.clickhouse.ClickHouseDriverjdbc:clickhouse://{host}/flights
Denodocom.denodo.vdp.jdbc.Driverjdbc:vdb://<hostname>:<port>/<database>
Dremiocom.dremio.jdbc.Driverjdbc:dremio:direct={host}:31010
IBM DB2
(Connecting to IBM DB2)
com.ibm.db2.jcc.DB2Driverjdbc:db2://db2w-vqplkwx.us-south.db2w.cloud.ibm.com:50001/BLUDB:sslConnection=true;
Impalacom.cloudera.impala.jdbc4.Driverjdbc:impala://{host}/tpch_200mb
Neo4jcom.simba.neo4j.jdbc.Driverjdbc:neo4j://{host}:36485
PrestoDBio.prestosql.jdbc.PrestoDriverjdbc:presto://{host}/mysql
Verticacom.vertica.jdbc.Driverjdbc:vertica://{host}/tpch
Yellowbrickorg.postgresql.Driverjdbc:postgresql://ecosystem1.yellowbrick.io:5432

Extracting the JDBC Connector

Extract your JDBC driver into a folder you create, as follows:

  • ...\ProgramData\Sisense\DataConnectors\jdbcdrivers\

For example, if you are using JDBC to connect to Azure Data Explorer, create a folder called azuredataexplorer, and place the JAR file inside it:

...\ProgramData\Sisense\DataConnectors\jdbcdrivers\azuredataexplorer\

Important :

Each data source has its own requirements for connecting to it via JDBC. Refer to the vendor documentation for this information.

Importing the Data Source Table into Your ElastiCube

  1. Open Sisense .

    For a non-local installation, open Sisense on the hosted cloud environment.

  2. In the Data page, open an ElastiCube or create a new ElastiCube .

  3. In the Model Editor, click 8-5dataJDBC1.png; the Add Data dialog box is displayed.

    8-5genjdbcthumb03001.png

  4. Click Generic JDBC to open the JDBC settings.

    8-5jdbc2thumb03001.png

  5. In Connection String, paste the string you obtained above.

    jdbc:&lt;your driver&gt;:Initiate OAuth="OFF";User=XXXX;Password=********;

  6. In JDBC JARs Folder, enter the name of the directory where the JDBC’s JAR file islocated.

  7. In Driver's Class Name, enter the class (see above).

  8. In the User Name and Password fields:

    • If the User Name and Password are part of the connection string, leave these fields blank

    • If they are not part of the connection string, enter the credentials to your application here

  9. Click Next. A list of tables in the database are displayed. All tables and views associated with the database will appear in a new window.

  10. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or click Preview to see a preview of the data inside it.

  11. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.

  12. After you have selected all the relevant tables, click Done; the tables are added to your data model.

Changing the Default Separator

For some data sources, you must change the default separator to the separator required by your data source.

You can change the default separator by modifying the value of tableNamePattern in the following configuration file:

C:\ProgramData\Sisense\DataConnectors\JVMContainer\Connectors\jdbc_configs

Limitations

The connector samples the first X rows and determines the column type. When Sisense finds rows within the data that does not match the column type, the Sisense driver returns an error.


Was this article helpful?