Kognitio Connection for Node JS
This module is extremely basic and has only been setup under CentOS. If anyone figures out how to install on other systems, please do let me know.
Installation
Kognitio requires ODBC in order for connections to be made.
CentOS
-
sudo yum install unixODBC
-
sudo yum install mysql-connector-odbc
-
Download http://www.kognitio.com/forums/latest_810_linuxclients.tar.gz and extract to /opt/kognitio
-
Edit /etc/odbc.ini to add the following DSN:
[KOGNITIO] Driver=/opt/kognitio/lib64/libwcsodbc.so ServerAddress1=IP_ADDRESS ServerPort1=6550 Timeout=15 ForceConnect=N WX2ODBCDBG=1 SSLEnabled=N
-
Edit /etc/odbinst.ini to add the following Driver:
[WX2] Description=WX2 ODBC driver for Linux Driver=/opt/kognitio/lib64/libwcsodbc_utf16.so Setup=/opt/kognitio/lib64/libwcsodbcS.so UsageCount=1
-
In your project file, run npm install --save kognitio
##Usage
var Kognitio = require('kognitio');
Kognitio.setConfig({user: 'username', pass: 'password', dsn: 'PROD4', driver: 'WX2'})
Kognitio.query('SELECT * FROM schema.table',function(err,rows,more){
if(err){
return console.log(err);
}
console.log(rows);
});