Four Stars

How to set up complex Greenplum Query in Talend?

Hello there Talend Community, 

 

I am rather new to Talend and am not sure what the best practice is to design a Talend job that outputs an Excel file from a complex query. I'm hitting about 10 tables with sub queries and from 3 different schemas from a Greenplum DB but I haven't found a simple solution to do so (tmap, multiple tGreenplumInput)

 

Any guidance or suggestions would greatly help!

 

Best,

Alex

2 REPLIES
Moderator

Re: How to set up complex Greenplum Query in Talend?

Hello,

What does your complex Greenplum query look like? Could you please set an example for us?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: How to set up complex Greenplum or Postgresql query in Talend?

I actually was able to fix the query (removed dashes, notes and aliases with quotes) and am using a Postgresql Input component now but have a "java.lang.ClassNotFoundException: org.post.gresqlDriver" error. I believe I have the proper modules installed (see attached) so I'm not sure what the exact issue is.