hana-odbc

SAP HANA access for nodejs via odbc.

hana-odbc

node.js library that is a thin wrapper around node-odbc to connect to

Install

node-odbc will need a odbc driver to connect to HANA. I have used unixodbc so far. For using it make sure you setup a data source (DSN) that points to a HANA instance. Here is a description for how to setup an odbc connection on Ubuntu.

hana-odbc is on npm, to install it run

$ npm install hana-odbc

If a corporate firewall is bugging npm try

$ npm --proxy http://username:password@proxyservername:port --strict-ssl false install

To install from github do

$ git clone https://github.com/rksm/node-hana-odbc.git
$ cd node-hana-odbc
$ npm install

Usage

The test.js file shows how to connect to and query a database. It uses the SFLIGHT schema by default. To test if it works make sure your DB includes this schema and run

$ node test.js username password

server.js shows how you can provide a HTTP interface with a expressjs-like backend.

To just use the programatic interface require hana-interface.js ast it is done in test.js and server.js.

Returns an odbc session object for interacting with a HANA database.

Arguments

  • dsn - Specifies the data source and access parameters.

Example

var session = hanaInterface.getSession({dsn: "DSN=hana;UID=UserName;PWD=Password"});

Establishes a connection to a HANA DB.

Arguments

  • callback - Called when the connection was established or when an error occurs. Called with one argument, an error object.

Example

session.connect(function(err) {
    if (err) console.error('Could not connect!');
    else console.log('Connection established!');
});

Selects a schema, sends a query, and invokes callback with the query result. If no DB connection is established yet this method will also create a connection.

Arguments

  • schema - String, the name of the schema
  • sqlStatement - String, the SQL to run
  • callback - Function that takes two arguments: error and result. result is a object matching {rows: rows, hasMoreResultSets: moreResultSets}. The property rows is an array representing the rows that are the query result. hasMoreResultSets is a Bool that signals whether there are more results. If true, callback will be called again with the remaining results.

Example

session.query(
    'SFLIGHT', "select * from SAPLANE",
    function(errresults) {
        console.log(JSON.stringify(results, null, 2));
        if (!results.hasMoreResultSets)
            session.close(console.log.bind(console, 'done'));
    });

Ends the connection to a HANA DB.

Arguments

  • callback - Called when the connection was closed. Takes an error object as its single arguments that is non-null in case of a problem closing the connection.

Example

session.close(function(err) {
    if (err) console.error('Could not close!');
    else console.log('Closed!');
});

License

MIT License