kognitio

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

1. sudo yum install unixODBC

2. sudo yum install mysql-connector-odbc

3. Download http://www.kognitio.com/forums/latest_810_linuxclients.tar.gz and extract to /opt/kognitio

4. 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

5. 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

6. 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);
});