node-red-contrib-odbc 1.0.4

Node for node-red to unixODBC and its supported drivers. (MS SQL, PostgreSQL, ...)

npm install node-red-contrib-odbc

Node for Node-RED to unixODBC and its supported drivers. Based on node-odbc https://github.com/wankdanker/node-odbc

Requirements

  • unixODBC binaries and development libraries for module compilation
    • on Ubuntu/Debian sudo apt-get install unixodbc unixodbc-dev
    • on OSX using macports.org sudo port unixODBC
  • odbc drivers for target database
  • properly configured odbc.ini and odbcinst.ini.

Expample of odbcinst.ini

    [PostgreSQL]
    Description=ODBC for PostgreSQL
    Driver=/usr/lib/psqlodbc.so
    Setup=/usr/lib/libodbcpsqlS.so
    FileUsage=1

    [MySQL]
    Description=ODBC for MySQL
    Driver=/usr/lib/libmyodbc5.so
    Setup=/usr/lib/libodbcmyS.so
    FileUsage=1

    [FreeTDS]
    Description=ODBC for MS SQL
    Driver=/usr/lib64/libtdsodbc.so.0

    [MSSQL]
    Description=Microsoft ODBC Driver 11 for SQL Server
    Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
    Threading=1
    UsageCount=1

Install

After insuring that all requirements are installed run the following command in the root directory of your Node-RED install

    npm install node-red-contrib-odbc

Configure node

####Connection string

Config

####Query

Config

You can uses the mustache format.

Node Info

Version: 1.0.4
Updated 1 year, 6 months ago
License: ISC

Downloads

6 in the last day
23 in the last week
126 in the last month

Nodes

  • ODBC-CN
  • ODBC

Keywords

  • node-red
  • odbc
  • unixodbc
  • mssql
  • mysql
  • sql
  • PostgreSQL

Maintainers

  • efa2000