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](../_images/ms-sql-1.png)
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](../_images/microsoft-sql-server__output.png)
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.