Hi all,
i have a question, can we use Greenplum Database on Datastage 7.5.2?
And can you tell me how? is it using the ODBC?
Thanks,
Ratna
Greenplum
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Probably. You would need to obtain an ODBC driver (presumably from GreenPlum themselves) that is capable of managing their parallel access functionality. You could also write text files, and have their parallel bulk loader do the heavy lifting. And you could, of course, write your own custom stage (if you can get access to documentation about any client GreenPlum or PostGres API).
A recent press release indicates that GreenPlum has "certified interoperability with ... IBM DataStage", so it may be well worth it to contact them directly to see precisely what this means. And then you can post the answer here!
A recent press release indicates that GreenPlum has "certified interoperability with ... IBM DataStage", so it may be well worth it to contact them directly to see precisely what this means. And then you can post the answer here!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Yes , you can use it in DS 7.5.2
We have implemented in 7.1 server job itself. But Insert/update is slow when using ODBC.
Best Way for using GreenPlum with DataStage is use "gpfdist" fast greenplum loader using unix. Very soon they are coming with native connectivity between GreenPlum and DataStage . GP is working on it.
When u have tones of data to be loaded and quried, use GP and DS for best results.![Wink :wink:](./images/smilies/icon_wink.gif)
We have implemented in 7.1 server job itself. But Insert/update is slow when using ODBC.
Best Way for using GreenPlum with DataStage is use "gpfdist" fast greenplum loader using unix. Very soon they are coming with native connectivity between GreenPlum and DataStage . GP is working on it.
When u have tones of data to be loaded and quried, use GP and DS for best results.
![Wink :wink:](./images/smilies/icon_wink.gif)
Thanks, BK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We don't actually know the volumes of data that U is processing. We haven't heard from U for some while and even then no details were vouchsafed as to data volumes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: