Page 1 of 1
Connection to Pervasive database
Posted: Thu Jun 22, 2006 7:26 am
by eldonp
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.
Posted: Thu Jun 22, 2006 7:33 am
by ArndW
None that I know of; even DirecConnect only supports it on Windoze.
Posted: Thu Jun 22, 2006 7:38 am
by DSguru2B
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.
Posted: Thu Jun 22, 2006 7:38 am
by chulett
Pervasive? That's a new one on me... I thought you meant one that 'has the quality or tendency to pervade or permeate'.
Posted: Thu Jun 22, 2006 1:40 pm
by ray.wurlod
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.