Setting Datadirect of DS to see Postgres DB

xrobin · Post by **xrobin** » Tue Apr 10, 2007 6:07 am

Dear all gurus,

My team need to use DS7.5.1 ,postgres DB and Solaris9.

I know that the Postgres DB need to have iodbc or unix odbc but I have heard DS also has other solution, it is Datadirect.

I have tired to config .odbc.ini in example directory to point to postgres lib but after I connect via ./example ,it occurs error.

Have anyone pass this circumstance? Would you mind to share me ^-^

Thanks in advance.

Robin. :twisted:

chulett · Post by **chulett** » Tue Apr 10, 2007 6:17 am

Welcome Aboard. :D

Yes, DataStage does ship with 'branded' ODBC drivers but not one for Postgres. When people mention 'Datadirect' here, they mean for you to purchase the appropriate ODBC drivers from them. I really don't believe you have a solution 'out of the box' and that purchasing specific drivers is your only option.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 10, 2007 1:06 pm

Data Direct is the name of a software company (www.datadirect.com) that sells ODBC drivers.

It is not "something else".

A search on their web site failed to find any reference to Postgres.

Direct access to major database tables (such as DB2 or Oracle) - that is, reading the rows directly - is possible only in DataStage parallel jobs (you have posted a question purporting to relate to server jobs). Direct access to Postgres tables is not supported in DataStage.

That said, the DataStage architecture would allow a plug-in stage to be written to provide direct access to Postgres tables, in combination with the Postgres API. Ask your support provider to source a copy of the Plug-In Writer's Guide manual from IBM.