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 #

Meltano helps you manage your configuration, incremental replication, and scheduled pipelines.

View the Meltano-specific tap-mssql instructions to learn more.

Capabilities #

Settings #

tap-mssql requires the configuration of the following settings:

These and other supported settings are documented below. To quickly find the setting you're looking for, use the Table of Contents at the top of the page.

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 the tap-mssql tap to work, 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. Edit it on GitHub!