Series

Data Integration

Articles in this series

How to import a CSV in Azure SQL Database using Python

Apr 2, 20231 min read

Importing a CSV file into an Azure SQL Database is a common task for data engineers and data scientists. In this tutorial, we will learn how to import...

How to import a CSV in Azure SQL Database using Python

Connecting to Azure SQL Database from Python

Apr 2, 20232 min read

Azure SQL Database is a cloud-based database service offered by Microsoft. In this document, we will discuss how to connect to an Azure SQL Database...

Connecting to Azure SQL Database from Python

ETL from SQL Server to Azure Synapse Analytics with Slowly Changing Dimensions (SCD) Type 2 using Python

Apr 5, 20232 min read

Install the required libraries: You’ll need the pyodbc, pandas, and azure-synapse libraries. Install them using pip: pip install pyodbc pandas...

ETL from SQL Server to Azure Synapse Analytics with Slowly Changing Dimensions (SCD) Type 2 using Python

Azure Data Factory with local SQL server database

Apr 5, 20232 min read

Follow these steps to set up and use Azure Data Factory with a local SQL Server database: Install and configure a Self-hosted Integration Runtime...

Azure Data Factory with local SQL server database