Show TOC

Object documentationIDBC Connector Locate this document in the navigation structure

 

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

The Oracle and Microsoft SQL Server parameters are listed in the following table:

Parameter

Use

JDBCDriver

Describes the Java package and class that contains the driver

ServerURL

Defines the location of your server

Caution Caution

Many ODBC drivers are prone to memory and resource leaks, crashes, and other faults. Since these bridges are not written in Java, they could crash the Web server and SAP MII. We recommend that you select your ODBC drivers carefully and test them before deploying them in a production Web server environment.

End of the caution.

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

Integration

The JDBC drivers included with SAP MII are the following:

  • Oracle

    You must use Oracle 7.3.4 or newer (oracle.jdbc.driver.OracleDriver).

  • SQL Server

    You must use SQL Server 6.X, 7.X or 2000 (com.inet.tds.TdsDriver).

  • ODBC

    Note Note

    If you are using a third-party JDBC driver with SAP MII, add the driver class name to the class path.

    End of the note.