Blog & Company Updates

Moving Data from an On-Prem Database Using Azure Data Factory

Do you want to learn how to move an on-premise database using Azure Data Factory (ADF)? In a recent webinar, Thom Pantazi, walks you through how to do this.

This demo-heavy presentation will spend a little time on what Azure Data Factory is and a typical ADF architectural overview. Azure Data Factory is a cloud service that provides developers access to data movement technologies with connections to most data sources.

ADF contains all its functionality in a graphical user interface that allows for flow control and logic to be used all in one environment without programming. You can also have your data pipelines or events triggered based on schedules or activities in the Azure environment.  

Below is a typical ADF architecture. The concept here is when you’re in an ADF environment, you’ll have some on premises data that you’ll want to add and to do that you’ll need a few components. You’ll have your data source(s) and they would talk to an integration runtime which is a piece of software that encapsulates all the data transfer to the specific pipeline you’ve set up in the cloud. The next step is in your ETL process.

T Pantazi Architecture Overview

 

The remainder of the presentation is a demo of all this architecture and you’ll learn how to move your on prem database using ADF. You can watch the complete webinar below.

If you have questions about migrating on premise data to the cloud or about getting your business into the Azure cloud, our experts are here to help with our consulting and managed services offerings.

As your architecture becomes more complex and the amount of data you’re working with grows, your data ecosystem can experience performance and scalability issues. This can lead to your DBA team being overworked and unable to tackle their high-volume of weekly and monthly tasks.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

Author

  • 3Cloud is a “born in the cloud” Gold-certified Microsoft Azure technology consulting firm and Azure Expert Managed Services Provider that provides cloud strategy, design, implementation, and managed services to clients across multiple industries. Founded by former Microsoft technology leaders, 3Cloud combines a team of highly experienced cloud architects and technologists with a strong network of Microsoft sales and engineering relationships to deliver the ultimate Azure experience for clients. 3Cloud is headquartered in Chicago, Illinois with offices in Dallas, Texas and Pittsburgh, Pennsylvania and supports clients throughout North America and Europe. To learn more, visit www.3cloudsolutions.com.

3CloudMoving Data from an On-Prem Database Using Azure Data Factory