Connector MsSQL

The SQL Server connector enables LoopBack applications to connect to Microsoft SQL Server data sources.

Data In/Data Out

Data In

N/A

Data Out

CSV files in the out/tables folder.

Learn more: about the folder structure please go to this article. 

Parameters

Host (required)	Name of server that hosts the database.
Port (required)	The port number you want to access.
Database (required)	Name of database.
Username (required)	Account name.
Password (required)	Account password.

 

SSH Enabled (optional)	If you want SSH to be enabled.
Private (optional)	Private key.
Public (optional)	Public key.
SSH Host (optional)	Name of SSH Host.
SSH User (optional)	Username of SSH Host.

 

Name (required)	Name of table.
Query (required)	A query is a request to access data from a database to manipulate it or retrieve it.
Output Table (required)	The name of the output table you want to load the query.
Enabled(optional)	If you want the table to be enabled to disabled.