Show TOC

Object documentationIDBC Connector

 

Enables a connection between SAP Manufacturing Integration and Intelligence (SAP MII) and a Java Database Connectivity (JDBC) or Open Database Connectivity (ODBC) data source.

Structure

Many queries require date ranges. Many database vendors have their own syntax for performing date range comparisons in a WHERE clause. The following parameters, which are defined when you create a server, affect this behavior:

  • InternalDateFormat

  • DatePrefix

  • DateSuffix

The IDBC connector supports the following modes. For more information, see Connector Modes.

  • TableList

  • ColumnList

  • FixedQuery

  • FixedQueryWithOutput

  • Query

  • Command