ODBC Connector
Overview
The ODBC Connector provides access to a variety of systems. In order to reach
a system using JDBC you need a ODBC driver from the software provider. Depending
on the product the installation process for the ODBC driver is specific.
Normally, an installation option will allow you to specify installation of the
ODBC driver. Having installed the driver you must configure an ODBC Data Source.
You typically use the ODBC Data Source Administrator control panel to do
this.
Configuration
The Connector needs the following parameters:
Parameter |
Description |
connectorType |
com.architech.connector.rscOdbc |
jdbcDriver |
The ODBC bridge class name. If not specified it
defaults to sun.jdbc.odbc.JdbcOdbcDriver |
jdbcSource |
The source name as specified in the ODBC Data
Source control panel. |
jdbcLogin |
The username parameter |
jdbcPassword |
The password |
jdbcTable |
The table/view to operate on |
jdbcSelect |
The select statement to execute when selecting
entries for iteration. If you leave this blank, the default construct
(SELECT * FROM TABLE) will be used. |
jdbcExposeNullValues |
If this parameter is set to "true"
then NULL values will be returned as an empty string. This is useful when
discovering all fields in a table/view. |
Downloads
Included in base product
See Also
JDBC Driver, Specifying
file/database paths directly
|