regarding extracting data from postgresql

panchusrao2656 · Post by **panchusrao2656** » Tue Jul 18, 2006 9:12 pm

is there any particular stage to extract data from postgresql
Thanks in advance

chulett · Post by **chulett** » Tue Jul 18, 2006 9:43 pm

I'm gonna take a wild guess here and say... ODBC.

kcbland · Post by **kcbland** » Tue Jul 18, 2006 9:47 pm

We just talked about this the other day. I don't believe there's a working ODBC driver out there. I suggested scripted extractions and loadings.

chulett · Post by **chulett** » Tue Jul 18, 2006 10:39 pm

Ok, I recall that now but I do believe it is the only applicable 'stage' answer. So if that's not an option then scripted extractions and loadings it is.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 19, 2006 1:59 am

Writing your own plug-in stage is (theoretically at least) also an alternative. This is the reasoning behind the entire plug-in architecture of DataStage; to be able to create components to do things that the standard one's can not do. Is there an API for communicating with postgresql ?

The manual Plug-In Writer's Guide is available from IBM for the asking, through your support provider.