Can I Sync SAP Pooled or Clustered Tables Using the Db2 for LUW Connector?
Question
Can I sync SAP pooled or clustered tables, such as T016T, T003T, and T001S, from SAP to Snowflake using the Db2 for LUW connector with Hybrid Deployment?
Environment
- Connector: Db2 for LUW
- Deployment model: Hybrid Deployment
- Source: SAP ECC
- Destination: Snowflake
Answer
No, Fivetran doesn't support syncing SAP pooled or clustered tables, even when using Hybrid Deployment.
SAP pooled and clustered tables require SAP-specific unpacking functionality. We support this functionality for the HVA SAP ECC on Oracle and HVA SAP ECC on SQL Server connectors, but not for the Db2 for LUW connector. To sync SAP pooled or clustered tables, you must use a supported SAP connector that includes SAP unpacking functionality.