Federation server enhancements
Db2 12.1 provides enhanced access to data sources in a Federation Server environment.
Attention: The Db2 12.1 release is currently available for the
following Db2® products:
- Db2 Distributed (on-premises)
- The container micro-service deployments of Db2 and Db2 Warehouse for Kubernetes-based clusters, which includes Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
| Enhancement | Description |
|---|---|
| Bulk insert support for Snowflake data sources through Db2 ODBC wrapper. | Federation supports bulk insert functionality for Snowflake. This enhancement improves the performance of insert operations for Snowflake data sources compared to single-record insert operations. |
| Insert, update and delete (IUD) support for large objects (LOBs) against several data sources, by using the ODBC wrapper. | With the release of Db2 12.1, the list of
supported federated data sources for LOB IUD operations is increased. This enhancement allows users
to take the IUD-clause portion of a SQL statement and update values for LOBs of tables in remote
data sources. The following data sources are now available for LOB write operations, through the ODBC wrapper:
|
| Federation Databricks support | Federation now supports Databricks as a data source for establishing connections, data type mapping, function push-down, and server attributes optimization. This enhancement improves query performance. |
| Federation SAP ABAP SQL Service support | Federation now supports SAP ABAP SQL Service as a data source for establishing connections, data type mapping, function push-down, and server attributes optimization. This enhancement improves query performance. |
| Federation supports for Oracle 21c and 23ai. | Federation now supports Oracle 21c and 23ai as data sources through net8 wrappers. |