Forum

General discussion on using the Kognitio Analytical Platform.
Multiple Poster
Offline
User avatar
Posts: 2
Joined: Mon Apr 07, 2014 3:31 pm

wxloader

by codek » Mon Apr 07, 2014 3:58 pm

Hi,

We're using JDBC to pull data out of our WX2 database.

At the same time we want to try using wxloader to push data back into the database ( I assume wxloader will be faster than writing the data back via JDBC? )

But wxloader seems to be 32 bit, is that right? So do we have to setup both a 32 bit dsn and a 64 bit dsn? I'm a bit surprised that wxloader still seems to be using the odbc connection.

Thanks,
Dan
Reply with quote Top
Multiple Poster
Offline
Posts: 5
Joined: Wed Jun 05, 2013 1:18 pm

Re: wxloader

by GraemeCole » Tue Apr 08, 2014 10:24 am

Hi Dan,

We have both 32-bit and 64-bit versions of wxloader, but the Linux client tool bundle we distribute has the 32-bit tools in it. However, the bitness shouldn't matter. On Linux, our ODBC driver is compiled into the wxloader binary - it doesn't use a driver manager. So you shouldn't need to set up a specific 32-bit DSN.

wxloader uses ODBC to connect, as does everything else that connects to Kognitio. However, wxloader uses Kognitio-specific features to improve performance.

Our ODBC driver, such as the one compiled into wxloader, will look for an odbc.ini file in the directory named by the WCS environment variable. Note this is not the same as unixODBC, which calls it .odbc.ini. You might want to make one a symlink to the other. wxloader will use this odbc.ini file to look up the DSN you give it.

Alternatively, you can just give wxloader the IP address of the server, then you don't have to set up any ODBC config files.

e.g.

wxloader -s IP_ADDRESS_OF_SERVER -u USERNAME -t TABLENAME filename.csv

You can find more information on wxloader in the wxloader quick reference sheet or in the man page.

Graeme
Reply with quote Top
Multiple Poster
Offline
User avatar
Posts: 2
Joined: Mon Apr 07, 2014 3:31 pm

Re: wxloader

by codek » Tue Apr 08, 2014 10:42 am

Thanks; After trying the server IP it worked. Probably the help for the wxloader commandline tool could suggest this!
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: wxloader

by markc » Tue Apr 15, 2014 2:55 pm

For future reference, the man page for wxloader does indicate for -s "The DSN or host name of the Kognitio server", and if you search these forums in google for wxloader, with e.g.:

site:www.kognitio.com/forums wxloader

...you will be taken to a single sheet PDF on wxloader which explains the -s option in the same way.

It would be possible to add it to the output you get from running "wxloader" with no parameters as well, to cover all bases.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron