I am having issues with extracting data from generic database in TOS 6.1. We have a source system which has Denodo Views, the database is Generic and type is Postgres. I was able to establish DB connection under metadata using JDBC URL. I am also able to retrieve schema under the metadata. But in tJDBCInput when i click guess schema, an error message pops out saying "choose correct mapping file. Note: This is normal with JDBC". So i clicked to choose and choose mapping_Postgres.xml file from the list, but i keep an getting error saying "Unsupported Resultset Type".
Any idea why i am getting this error.
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