Managing the SQL File Format
The SQL File Format object represents the SQL data sources that are being mapped, including the root element. This object is created automatically by Sterling B2B Integrator Map Editor and enables you to define SQL data sources, data source connection parameters, and extended rules.
Note: The SQL File Format object cannot be referenced
by standard rules or links.
Sterling B2B Integrator is Java-based, and uses Java™ Database Connectivity (JDBC) to connect to external databases. Sterling B2B Integrator Map Editor is Windows-based, and uses Open Database Connectivity (ODBC) to connect to external databases. To use the JDBC adapter or Lightweight JDBC adapter, you must set up a connection to the external database that contains the tables you want to access.