top of page

Revolutionize Your Data Integration Practices with Azure Data Studio

Webinar | Nov 11, 2020

This webinar shows a high level overview of how to use Azure Data Studio to:

  • Build SSIS Projects & Packages for Visual Studio

  • Build & Run Azure Data Studio ‘Native ELT’ Packages

  • Build & Deploy ‘Azure Data Factory’ Pipelines

The presentation itself was made in a Jupyter Notebook within Azure Data Studio. The notebooks themselves are so powerful that we are able to run these packages right inside them to demonstrate, interactively, how we can increase your data integration efficiency.

 

Webinar Resources:

Why Azure Data Studio:

  • Fork of VS Code

  • Designed for Database Professionals

  • Open Source, Cross Platform

  • Designed for Extensibility

  • Integrated Jupyter Notebooks

  • Customizable Dashboards & Visualizations

  • Integrated Terminal Window

​

ELT instead of ETL:

  • Transformations are Pure SQL (the True Language of Databases)

  • Performance and Scalability in the Cloud (use 5x, 10x, or 100x Compute Power when needed)

  • Able to leverage “Stored Procedures” (Manage your code in the Database)

  • Avoid Vendor-Lock (SQL code is easier to migrate than ETL Solutions

​

​

bottom of page