MSSQL Connect

MSSQL data into your data warehouse in minutes

Collect MSSQL data into your data warehouse or ours. The Matatika pipelines will take care of the data collection and preparation for your analytics and BI tools.

Automate MSSQL from a single space with no code

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

Host 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

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


View source code

MSSQL data you can trust

Extract, Transform, and Load MSSQL data into your data warehouse or ours.

Interested in learning more?

Get in touch