How to set up complex Greenplum Query in Talend?

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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. 

TalendError.JPG