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.

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.