Node for Node-RED to unixODBC and its supported drivers. Based on node-odbc https://github.com/wankdanker/node-odbc
- 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.
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
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
####Connection string
####Query
You can uses the mustache format.