DB2 for LUW Connector Limitations
PlannedWhich connector?: DB2 for LUW Connector
Additional details: After configuring the preview connector to our SAP system, connector came up empty schema. After working with Fivetran support, we found that the connector only works for certain DATACAPTURE and COMPRESSION settings on the tables. Here is result of one of the queries that we ran aganist the database.
db2 => SELECT DATACAPTURE, COMPRESSION, COUNT(*) FROM SYSCAT.TABLES as t WHERE t.TABSCHEMA = 'SAPPCE' AND TRIM(t.PROPERTY) = '' AND t.TYPE = 'T' AND t.OWNERTYPE != 'S' GROUP BY DATACAPTURE, COMPRESSION
DATACAPTURE COMPRESSION COUNT
----------- ----------- -----------
L B 2
N B 18036
N R 1310
As the query result shows, no table qualifies for the sync criteria as required by the current connector configuration. Please exapand the connector capabilities to extract from the DB2 LUW table that includes the below configurations.
-
Hello Uma,
Thanks for reaching out. We understand the benefit of this functionality and are already working on this internally. This should be available shortly ( within the next two months ).
Regards,
Naren Bhandary
Please sign in to leave a comment.
Comments
1 comment