Azure Data Factory and NetSuite Financials

DGuillory 21 Reputation points
2020-09-03T17:22:58.693+00:00

Hello,
We are looking for a solution that would allow us to connect ADF to NetSuite. The requirement is to transfer data from NetSuite financials to Azure SQL tables. We currently accomplish this using an on prem SSIS package and an ODBC connector to load on prem tables. We would like to replace this with a pure cloud solution. We would prefer to avoid purchasing a third party connector and using Logic Apps or Function Apps for this.
We do not have a VM and managed instance of SQL server at this time, but this may be the best solution.
Any ideas or suggestions would be appreciated.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,211 questions
{count} votes

3 answers

Sort by: Most helpful
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2020-09-03T19:00:37.427+00:00

    Hello @DGuillory ,

    Thanks for posting the question and welcome to Microsoft Q & A .

    Let me start with saying that one our side we do not have the Netsuite environment and i will try to share my part . Since you mentioned of that you were using the SSIS package . We can do a try to evaluate the lift and shift option , please do read about that more here . https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15#provision-ssis-on-azure

    Also just in case if you are trying to move the ETL logic to Azure data factory and since you mentioned that the current setup works on ODBC drivers , you can read this . https://learn.microsoft.com/en-us/azure/data-factory/connector-odbc .

    Thanks Himanshu

    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    0 comments No comments

  2. Erik Langhorst 0 Reputation points
    2021-04-20T07:57:18.36+00:00

    This post pointed us in the right direction, by first establishing a connecting with Postman then replicating the connection and API calls in ADF.
    https://stackoverflow.com/questions/58924460/where-is-the-netsuite-webservices-postman-collection


  3. Yunksta 0 Reputation points
    2023-01-25T22:06:31.95+00:00

    We just implemented NetSuite and are trying to get the ODBC SSIS jobs scheduled on SQL Agent but we keep running into issues when publishing to the server, I think because of the 32 bit vs 64 bit drivers. How did you all get that working? My team is getting tired of having to manually kick off every job each morning. We have been troubleshooting for weeks but haven't figured it our yet. Also following in case we move to Azure! On SQL Server 2017

    0 comments No comments

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.