Before using the Azure Data Factory’s REST API in a Web activity’s Settings tab, security must be configured. Azure Data Factory pipelines may use the Web activity to call ADF REST API methods if and only if the Azure Data Factory managed identity is assigned the Contributor role. More information about the problem I am …
Continue reading Configure Azure Data Factory Security for the ADF REST API
Author:Andy Leonard
Integration Services Extension for VS 2019 v3.7 Update
The SQL Server Integration Services Projects extension for Visual Studio 2019 was updated 20 Apr 2020. There are also recent updates to Microsoft® OLE DB Driver 18 for SQL Server® and the GitHub Extension for Visual Studio. Happy coding! :{>
The Summer o’ ADF, v2020
I am pleased to announce the Summer o’ ADF, v2020, is on! Webinars: [Recording] Updates to the SSIS Framework Posts: [Recoding] Building an SSIS Framework in Azure Data Factory One Way to Incrementally Develop ADF Pipelines Nesting ForEach Activities in Azure Data Factory [Recording] Using the Azure Data Factory ForEach Activity [Recording] Configuring and Managing ADF …
Continue reading The Summer o’ ADF, v2020
One Way to Create Login Credentials
In the age of password managers, like LastPass, I no longer remember passwords. Instead, my password manager remembers them for me. I’ve found another use for password managers: generating the username portion of a username-password login. When it’s time to create the credential, I use the LastPass plugin’s “Generate Secure Password” function: I copy the password …
Continue reading One Way to Create Login Credentials
Azure Data Factory Supports Excel Files
Excel format in Azure Data Factory. A welcome addition to ADF! When adding an ADF DataSet: I am convinced they got tired of me saying, “Well, you’ll need SSIS if you want to read Excel…” Probably not, though. Either way… score! :{> Need Help Migrating to Azure? Enterprise Data & Analytics specializes in helping enterprises modernize their data …
Continue reading Azure Data Factory Supports Excel Files
An Introduction to Azure Data Factory REST API
TL;DR: To read the value portion of a key-value pair stored in JSON in an ADF pipeline, interrogate properties.<key>, where key is the key-part of the key-value JSON pair. Introduction Last month I wrote a post titled Stop an Azure-SSIS Files Integration Runtime (Safely). The post generated a bunch of hits, which is awesome. The …
Continue reading An Introduction to Azure Data Factory REST API
Announcing Summer 2020 ADF and SSIS Courses!
Due to popular demand, Enterprise Data & Analytics announces additional Azure Data Factory and SSIS training this summer! 06-07 Jul 2020: Expert SSIS 08 Jul 2020: Master the Fundamentals of Azure Data Factory For a limited time, all Enterprise Data & Analytics training is 50% off, including our popular ADF and SSIS Season Pass! Expert SSIS Do …
Continue reading Announcing Summer 2020 ADF and SSIS Courses!
Free Webinar: Configuring and Managing ADF Azure-SSIS Integration Runtimes
Join me 22 Jun 2020 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar – Configuring and Managing ADF Azure-SSIS Integration Runtimes! Abstract Azure Data Factory (ADF) includes Azure-SSIS Integration Runtimes, a mechanism by which SSIS packages are executed in Azure! Join Data Platform MVP Andy Leonard as he discusses and demonstrates …
Continue reading Free Webinar: Configuring and Managing ADF Azure-SSIS Integration Runtimes
Enterprise Data & Analytics is a SentryOne Partner
Did you know Enterprise Data & Analytics is a SentryOne Partner? We are! And we are honored to partner with SentryOne. We may have been the first partner to sign up in support of Task Factory – SentryOne’s suite of SSIS components and tasks – and SentryOne Test – which supports BI Testing. The Data …
Continue reading Enterprise Data & Analytics is a SentryOne Partner
Stop an Azure-SSIS Files Integration Runtime (Safely)
Recently, it happened to me. Again. I delivered another round of SSIS and ADF training, and I forgot to stop an Azure-SSIS integration runtime. I left it running for a few days and it cost me, well… more money than it would have cost me if I had remembered to stop it! Regarding the “Stop …
Continue reading Stop an Azure-SSIS Files Integration Runtime (Safely)
