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
Category:ADF
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
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
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)
Learn Azure Data Factory and SSIS and Save Money!
I am excited to announce two additional live, online training deliveries: SSIS Data Flows – 27-28 May 2020 SSIS Administration – 02-03 Jun 2020. Note: SSIS Data Flows is a prerequisite for SSIS Administration. SSIS Data Flows is the first two days of my four-day live, online From Zero To SSIS course – which I …
Continue reading Learn Azure Data Factory and SSIS and Save Money!
Moving Data with ADF Recording is Available!
I (re-)delivered the free webinar titled “Moving Data with Azure Data factory” 6 Apr 2020. I can hear you thinking, “Why did you re-deliver the webinar, Andy?” I failed to capture the recording when I first delivered the webinar 31 Mar 2020. It was all my fault. Apologies. Enjoy this recording! :{>
Using Parameters in ADF Recording is Available
The recording for Using Parameters in Azure Data Factory is available. Enjoy! :{>
Azure Data Factory Execution Patterns Recording is Available!
The recording for Azure Data factory Execution Patterns is available! Enjoy. :{>
Free Training for People Who Have Lost Their Jobs
Update: I am unable to offer free training to people who lost their job due to the pandemic at this time. Thank you to everyone who took advantage of this offer. I hope the training helped. – Andy I saw a tweet earlier today from another friend who has been laid off as a …
Continue reading Free Training for People Who Have Lost Their Jobs
ADF Publisher Pending Changes Blade
There I was… writing a post titled ADF Wait Activity Wait Time Property is Now Dynamic. I had completed building a couple demo Azure Data Factory (ADF) pipelines and clicked the Publish All button. What did I see? Another new thing! Or at least, another update to ADF – the Publish All blade: If you …
Continue reading ADF Publisher Pending Changes Blade