Microsoft SQL Server

tap-mssql (singer-io variant)🥈

Microsoft SQL Server

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

Alternate Implementations

Getting Started

Prerequisites

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Required Pre-Installation

This edition of the SQL Server tap is built in Clojure and requires a JVM preinstalled. For this reason, you will need to perform custom installation steps before you will be able to use this with Meltano.

For more information, please see the tap-mssql readme: https://github.com/singer-io/tap-mssql#requirements

Installation and configuration

  1. Add the tap-mssql extractor to your project using
    meltano add
    :
  2. meltano add extractor tap-mssql --variant singer-io
  3. Configure the tap-mssql settings using
    meltano config
    :
  4. meltano config tap-mssql set --interactive
  5. Test that extractor settings are valid using
    meltano config
    :
  6. meltano config tap-mssql test

Next steps

If you run into any issues, learn how to get help.

Capabilities

The current capabilities for tap-mssql may have been automatically set when originally added to the Hub. Please review the capabilities when using this extractor. If you find they are out of date, please consider updating them by making a pull request to the YAML file that defines the capabilities for this extractor.

This plugin has the following capabilities:

  • catalog
  • discover
  • state

You can override these capabilities or specify additional ones in your meltano.yml by adding the capabilities key.

Settings

This plugin currently has no settings defined. If you know the settings required by this plugin, please contribute!

Something missing?

This page is generated from a YAML file that you can contribute changes to.

Edit it on GitHub!

Looking for help?

If you're having trouble getting the tap-mssql extractor 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.

Install

meltano add extractor tap-mssql --variant singer-io

Maintenance Status

  • Maintenance Status

Repo

https://github.com/singer-io/tap-mssql
  • Stars
  • Forks
  • Last Commit Date
  • Open Issues
  • Open PRs
  • Contributors
  • License

Maintainer

  • Stitch Data

Meltano Stats

  • Total Executions (Last 3 Months)
  • Projects (Last 3 Months)

Keywords

  • databaseclojure