Createlocalconnection: Save a JDBC Connection

Creates a JDBC connection and stores it locally.


You must use this command to create and save the local connection before you can use the CLI dataload or dimbuild commands with the streaming option. You must also set an environment variable EXTERNAL_CLASSPATH to point to the .jar file for your database driver. For examples of setting this variable, see Build Dimensions and Load Data by Streaming from a Remote Database.


createLocalConnection [-verbose] -name streamConnection -connectionstring  connectionString -user userName [-driver jdbcDriver]
Option Abbreviation Description
-verbose -v Show extended descriptions
-name -N Connection name
-connectionstring -cs JDBC connection string. Format can be with SID, as follows:

or with service name, as follows


See Examples.

-user -u User name
-driver -D JDBC driver. If not provided, Oracle Database is considered the default, as oracle.jdbc.driver.OracleDriver


The following examples reflect various data sources.

If the -driver option and jdbcDriver parameter are not provided, Oracle database is the assumed database by default.

Oracle DB – Example with SID (Service ID)

esscs createLocalConnection -N OracleDBConnection1 -cs jdbc:oracle:thin:@myhostname01:1521:ORCL -u OracleUser -D oracle.jdbc.driver.OracleDriver

Oracle DB – Example with Service Name

esscs createLocalConnection -N OracleDBConnection2 -cs -u OracleUser


esscs createLocalConnection -N DB2conn -cs jdbc:db2:// -u myDB2User -D


esscs createLocalConnection -N MySQLconn -cs jdbc:mysql:// -u MySQLUsr -D com.mysql.jdbc.Driver

Microsoft SQL Server

esscs createLocalConnection -N MSSQLConn -cs jdbc:sqlserver:// -u MSSQLUsr -D


esscs createLocalConnection -N TeraDconn -cs jdbc:teradata:// -u MSSQLUsr -D com.teradata.jdbc.TeraDriver