Skip to main content
Version: 3.2

Using Pre-Installed Driver Macros

Integration Manager provides pre-installed JDBC drivers from different vendors. You can use those drivers by specifying the supported macros listed below for each driver type.

Supported Driver Macros

JDBC DriverMacroValueDescription
Actian$(JDBC_DRIVER_JAR_ACTIAN)Actian JDBC driver jar file
Actian$(JDBC_DRIVER_CLASS_ACTIAN)com.ingres.jdbc.IngresDriverActian JDBC driver classname
Ingres$(JDBC_DRIVER_JAR_INGRES)Actian JDBC driver jar file
Ingres$(JDBC_DRIVER_CLASS_INGRES)com.ingres.jdbc.IngresDriverActian JDBC driver classname
MySQL$(JDBC_DRIVER_JAR_MYSQL)MySQL JDBC driver jar file
MySQL$(JDBC_DRIVER_CLASS_MYSQL)com.mysql.cj.jdbc.DriverMySQL JDBC driver classname
PostGres$(JDBC_DRIVER_JAR_POSTGRES)Postgres JDBC driver jar file
PostGres$(JDBC_DRIVER_CLASS_POSTGRES)com.postgres.DriverPostgres JDBC driver classname
Redshift$(JDBC_DRIVER_JAR_REDSHIFT)Redshift JDBC driver jar file
Redshift$(JDBC_DRIVER_CLASS_REDSHIFT)com.amazon.redshift.DriverRedshift JDBC driver classname
Snowflake$(JDBC_DRIVER_JAR_SNOWFLAKE)Snowflake JDBC driver jar file
Snowflake$(JDBC_DRIVER_CLASS_SNOWFLAKE)net.snowflake.client.jdbc.SnowflakeDriverSnowflake JDBC driver classname

Configuring Your Own JDBC Macros

If you have already configured the JDBC drivers with different macro names, you can replace the values in your cloud deployment(s) with the above macros. Refer to the following examples:

YOUR_DRIVER_JAR_NAME=$(JDBC_DRIVER_JAR_ACTIAN)

YOUR_DRIVER_CLASS_NAME=$(JDBC_DRIVER_CLASS_ACTIAN)

Example for Redshift Configurations

Sample-redshift-usage