Connection to Pervasive database

eldonp · Post by **eldonp** » Thu Jun 22, 2006 7:26 am

Were running Datastage AIX. I need to extract from a Pervasive database. Whats the best way to connect? So far, we've used ODBC on other sources but I havnt found an ODBC driver for Unix yet.

ArndW · Post by **ArndW** » Thu Jun 22, 2006 7:33 am

None that I know of; even DirecConnect only supports it on Windoze.

DSguru2B · Post by **DSguru2B** » Thu Jun 22, 2006 7:38 am

I think you need to get in touch with Ascential support. There are other connectors available. Some unix based apps too. But never got a chance to work with it. Your best bet, try getting in touch with support.

chulett · Post by **chulett** » Thu Jun 22, 2006 7:38 am

Pervasive? That's a new one on me... I thought you meant one that 'has the quality or tendency to pervade or permeate'.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 22, 2006 1:40 pm

Does Pervasive have the ability to dump its tables in text-file formats? If so you could script that, run the script from DataStage, then process the text file.