Microsoft SQL Server is a relational database management system.

Microsoft SQL Server is a software tool that allows users to store, manage, and retrieve data from relational databases. It provides a secure and scalable platform for businesses to manage their data, with features such as data warehousing, business intelligence, and advanced analytics. SQL Server also offers tools for developers to build and deploy applications that interact with the database, as well as tools for administrators to manage and monitor the system. Overall, SQL Server is a powerful and versatile tool for managing data in a variety of business settings.

Settings

Host

SQL Server host

Port

SQL Server port

Username

SQL Server username

Password

SQL Server password

Database

SQL Server database

Default Target Schema

Default target schema to write to

Table Prefix

Prefix to add to table name

Prefer Float Over Numeric

Use float data type for numbers (otherwise number type is used)

Driver

The driver to use for the database connection. Use pymssql (default) for the built-in driver, or pyodbc to use an ODBC driver installed on the host.

Trust Server Certificate

Trust the server certificate without validation (useful for self-signed certs).

Add Record Metadata

Whether to add metadata columns.

Batch Size

When a batch of rows reaches this size, the target will load it

Validate Records

Whether to validate the schema of the incoming streams

Flattening Enabled

'True' to enable schema flattening and automatically expand nested properties.

Flattening Max Depth

The max depth to flatten schemas.

Stream Maps

Config object for stream maps capability. For more information check out Stream Maps.

Azure Storage Account Name

Azure Storage account name used as the bulk-load stage.

Azure SAS Token

Shared Access Signature token for the storage account container (without a leading '?'). Minimum permissions: Read, Write, Create, Delete.

Azure Blob Container

Blob container used as the staging area.

Azure Blob Path Prefix

Virtual directory prefix inside the container.

Azure Credential Name

Name of the SQL Server DATABASE SCOPED CREDENTIAL used by OPENROWSET.

Azure Data Source Name

Name of the SQL Server EXTERNAL DATA SOURCE used by OPENROWSET.