Search
  • Noel

Microsoft Azure Data Share can eliminate some ETL work

This post is for those in Information Technology working with database software. So for the rest of you have a great day and sorry to bug you with a geeky post.


I just tried out Azure Data Share. It allowed me to set up a recurring schedule that would sync several tables from an Azure Database in one tenant to an Azure database in a completely different tenant.

The main use case is if you are sharing data with another company you no longer have to develop ETL jobs to copy data from one tenant to the other or post to an FTP site or burn it on a CD and mail it. OK, the last one dates me to the Blockbuster era. Instead of all the development work you can click a few times and you're done.

On the downside the incremental feature is not supported for databases (yet).

2 views0 comments

Recent Posts

See All

Hello, if your customers need a data warehouse solution, we have developed tools to rapidly develop a modern data warehouse using Azure Data Factory, Azure SQL and Power BI. Our tool is called ChillET

Microsoft has just added the Fail Activity to ADF to be able force a failure within a pipeline. So no longer do you have do things like call a stored procedure to raise an error or force an invalid d