Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a job in Talend
Fetching data from SQL server and writing it to Greenplum
flow is MSSQLSERVER---- -> HADOOP ----->GREENPLUMConnection---> Greenplum-------> Greenplumcommit
when I run the job I get error in tGreenplumConnection component
PI2_FGBulkProduction_stg0.java:2661)
Exception in component tGreenplumConnection_1
java.sql.SQLException: No suitable driver found for jdbcostgresql://null:null/null
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bigdata.vwkpi2_fgbulkproduction_stg0_1_1.vwKPI2_FGBulkProduction_stg0.tGreenplumConnection_1Process(vwKPI2_FGBulkProduction_stg0.java:1418)
I have checked I am able to see table name in Greenplum component - means connection is successful with Greenplum
How should I go ahead to resolve this issue?
Hello
How do you see the table? Retrieve the schema under Metadata? It seems the driver file is missing or not installed correctly, open the Module view and see if the required driver file is installed already?
Regards
Shong