kognitio v1.0.1

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