TechDays Hong Kong 2015: Azure Data Factory vs. SSIS


It has been long time passed from my presentation in Hong Kong TechDays 2015 on Mid February, I’ve been really busy so far and hadn’t chance to upload my presentation files here. I would like to thank all audience of my session on Azure Data Factory vs. SSIS, and provide you the link to my presentation slides. In this session you will see comparison between SSIS and Azure Data Factory on different factors such as developments, features, deployments, user experience, environment, and etc. For each comparison factor you will see a table comparison of these two products and their pros and cons for different situation.


Azure Data Factory – Updates: March 2015

Previously in another post I’ve mentioned what Azure Data Factory is and a sample scenario of data transfer with it.

Microsoft recently published a new version of it, which has really interesting features. In a nutshell features are:

  • New Version of Data Management Gateway
  • On Premises File System Linked Services
  • On Premises Oracle Linked Services
  • Encoding options for text files on Azure Blog storage
  • Invoking Stored Procedures with additional parameters.

Have a read in details about these new features below;


Introduction to Azure Data Factory

Many of you worked with SSIS and are familiar with term of ETL. Azure Data Factory is Microsoft Cloud based ETL technology, which has ability to work with large volume of data, working with data sources such as SQL Server on premises, SQL Server Azure, or Azure Blob storage. Data can be transformed with Azure Read more about Introduction to Azure Data Factory[…]

Configure Data Management Gateway from Azure Portal

Today I’ve faced an issue; when the Power BI Admin Center does not work I want to configure and set up Data Management Gateway. Data Management Gateways is a service that install on your machine or any on premises server, and allow cloud services (such as Power BI or Azure Data Factory) to connect to Read more about Configure Data Management Gateway from Azure Portal[…]