Azure ETL architecture RRS feed

  • Question

  • Hi,

    I am trying to define the best architecture for data integration in the following context:

    - Sources are Oracle and Filesystem on-premises

    - VPN is awful (due to endpoint overload), so the preferred connection is through internet

    - There is a lot of code in SISS

    The proposed architecture is:

    - On-premises machine with: Filesystem + Oracle + Self-hosted IR

    - Azure-SSIS Integration Runtime

    - Blob storage + SQL Server (single database), etc.

    The issue is that everywhere is said that Azure-SSIS IR needs to be connected throught VPN to access on-premises data.

    The question is: is it possible to have a hybrid scenario where I use a Copy Data Tool to transfer the data from on-prem to the Blob Storage and after that I execute my SSIS packages? Is it possible to call that Copy Data Tool from SSIS?

    Thank you very much in advance,


    Monday, May 27, 2019 11:55 PM

All replies