Netezza Connection

[Anonymous]

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

[Anonymous]

Hi Frank,
Can you query the database using the user through other means? Whether the user has select permissions?
http://dba-valley.blogspot.in/2013/03/basic-user-administration-commands-in.html
Vaibhav

[Anonymous]

Yes I can query the database just fine with either NZSQL on the host or using the Aginity client.

[Anonymous]

nzjdbc is also installed, if that is a question too. Same error happens with jre 1.6 and jre 1.8.

[Anonymous]

JDK/JRE may not be an issue, reason is you are able to connect...
You are using BD so - If you are using Talend Open Studio for Big Data, only the Built-in mode is available.
Have you referred to - https://help.talend.com/search/all?query=tELTNetezzaInput&content-lang=en

[Anonymous]

I don't understand... are you saying that the tNetezzaInput component does NOT work with the BD version of Talend Open Studio and that I have to use the tELTNetezzaInput component instead?

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

Can you put the screenshot with metadata for your input and output component along with the sample data in your table?

[Anonymous]

Here is a snapshot of my job.
Sample data is just a single row with a 1 in it.