Configure Azure Data Factory Security for the ADF REST API

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

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)