I successfully established a connection via Talend Open Studio 7.0 to an AS400/DB2 database using JTOpen drivers which are recommended by IBM for such purposes. But when I try to retrieve schema information some table objects are not visible in Talend. I only can read tables with an AS400 attribut called "SQL Filetype: Table". Like you can see in screenshots below in german it's called "SQL Dateiart".
How can I read those objects where SQL Filetype is missing via TOS?
The AS400 version is V7R1.
Are you able to choose the schema when create a connection for AS400? Is there any more error message in studio log?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema