Skip to main content
GuideServerConfigure and deploy Tabsdata servers on your machine.TutorialsConfigure data integration workflows within a running Tabsdata server.Advanced TutorialsBuild end-to-end workflows between two specific systems.API ReferenceCLI ReferenceRelease Notes
Version: 2.0.0

MSSQLSrcConn

class
class MSSQLSrcConn(
uri: UriSpec,
credentials: CredentialsSpec,
entity_whitelist: EntityWhitelistSpec | None = None,
conn_cfg: CfgSpec | None = None,
)

Bases: Conn

Categories: source

MSSQL connection used by MSSQLSrc.

Registered on a collection; the runtime resolves it and hands it to the plugin at run time. The uri accepts a plain string or a Secret.

Parameters

parameter

An MSSQL connection URI -- either a SQLAlchemy URI (mssql[+driver]://host[:port][/db]; the driver defaults to pyodbc) or a raw ODBC connection string (DRIVER=...;SERVER=...;DATABASE=...).

parameter

UserPassword (user + password).

parameter
entity_whitelistEntityWhitelistSpec | None (list[str] | None)

Optional list of regex patterns narrowing which tables the source considers; None (the default) filters nothing.

parameter
conn_cfgCfgSpec | None (dict | None)

Optional connector-config dict (see CfgSpec).