Showing results for 
Search instead for 
Did you mean: 
Community Manager
Community Manager
JoeM_0-1647290819061.pngIncorta ships with a wide variety of connectors for SQL-based, Cloud-based, file system-based sources.  On top of that, Incorta's new relationship with CData is introducing hundreds more connectors.  With all that, we occasionally have customers who have older sources or sources we simply don't have connectors for.  Have no fear.  This post explains how to add custom connectors to your Incorta platform.  Valid for version 4.x+

Steps to Create a Custom SQL Connector

  • Copy the JDBC driver jar into <INCORTA_HOME>/IncortaNode/runtime/lib in all Incorta nodes (aka. all servers running Incorta)

  • Restart analytics and loader services

  • Go to the Data tab and click [ + New ]  Add Data Source

  • Select Custom SQL

  • Options Driver Class, Connection String and Validation Query are specific to each database

For example, Informix from IBM would look like this:

  • Java Driver Class: com.informix.jdbc.IfxDriver

  • Connection String: jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>

  • Validation Query: select count(*) from systables

Best Practices Index
Best Practices

Just here to browse knowledge? This might help!

Version history
Last update:
‎03-14-2022 01:48 PM
Updated by: