@ais_automation/node-red-contrib-odbc
v2.0.0
Published
Node for node-red to unixODBC and its supported drivers. (MS SQL, PostgreSQL, ...)
Downloads
45
Readme
node-red-contrib-odbc
Node for Node-RED to unixODBC and its supported drivers. Based on node-odbc https://github.com/wankdanker/node-odbc
NOT SUPPORTED!
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
- on Ubuntu/Debian
- odbc drivers for target database
- properly configured odbc.ini and odbcinst.ini.
Example 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
####Query
You can uses the mustache format.