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. |
| 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. |