The tap-mssql Singer tap pulls data from Microsoft SQL Server that can then be sent to a destination using a Singer target.

Alternative variants #

Multiple variants of tap-mssql are available. This document describes the default wintersrd variant, which is recommended for new users.

Alternative variants are:

Standalone usage #

Install the package using pip: 

pip install tap-mssql

For additional instructions, refer to the README in the repository.

Usage with Meltano #

Install Meltano, create your Meltano project, and add the tap to your project as a custom extractor: 

meltano add --custom extractor tap-mssql

Then, configure the extractor, add any Singer target as a loader to send data to a destination and run a data integration (EL) pipeline.

Capabilities #

Settings #

Host (host) #

Your MSSQL server host.

Database (database) #

Your MSSQL database name.

User (user) #

Your MSSQL username.

Password (password) #

Your MSSQL password.

Filter Databases (filter_dbs) #

A comma separated list of databases to filter for.

Port (port) #

The MSSQL port, defaulted to 1433.

tds_version (tds_version) #

The TDS version of the connection. Defaults to 8.0, connecting to older databases (ex MS SQL 2005) requires 7.0 or earlier

Looking for help? #

If you're having trouble getting tap-mssql to work by itself or with Meltano, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page? #

This page is generated from a YAML file that you can contribute changes to! It is also validated against a JSON Schema used for taps and targets.


Edit this page on GitLab!