JDBC (Java Database Connectivity) is a programming interface that lets Java applications access a relational database. SuperCHANNEL needs a JDBC driver so that it can access the relational database system (e.g. SQL Server, Oracle, etc) where your source data is stored. Before you can run SuperCHANNEL, you need to install the appropriate JDBC driver and configure SuperCHANNEL so that it can access the driver. In most cases the JDBC drivers are supplied by the database vendors. STR does not supply the drivers.
SuperCHANNEL needs a JDBC driver so that it can access the relational database system (e.g. SQL Server, Oracle, etc) where your source data is stored.
Before you can run SuperCHANNEL, you need to install the appropriate JDBC driver and configure SuperCHANNEL so that it can access the driver.
In most cases the JDBC drivers are supplied by the database vendors. STR does not supply the drivers.
If your source data is stored in an Oracle database, then you need to configure SuperCHANNEL to use an appropriate JDBC driver.
Step 1 - Download and Install the Driver
- Download an appropriate driver from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html (you only need to download the file ojdbc6.jar).
SuperCHANNEL can access the driver file from anywhere on your system, but you are recommended to copy the .jar file to the drivers directory in your SuperCHANNEL installation. If you chose the default installation options, the location will be: C:\Program Files\STR\SuperCHANNEL\jar\drivers
Step 2 - Edit the SuperCHANNEL Configuration
- Locate the SuperCHANNEL configuration file, config.txt. If you chose the default installation options, this file will be located in C:\ProgramData\STR\SuperCHANNEL\bin
- Open config.txt in a text editor.
Locate the line that defines the Java class path property (
java.class.path=), and add the following to the end of the definition:
Each entry in the Java class path definition must be separated by a semi colon.
Locate the line that defines the
jdbc.driversproperty and add the following to the end of the definition
Each entry in the
jdbc.driversdefinition must be separated by a colon.
The following example shows the two additions to the configuration file:
- Locate the line that defines the
jdbc.table.typesproperty and check that it is set to
TABLE:VIEW(this enables both Oracle tables and views to be seen in SuperCHANNEL):
- Locate the line that defines the
str.oracle.fixproperty and check that it is set to
- Save config.txt.
Step 3 - Start SuperCHANNEL
Start SuperCHANNEL, select File > Connect to Source, and use the following connection string to connect to Oracle:
<servername>is the name of your host for Oracle.
<port>is the port to use to communicate with Oracle (the default is 1521).
<databasename>is the SID of the source database to connect to.
You will also need to provide user credentials (for Oracle authentication):
When a connection is made with Oracle, available schemas appear in the Schema window for selection.
If you have to connect to Oracle RAC (Real Application Cluster) using JDBC with the thin driver, the classic URL (
jdbc:oracle:thin:@<servername>:<port>:<databasename>) does not work.
If you see the error ORA – 12505, use the following URL format instead:
Check tsnames.ora for the correct values of SERVICE_NAME and host.
When connecting to an Oracle database, SuperCHANNEL's Source View only displays the names of synonyms contained in the selected schema. It does not display the columns of the underlying tables associated with the synonyms.
If you are using views, you can display the columns in the Source View for the Oracle Synonyms by setting the
includeSynonyms property in config.txt to
true and setting
TABLE:VIEW:SYNONYM. See config.txt for more information about these configuration options.
Step 4 - Update the SNU Class Path
You may also need to add your driver to the SNU class path. This step is only required if:
- You have saved the driver JAR file somewhere other than the SuperCHANNEL drivers directory; and
- You intend to run SuperCHANNEL from the command line or via scripting using SNU, the SuperCHANNEL Command Line Utility.
The SNU class path is defined in snu.bat. By default this file is located in C:\ProgramData\STR\SuperCHANNEL\bin
Locate the following section:
To use SNU with this source, the
-classpath setting must include the location of your driver. As you can see, the class path already includes all files in the %SNU_PROGRAM_HOME%\jar\drivers\ directory, so this step is only required when you have stored the driver somewhere else.
Add the driver location to the class path. For example: