Netsuite to Azure Data Lake or DW using API OAUTH1.0

Prashant Meshram 41 Reputation points
2022-04-27T05:10:55.08+00:00

![![![196811-image.png]1]1]1

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,369 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,540 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-04-28T14:33:51.823+00:00

    Hi @Prashant Meshram ,

    Thank you for posting query in Microsoft Q&A Platform.

    Azure data factory doesn't has in built connector for NetSuit. Hence we should consider making API call to fetch data and load to sink systems. Click here to see list of available connectors in Azure data factory.

    We can use REST connector or HTTP connector datasets for source data fetch and load it to sink systems. Please check below links which explain how to copy data by using REST and HTTP connectors.

    There is something called custom activity. We can use it to move data to/from a data store that the ADF does not support, or to transform/process data in a way that isn't supported by the ADF, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines. Click here to know more details about custom activity.

    Hope this helps. Please let us know how it goes. Thank you.