MSSQL
M
MSSQL

tap-mssql (matatika variant)

MSSQL is a relational database management system developed by Microsoft.

MSSQL is a powerful database management system that allows users to store, manage, and retrieve data efficiently and securely. It is designed to handle large amounts of data and can be used for a wide range of applications, from small business websites to large enterprise systems. MSSQL offers a variety of features, including support for multiple programming languages, advanced security features, and high availability options. It also includes tools for data analysis and reporting, making it a comprehensive solution for managing data. Overall, MSSQL is a reliable and scalable database management system that can help businesses of all sizes streamline their data management processes.

Settings

User

The username used to authenticate with the MSSQL API.

Password

The password used to authenticate with the MSSQL API.

Host

The hostname or IP address of the server running the MSSQL API.

Port

The port number on which the MSSQL API is listening for incoming connections.

Database

The name of the database to connect to on the MSSQL server.

SSH Tunnel Host

Address of the bastion host, this is the host we'll connect to via ssh

SSH Tunnel Port

Port to connect to bastion host

SSH Tunnel Private Key

A base64 encoded Private Key for authentication to the bastion host w/ key pair auth

SSH Tunnel Private Key Password

Private Key Password, leave None if no password is set

SSH Tunnel Username

Username to connect to bastion host

SSH Tunnel Password

Password to connect to bastion host w/ basic auth

Meltano Cloud Connector

MSSQL connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.