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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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)
The SSIS Catalog and SCCPAC Files
The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files
On Installing Integration Services Versions Side-by-Side
I do not recommend installing Integration Services versions side-by-side. Microsoft provides an article describing how to accomplish side-by-side installation of Integration Services, but the article has not been updated in over three years and the last SSIS version mentioned is 2016. Over the years, I have helped customers who have more than one version of …
Continue reading On Installing Integration Services Versions Side-by-Side
On Working From Home
Note: Featured image courtesy of the CNN article What is coronavirus and Covid-19? An explainer. I’ve been working from home for about 15 years at the time of this writing. A lot of people experienced working from home for the very first time recently, as we (the planet) locked down for the pandemic. Although I’ve …
Continue reading On Working From Home