*
Metamerge logo
Search

Advanced Search
*
*
*
* HOME DOCUMENTS & RESOURCES DOWNLOADS EARLY TECH ACCESS SUPPORT FAQ KNOWN ISSUES OLD VERSIONS
*

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

 

 

*
  Metamerge Integrator version 4.5 ©Copyright Metamerge AS 2000-2002 Last edited 2002-04-30 contact us