topic ODBC drivers for PERVASIVE DB in QlikView

ODBC drivers for PERVASIVE DB

Wed, 23 Sep 2009 14:04:35 GMT

Know anyone where I can get ODBC drivers for PERVASIVE DATABASE? Perhaps there is also free?
I am going to start with ODBC. Thank You,
Thank you.

ODBC drivers for PERVASIVE DB

Tue, 06 Oct 2009 22:54:30 GMT

You need to download the trial version from here: http://www.pervasivedb.com/Database/Trials/Pages/PSQLSummitv10TrialDownloads.aspx

you need to register and get a link. Then only install the pervasive client, not the server trial version. If you're on a 64-bit server then you still need to install the 32-bit client.

After that you can create a connection through the qlikview code interface.

ODBC drivers for PERVASIVE DB

stevedark — Wed, 07 Oct 2009 03:29:28 GMT

Hi There,

There is a bit of a gotcha with using Pervasive databases, unless someone is aware of a way around this.....

It would appear that when the ODBC connection is used that any indexes set up in the Pervasive database are not employed - so a full table scan is used each time. When we tried to pull out just the current months data from a table with a few years history it was the best part of an hour before any rows were returned (as the new rows are at the end of the table). Doing this in the desktop version of QlikView it appears to hang, as the time elapsed is only updated as rows come in, it is also impossible to cancel out cleanly unless rows are being brought in.

Regards,
Steve

ODBC drivers for PERVASIVE DB

Thu, 17 Feb 2011 05:45:46 GMT

Hi Steve

We've seem to run into the same problem. Have you managed to derive a work around since your last post?

What about the new QVX feature in QlikView 10?

Regards,

Ferdinand

ODBC drivers for PERVASIVE DB

stevedark — Fri, 18 Feb 2011 01:16:32 GMT

Hi Ferdinand,

This was quite a long time ago now on a client site that I have not been back to for some time....

We did get the data extracts going at a sensible rate in the end, and I seem to recall that the indexes would be used provided the SQL statement was structured to exactly match the index. For example, make sure the fields in the where clause appear in the same order as they do in the index. Also, if there is a field in an index that you don't want to limit your extract to still put it in the where clause of your statement as Field = '%' - to ensure the index is used.

The requirement for this derives from the fact that the query parser in Pervasive (or maybe just the ODBC driver) is not as intelligent as most RDBMS's and does not work out execution plans very well.

If you have serious amounts of data you need to move about and want bespoke drivers then I can recommend speaking to a company called Attunity. Getting data from 'classic' systems is what they are all about.

This may be stating the obvious - but if you have slow data transfer from your source system put some thought into QVD usage and incremental loads - search Qlik Communities for more information on this.

Hope that helps.

Regards,
Steve

ODBC drivers for PERVASIVE DB

Fri, 18 Feb 2011 07:45:26 GMT

Thanks Steve.

I'll test over the weekend.

Regards,

Ferdinand

Re: ODBC drivers for PERVASIVE DB

felixobes — Sat, 08 Feb 2014 14:26:18 GMT

How did it go? Any good results?

Re: ODBC drivers for PERVASIVE DB

felixobes — Mon, 10 Feb 2014 00:29:50 GMT

You mean the Connect product? I liked the value proposition they propose, but I am interested in the Pervasive data.

Re: ODBC drivers for PERVASIVE DB

milkyryan — Mon, 10 Feb 2014 02:10:30 GMT

Hi Guys,

Just quickly I've had some experience connecting to Pervasive databases when supporting a Sage product (Platinum for Windows if that rings a bell...).

While the Pervasive server/client ODBC drivers worked reasonably well, we also had a good experience using some old Intersolv (now known as DataDirect I believe) btrieve ODBC drivers.

This would work without Pervasive SQL installed and very simple to set up, just needed data dictionary (DDF) files in the relevant data folder).

Re performance it seemed to work quite well on large data sets but hard to say if there will be an improvement over Pervasive ODBC drivers.

It looks like newer versions are available from DataDirect if you wanted to contact them for more info: "http://www.datadirect.com/support/product-documentation/product-information/support-matrices/datadirect-connect-and-connect-xe-for-odbc/windows"

Re: ODBC drivers for PERVASIVE DB

felixobes — Wed, 12 Feb 2014 17:32:14 GMT

Ok, now I managed to connect using the progress drivers. Still, I am only able to pull data from one table at a time.

Re: ODBC drivers for PERVASIVE DB

milkyryan — Fri, 21 Feb 2014 05:55:23 GMT

Hi Felix, that's good news. Where did you source the progress drivers from?

When you say one table at a time, I'm assuming you can't run any join operations, etc. against other tables?

Re: ODBC drivers for PERVASIVE DB

felixobes — Mon, 24 Feb 2014 14:01:55 GMT

I installed the Trial of the progress driver from the same link yo shared, and only can create a Betrieve ODBC entry through the 64bit ODBC Admin. Once I first tried I had missing DLL errors for all Pervasive DLLs, like wbtrv32 and other 2, which I fished for and installed.

Using the Progress drivers I could connect to the dat file using the DDFs. I will have to perform additional operations with other dbs as I feel the problem is the export itself. Will let you guys know.