Write tOracleInput into Shapefile

One Star

Write tOracleInput into Shapefile

I've tried to read a OracleDb-Table with an sdo_geometry using the tOracleInput. When I tried to write the db table as an shapefile with sShapefileOutput (tOracleInput ----> sShapefileOutput) I get the following error message:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Type mismatch: cannot convert from Object to Geometry
at etl_test.db2db_spatial_0_1.db2db_spatial.tOracleInput_1Process(db2db_spatial.java:901)
at etl_test.db2db_spatial_0_1.db2db_spatial.runJobInTOS(db2db_spatial.java:1296)
at etl_test.db2db_spatial_0_1.db2db_spatial.main(db2db_spatial.java:1161)
In the tOracleInput I have to select Object as Type (geoemtry don't work) and as DB Type I select MDSYS.SDO_GEOMETRY
In the sshapefileOutput if selected geometry as type.
Shouldn't it possible to read an sdo_geometry from an oracle db into a geometry datatype in talend?

Re: Write tOracleInput into Shapefile

Hi,
How to read geo-spatial data in oracle component and what data type needs to be given for such data ?
Thanks,
Ananth

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download