watermark picture

Blog

etl

Microsoft Azure Data Factory vs. on-premise ETL – tools: key features compared

A classic ETL-tool is a desktop tool which requires a good-sized server where the tool needs to be installed on. The server will also have to be managed and a basic monitoring needs to be set up to check the health of the system. This also means that the size of the server will have to be determined at front. The ETL-tool will have to be maintained and upgraded when necessary. ADF is a cloud-based, serverless service and does not require any hardware or any installation. Since no server is required, no monitoring or managing of it is needed. Updates of ADF are fully managed by Microsoft and will be implemented automatically.

When using a classic ETL-tool, scaling can be a bottleneck for an agile business. Classic ETL-tools are not always created to handle big volumes of data and the type of server cannot always be switched easily, which will result in a higher time to market. This is one of the main reasons why cloud is so conductive: your system can be upgraded in no time to each desired level.

Read More

Microsoft Azure Data Factory as a must-consider alternative for on-premise ETL – tools

When using cloud-based technology your data is processed, stored and maintained in the cloud and not on a physical server at your organization.

This means that no infrastructure is necessary for the set-up and you don’t need to worry about system maintenance. This helps in saving resources (time and money) at the start of a project which can be used to understand requirements of the business. Your cloud solution will also be more adaptable to changing situations : newer features can be added easily and up-scaling is only one click away. By the hand of the different data security protocols and features, you can sleep soundly that your data will be secure in the cloud.

Read More