Netezza Connection

One Star

Netezza Connection

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
Four Stars

Re: Netezza Connection

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
One Star

Re: Netezza Connection

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

Re: Netezza Connection

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

Re: Netezza Connection

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
One Star

Re: Netezza Connection

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?
Four Stars

Re: Netezza Connection

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.
One Star

Re: Netezza Connection

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.
Four Stars

Re: Netezza Connection

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

Re: Netezza Connection

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

Re: Netezza Connection

Here is the output component.
Four Stars

Re: Netezza Connection

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?
One Star

Re: Netezza Connection

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

Re: Netezza Connection

Is Talend BD compatible with Java JRE 1.8?
Four Stars

Re: Netezza Connection

See if instructions in following post helps you.
http://www.talendforge.org/forum/viewtopic.php?id=35832
Vaibhav
One Star

Re: Netezza Connection

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
Four Stars

Re: Netezza Connection

Thanks for BIG conclusion Frank.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now