Creating a Cirro driver allows you to connect to a data source. After the driver has been created, add resources to it with the ADD RESOURCE command.

Syntax

CREATE DRIVER name OF TYPE type WITH CLASSNAME 'driverclass' [OPTIONS (INCLUDE_PARENT_CLASSPATH (TRUE|FALSE))];

Arguments

  • name - user-specified name for the driver.
Database type driverclass
BigSQL bigsql com.ibm.biginsights.bigsql.jdbc.BigSQLDriver
Cassandra cassandra com.dbschema.CassandraJdbcDriver
Greenplum greenplum org.postgresql.Driver
MySQL Aurora mysql_aurora org.mysql.jdbc.Driver
Mysql8 mysql com.mysql.cj.jdbc.Driver
Netezza netezza org.netezza.Driver
Oracle oracle oracle.jdbc.OracleDriver
Postgres postgresql org.postgresql.Driver
Netezza netezza org.netezza.Driver
Redshift redshift org.postgresql.Driver
SQL Server sqlserver com.microsoft.sqlserver.jdbc.SQLServerDriver
Sybase IQ sybase com.sybase.jdbc4.jdbc.SybDriver
Teradata teradata com.teradata.jdbc.TeraDriver
Vertica vertica com.vertica.jdbc.Driver
  • INCLUDE_PARENT_CLASSPATH - Include Cirro classpath when loading JDBC driver. Only set true when using HIVE drivers after guidance from Cirro Support.

Examples

Database SQL Example
BigSQL CREATE DRIVER bigsqldriver OF TYPE bigsql WITH CLASSNAME ‘com.ibm.biginsights.bigsql.jdbc.BigSQLDriver’;
Cassandra CREATE DRIVER cassandradriver OF TYPE cassandra WITH CLASSNAME ‘com.dbschema.CassandraJdbcDriver’;
Greenplum CREATE DRIVER greenplumdriver OF TYPE greenplum WITH CLASSNAME ‘org.postgresql.Driver’;
MySQL Aurora CREATE DRIVER aurora_mysqldriver OF TYPE mysql WITH CLASSNAME ‘org.mysql.jdbc.Driver’;
MySQL CREATE DRIVER mysqldriver OF TYPE mysql WITH CLASSNAME ‘org.mysql.jdbc.Driver’
Netezza CREATE DRIVER netezzadriver OF TYPE netezza WITH CLASSNAME ‘org.netezza.Driver’;
Oracle CREATE DRIVER oracledriver OF TYPE oracle WITH CLASSNAME ‘oracle.jdbc.OracleDriver’;
Postgres CREATE DRIVER postgresdriver OF TYPE postgresql WITH CLASSNAME ‘org.postgresql.Driver’;
Redshift CREATE DRIVER redshiftdriver OF TYPE redshift WITH CLASSNAME ‘org.postgresql.Driver’;
SQL Server CREATE DRIVER sqlserverdriver OF TYPE sqlserver WITH CLASSNAME ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’;
SybaseIQ CREATE DRIVER sybaseiqdriver OF TYPE SYBASEIQ WITH CLASSNAME ‘com.sybase.jdbc4.jdbc.SybDriver’;
Teradata CREATE DRIVER teradatadriver OF TYPE Teradata WITH CLASSNAME ‘com.teradata.jdbc.TeraDriver’;
Vertica CREATE DRIVER verticadriver OF TYPE vertica WITH CLASSNAME ‘com.vertica.jdbc.Driver’;

See Also