Forum Discussion

jacob9hawkes's avatar
jacob9hawkes
Frequent Visitor
3 months ago

Incremental Copy Job error from NetSuite

I am trying to configure a copy job to incrementally load data from NetSuite SuiteAnalytics Connect.   The source is accessed using the NetSuite ODBC driver installed on an on-prem data gateway.  ...
Copy job
Need Help
jacob9hawkes's avatar
jacob9hawkes
Frequent Visitor
2 months ago

Hi v-moharafi-msft,

 

I raised a support ticket and was informed that NetSuite does not currently support incremental copy jobs.

 

The specific explanation was 'NetSuite's ODBC driver does not support the parameterized WHERE clause syntax' used by Fabric data factory.

 

No ETA on a solution, but has been passed onto relevant teams.

v-moharafi-msft's avatar
v-moharafi-msft
Icon for Community Support rankCommunity Support
2 months ago

Hi jacob9hawkes,


Thank you for sharing the update from the support team.

 

Based on the support investigation, NetSuite’s ODBC driver currently does not support the parameterized WHERE clause syntax required by Fabric Data Factory incremental copy jobs, which explains the behavior observed. We appreciate you sharing this information, as it may help other community members facing the same issue.

 

Best Regards,
Abdul Rafi