Overview

Azure SQL can either be used as a data source or a data destination in Mitto.

Source plugin example: Query

Destination plugin examples: CSV, Salesforce, SQL

Azure SQL as a data destination

  • Mitto automatically creates the Azure SQL database schema if it doesn't exist
  • Mitto automatically creates the Azure SQL database tables if they don't exist
  • Mitto automatically determines data types for Azure SQL columns
  • Mitto automatically adds new columns to Azure SQL tables based new fields in source systems
  • Mitto automatically adjusts Azure SQL tables based on changes in source data

Azure SQL specific setup

Below is the database url structure for connecting to an Azure SQL database:

mysql+pyodbc://<username>:<password>@<hostname>/<database>?<parameters>

NOTE: Azure SQL requires a parameter for the Azure SQL driver. Typically this is ?driver=ODBC+Driver+17+for+SQL+Server.

Here's an example of using an Azure SQL database as a destination in a CSV job:

NOTE: When outputting to an Azure SQL database, leaving the "Schema" blank will create a table in the dbo schema.

SQL

Mitto can send SQL statements to an Azure SQL database. Use Azure SQL syntax in these Mitto SQL jobs.