Configuration

To set up the MSSQL source, provide the following configuration parameters:

KeyDescriptionSample Value
databaseName of the database you want to read data from.msdb
hostHostname of the MSSQL database, including port number at the end (e.g., host,port).172.20.0.2,1433
passwordPassword for the MSSQL user to access the database.abc123...
portPort where the database is running (typically 1433).1433
schemaSchema of the database you want to read data from.public
usernameUsername that will access the database (must have read and write permissions to the specified schema).guest

Optional Configuration

KeyDescriptionSample Value
authenticationAuthentication mode for connecting to MSSQL with Azure Active Directory authentication.ActiveDirectoryServicePrincipal
batch_fetch_limitNumber of rows to fetch per batch (defaults to 50,000). Adjust if your instance has more memory.50000
driverODBC driver for SQL Server.ODBC Driver 18 for SQL Server