I am trying to connect to a Netezza DB and just do a simple query. I am getting a successful connection in my tNetezzaInput component, because when I click the Table Name selector, I can choose my table from the database. When I click "Guess Schema" it spins for a second and then I get an error "Failed to Generate Code". If I put in my own query: "SELECT COL1 FROM RS_TEST2" and try and run the job, I get an error: Execution failed : Failed to generate code.
------------------ Any help would be much appreciated! Frank
Not actually... I gave some sample which was explaining that we need to create matadata for your input... You can also use ELT component as well. https://help.talend.com/search/all?query=tNetezzaInput&content-lang=en There also they say that - tNetezzaInput executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link.
There is only a single column in my table and it cannot generate the code for that schema, and I don't know what to do in order to make that work. I have tried manually creating a schema (using the Edit Schema button) that matches it, but I get the same error. So either way, Talend is not able to use/create the right metadata to use downstream.