Configuring data sources

You can configure the federated server to access relational and nonrelational data sources.
Note:
Although you can use different wrappers to connect to the same data source, the recommended order is:
  1. Native wrapper
  2. ODBC wrapper
  3. JDBC wrapper

Native wrapper contains more features than ODBC or JDBC wrapper, such as two-phase commit transactions and federated procedures.

For Db2 Linux or Unix platform, ODBC wrapper can be used instead of JDBC wrapper. This is because ODBC wrapper supports additional features such as Secure Sockets Layer (SSL) connection, bulk insert, etc.

For Db2 Windows platform, JDBC wrapper is more easy to use and Federation provides the JDBC drivers. But ODBC driver is not bundled with Federation. User must download the ODBC driver from the data source site.

Note:

Although different types of wrappers are provided to connect to same type of data sources, the recommended order is Native wrapper > ODBC wrapper > JDBC wrapper.

Native wrapper contains more features than ODBC or JDBC wrapper, such as two-phase commit transactions and federated procedures. For more features, see Data source support for federated features.

For Db2 Linux or Unix platform, if the native wrapper is not available for any types of data source, ODBC wrapper is preferred over JDBC wrapper, as ODBC wrapper supports more features, such as Secure Sockets Layer (SSL) connection, bulk insert, and so on.