I can not read my geometry field on an Oracle database,
can you please help me please
Tag as "solved" for others! Kudos to thanks!
You need to convert your Geometry column to verticles before reading it in Talend.
Trt this in tOracleInput
"select ts.x lon ,ts.y lat from yourtable ,table(sdo_util.getvertices(yourGeoColumn)) ts "
Read these column as double.
As you dealing with Geometry Data , below would helpful
Hope this will help.
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