Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)

  • Comments posted to this topic are about the item Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)

  • Is there any overhead time when executing the SSIS package here or is it pretty instant once the factory job is made?

  • Any overhead you experience is dependent on the NetSuite API and how much data you are replicating. The CData SSIS Components process the incoming data from NetSuite essentially as fast as it is returned and the native SSIS integration with an Azure SQL instance is as fast as expected.

  • jerodj - Wednesday, January 2, 2019 7:08 AM

    Any overhead you experience is dependent on the NetSuite API and how much data you are replicating. The CData SSIS Components process the incoming data from NetSuite essentially as fast as it is returned and the native SSIS integration with an Azure SQL instance is as fast as expected.

    I only ask because they did have SSIS in the cloud, but it was taking like 20+ minutes to load the packages as it was the overhead of loading the VM, deploying the package, then executing it for each job. Was wondering if the same is happening here in Data Factory.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply