topic Re: Netezza Connection in Talend Studio

Netezza Connection

Anonymous — Sat, 16 Nov 2024 11:40:08 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 08:17:53 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 08:19:05 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 08:23:40 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 08:28:50 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 08:32:54 GMT

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?

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 08:57:56 GMT

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.

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 09:02:00 GMT

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.

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 09:17:23 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 09:26:41 GMT

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

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 09:29:20 GMT

Here is the output component.

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 09:55:05 GMT

Port number is integer column and not a string... remove double quotes
Is there any specific reason for having double quotes around col1??
Can you bring a query on single line and test again?

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 15:14:51 GMT

Removed double quotes from port number.
Removed double quotes from COL1 and put all all same line.
I still get the same error message.

Re: Netezza Connection

Anonymous — Tue, 29 Apr 2014 15:58:41 GMT

Is Talend BD compatible with Java JRE 1.8?

Re: Netezza Connection

Anonymous — Wed, 30 Apr 2014 05:23:38 GMT

See if instructions in following post helps you.
https://community.talend.com/t5/Installing-and-Upgrading/resolved-W8-installation-demo-priorTest-failure/td-p/98794
Vaibhav

Re: Netezza Connection

Anonymous — Wed, 30 Apr 2014 22:09:39 GMT

The simple answer for anyone else following...
Talend BD is not compatible with Java 1.8. Uninstall all other versions of Java and Re-install 1.7 and this now works fine.
Frank

Re: Netezza Connection

Anonymous — Thu, 01 May 2014 05:57:12 GMT

Thanks for BIG conclusion Frank.