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.
Many organizations nowadays are in transition from on-premises to cloud, and many of them use hybrid solutions where part of the computing will be done in cloud and the rest on-premises. The trend nowadays is to use cloud to have better maintenance, lower costs, more reliable solutions, lower administrative efforts, and powerful shared resources. In BI world there is a high demand for solutions to be on cloud, some computing services such as data transfer and ETL to be done on cloud, some data analysis and mining solutions happens on cloud, and even data to be stored on cloud data warehouse at some stage. There are many BI vendors in the market, but there are few who provide BI on the cloud.
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;
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[…]
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[…]