Microsoft SQL Server

Microsoft SQL Server can either be used as a data source or a data destination in Zuar Runner.

Zuar Runner and Microsoft SQL Server

Source plugin example: Query

Destination plugin examples: CSV, Salesforce, SQL

Microsoft SQL Server as a Data Destination

  • Zuar Runner automatically creates the Microsoft SQL Server database schema if it doesn’t exist

  • Zuar Runner automatically creates the Microsoft SQL Server database tables if they don’t exist

  • Zuar Runner automatically determines data types for Microsoft SQL Server columns

  • Zuar Runner automatically adds new columns to Microsoft SQL Server tables based on new fields in source systems

  • Zuar Runner automatically adjusts Microsoft SQL Server tables based on changes in source data

Microsoft SQL Server Specific Setup

Below is the database url structure for connecting to a Microsoft SQL Server database:

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

Note

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

Here’s an example of using a Microsoft SQL Server database as a destination in a CSV job:

Microsoft SQL Server Destination

Note

When outputting to a Microsoft SQL Server database, leaving the “Schema” blank will create a table in the dbo schema.

SQL

Zuar Runner can send SQL statements to a Microsoft SQL Server database. Use Microsoft SQL Server syntax in these Zuar Runner SQL jobs.