Need to integrate Netsuite with Azure service azure synapse analytics . basically copying the data from netsuite to Azure blob or Azure sql

Hi Suraj Surendran

To integrate NetSuite with Azure Synapse Analytics, you can use Azure Data Factory (ADF) or Synapse pipelines as the data integration layer. ADF supports connecting to NetSuite either directly through REST/SOAP APIs or via third-party connectors (such as CData, KingswaySoft, or Informatica).

Here are the typical approaches:

1. Using Azure Data Factory or Synapse Pipelines:
   • Create a linked service for your NetSuite source (via REST API or custom connector).
   • Copy data to Azure Blob Storage or Azure SQL Database as a landing zone.
   • From there, load or transform the data into Azure Synapse Analytics using Copy or Data Flow activities.
   Using a third-party connector: Tools such as CData Connector for NetSuite or KingswaySoft Integration Toolkit can simplify the authentication and schema handling process.

     You can schedule or orchestrate these integrations through ADF or Synapse pipelines.
   
     Alternative Option:
   
        Export NetSuite data in CSV/JSON via SuiteAnalytics or REST Web Services and ingest those files using ADF Copy Activity into Blob or directly into Synapse tables.
   

References:

• Copy data using Azure Data Factory
• Synapse pipelines overview
• NetSuite REST API documentation (external)

If this addresses your question, please click Accept Answer and Yes for was this answer helpful. Feel free to share if you need help with authentication or connection setup steps.

You'll need to spin up a VM to act as ODBC gateway and use suite analytics connect ODBC driver to connect and query Netsuite. It's not a small project, it's taken me a couple of years to build it from scratch.