how config odbc connect greenplum on datastage?

mike369 · Post by **mike369** » Fri Mar 23, 2012 12:39 am

who can tell me?
how config odbc connect greenplum on datastage?
please tell me details steps, thank you very much.

my os config:
ds version:7.5.2
os version:aix 5.3
greenplum version:4.1

chulett · Post by **chulett** » Fri Mar 23, 2012 5:53 am

Next time, please just do this - one post asking your question in the proper forum rather than adding it to every post you could find that was slightly related.

ps. I've deleted all of your duplicate posts.

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 10:07 am

The GreenPlum driver appears to be not much different than any other.... Go to your $DSHOME location and edit the .odbc.ini file and create an entry with that driver giving it the actual database name, port number, and host name (or IP address) of the server.

mike369 · Post by **mike369** » Sun Mar 25, 2012 7:47 pm

i has been accroding to your methds, and use example tools test odbc, resault is succesfull. but use DataStage Designer to define table use odbc methds, resault is faile.

qt_ky · Post by **qt_ky** » Mon Mar 26, 2012 8:01 am

Then you need to contact DataStage Support to find a solution.

kandyshandy · Post by **kandyshandy** » Wed Mar 28, 2012 2:39 am

mike369 wrote:but use DataStage Designer to define table use odbc methds, resault is faile.

Did you add the entry in uvodbc.config file?

qt_ky · Post by **qt_ky** » Wed Mar 28, 2012 5:11 pm

mike369 wrote:resault is faile

If you want someone aside from Support to help, then try providing the steps you tried along with the error message you got back. "Result is fail" is not a valid error message.

mike369 · Post by **mike369** » Wed Mar 28, 2012 7:52 pm

i has been config .odbc.ini , uvodbc.config , dsenv , .profile;
but use dssh->LOGTOT->DS_CONNECT connect greenplum is successful,
but use datastage-designer tool and choose odbc stage faile to greenplum.

error message:DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error:
SQLSTATE=24000,CODE=0,[DataStage][SQL Client]Invalid cursor state

qt_ky · Post by **qt_ky** » Wed Mar 28, 2012 7:55 pm

Is that error coming when you run a job or when you attempt to import ODBC table definitions?

Have you tried both ways and get the same error?

If you have not tried running a job, you could manually define a column from a known table without importing all metadata first, just as a test.

Perhaps there are some database grants that must be done before it will work via DataStage.

mike369 · Post by **mike369** » Wed Mar 28, 2012 8:07 pm

this error message coming when i attempt to import ODBC table definitions.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2012 9:17 pm

I wonder whether the Greenplum ODBC driver is compatible with the Data Direct ODBC driver manager?