node-red-contrib-azure-sql 0.0.3

Connector to Azure SQL Database on Node-Red

npm install node-red-contrib-azure-sql

Node-RED nodes to talk to Azure SQL Database.

Some code of Azure are under MIT License.

Install

Run the following command in your Node-RED user directory - typically ~/.node-red

    npm install node-red-contrib-azure-sql

Usage

Azure node. Can be used to work with Azure SQL Database

  • Supports :

‚ó¶Select (query) into Azure SQL

Still working to insert new data.

##How to use:

You must have create the database before to use. You will use:

  • Azure SQL URL (endpoint)
  • Login
  • Password
  • Database name

Use msg.payload to query data into Database.

Ex: 'msg.payload' -> {"action": "Q", "query" : "SELECT * FROM table WHERE firstName = 'Lucas'"};


Read more about Azure SQL Database on Azure SQL Database.

Node Info

Version: 0.0.3
Updated 1 year ago

Downloads

2 in the last day
26 in the last week
97 in the last month

Nodes

  • Azure SQL

Keywords

  • node-red
  • Azure
  • SQL Database
  • SQL

Maintainers

  • luhumenh