oracle – Azure SSIS Integration Runtime

I ran into this about a year ago.

I have not seen the reason documented, but have a strong feeling that the Azure SSIS offerings are really just a stop gap to provide a pathway to get companies migrated to Azure platform.

My guess is that SSIS is not far off end-of-life and that DF tasks and pipelines will be the tech constituents that will replace SSIS packages.

SSDT not being updated post 2017 (standalone or bundled with SQL Server) is maybe one of the indicators / steps in this process.

BTW, if you have not have not actually deployed to Azure and tried to run your packages on the platform, then you might not have bumped into the issue we did using Oracle. The drivers we required were not provisioned (like SQL Server drivers were) on the servers Azure deploys in the cluster to host you IR. You need to go through a custom install process to get the drivers installed when the IR Starts. While are a number of steps involved, it is well documented. For us, it added unexpected complexity.

Supported data providers for Oracle in Azure Data Factory SSIS IR

docs.microsoft.com/en-us/azure/data-factory/how-to-configure-azure-ssis-ir-custom-setup

Once configured, the start time was around 35mins. A real pain.