Netsuite to Synapse dataload

Dash 20 Reputation points
2023-08-16T19:19:39.7433333+00:00

Hi All,

I am looking for a solution to pull data from Oracle Netsuite to Azure synapse. What is the best approach?

I have tried looking up solutions but couldn't find an exact answer. Many places it is outlined to use API but none of them has an end to end solution. We cannot use any other tool except what azure has to offer. Appreciate your help on this.

Specifically-

What changes need to be done/set on netsuite side.

What configurations have to be set on Azure environment.

Thank you for your consideration.

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,980 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,815 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 25,946 Reputation points
    2023-08-16T19:41:06.69+00:00

    To pull data from Oracle Netsuite to Azure Synapse, you'll need to configure both sides. On Netsuite, I am assuming the following (since you didn't provide enough information) :

    -Enable SuiteTalk features and create integration records with the required permissions to authenticate with Netsuite's APIs.

    -Prepare your data by determining what needs to be transferred and setting up queries or saved searches. On Azure, use Azure Data Factory to create a pipeline that calls the Netsuite API through HTTP activity, transforms the data, and employs Copy Activity to move the data into Azure Synapse.

    -Make sure that your Synapse database and tables are properly configured to receive the data. Implement robust error handling and monitoring within Azure to manage the data loads.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.