Forum Discussion

jacob9hawkes's avatar
jacob9hawkes
Frequent Visitor
2 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
v-moharafi-msft's avatar
v-moharafi-msft
Community Support
2 months ago

Hi jacob9hawkes ,

I wanted to follow up on this issue. Have you had an opportunity to review the information provided above?

Could you please let us know whether you were able to raise a support ticket and, if so, whether any findings or resolution were shared? This information could be  helpful for other community members who may encounter the same NetSuite incremental copy job error 

Thank you for your understanding.

Best Regards,
Abdul Rafi

  • 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
      Community 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