Microsoft SQL Server
Table of Contents
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.