Talend integration with Netezza

One Star

Talend integration with Netezza

Hello Everyone,
I am new to talend but find the DQ tool easy to use. I am eventuating Talend for Data Quality use.
We have Netezza setup and I am successfully able to connect to Netezza database but some how the connection is not showing all tables in schema or entire schema. When I am accessing Netezza DB using other DB tools I can see everything. Does any one encounter to similar kind of issue? Or do i need to do any configuration changes to see all data objects.
Moderator

Re: Talend integration with Netezza

Hi,
Can you expand the database connection under metadata? On which build version you got this issue?
Best regards
Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Talend integration with Netezza

Thanks for reply.
By build is 6.3.1.20161216_1026
I have both problems as you asked.
First I can expand database connection but I can't see all schema in the connection. (See Image 1) The image is showing one schema only but in reality there are 8.
 

Second I can not expand database connection and hence no schema ans no tables (See Image 2); but when I run overview view analysis the tables are picked during analysis.

Moderator

Re: Talend integration with Netezza

Hi,
Could you please click "Reload table list" to see if it works? Does this issue only repro on your Netezza DB?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Talend integration with Netezza

Hi ,
I did reload multiple times but the results are same. Even I dropped connection and re created it. Right now I am connection to only Netezza, don't have other connections, but with in Netezza for some databases are showing all data objects but few ones are not showing anything or not all.
Regards,
Rahul
Moderator

Re: Talend integration with Netezza

Hi,
but with in Netezza for some databases are showing all data objects but few ones are not showing anything or not all.

Is there any permission issue on your DB?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Talend integration with Netezza

Hi,
I think it should not be a permission issue reason
1. I can see all data objects when I use other data connection software  like Aginity, Aqua.
2. For one of database (STAGE) I can't drill drown to see tables and views but during Overview Analysis the tables are picked up and statistics are shown against the tables/views.
Regards,
Rahul
Moderator

Re: Talend integration with Netezza

Hi,
What's your Netezza Version? We are trying to make a testing on V 6.3.1 to see if this issue repro.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Talend integration with Netezza

Hi,
Netezza version is 7.2.1.3.
Regards,
Rahul
One Star

Re: Talend integration with Netezza

Hi,
i would like to inform you that the problem is solved. As you pointed out earlier "It was a permission issue". My account was having data access issue but some of the metadata access functionalities were not enable. 
The DBA compared my access rights with others and did changes, now I can access all tables/schema. Thanks for your support.
Regards,
Rahul