MSSQL
💬 Description
MSSQL is a relational SQL database. If you’re absolutely thrilled to learn more about what that is, check Codecademy’s explanation.
🤑 Use Case
Connecting to an MSSQL database is very helpful if you have your own application that pushes data to a database. Such a database usually contains information on your customers and their behavior, but it could contain many important things.
🛠️ Setup
This Connector should probably be configured by (or with assistance from) your database responsible - you’re also welcome to schedule a call.
If your MSSQL (or the server it's hosted on) has restrictive inbound IP rules, you need to schedule a call with us as you cannot access the Less application’s IP currently. We are working on displaying the IP of the Less application inside the web application.
If your MSSQL (or the server its hosted on) has unrestricted IP access, continue below 👇
Step #1: Host IP
Input the Host IP of your MSSQL in the Less configuration window. Usually looks something like this: 87.398.80.712
Step #2: Host Port
Input the Host Port of your MSSQL in the Less configuration window. It’s usually 1433.
Step #3: Database Name
Input the Database name of your MSSQL in the Less configuration window.
Step #4: Input Table(s)
Input the names of the MongoDB Collections you want to extract in the Less configuration window. This should be a comma-separated list like table1,table2,table3
Step #5: Username & Password
Input the username and password of a MSSQL account with read access. Everything is encrypted in transit and at rest.
Last updated