Post reply

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

  • January 2, 2019 at 12:10 am

    #369750

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

  • January 2, 2019 at 6:55 am

    #2017732

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

  • January 2, 2019 at 7:08 am

    #2017734

    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.

  • January 2, 2019 at 9:15 am

    #2017754

    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