topic Re: component to connect to oracle Spatial ? in Talend Studio

component to connect to oracle Spatial ?

Anonymous — Sat, 16 Nov 2024 12:17:48 GMT

I need to connect to Oracle spatial in order to convert data in a new projection ?
I have just instaled SDI 4.2 but can't find any component to get the field who contains geometry (mdsys)
Thanks for your help

Re: component to connect to oracle Spatial ?

Anonymous — Tue, 11 Sep 2012 15:53:44 GMT

Hello,
You should use the Oracle component. Note that you need some Oracle Libs on your system to get things working correctly.
Regards,
Y.

Re: component to connect to oracle Spatial ?

_AnonymousUser — Wed, 24 Apr 2013 15:31:48 GMT

I new to Import Shape file data in my spacial Oracle DataBase with TOS 5.2.2 and SDI 5.2.1.
My configuration seems to be ok (sdoutil.jar and sdoapi.jar in lib folder)
My job is simple :
tShapeFileInput --Main--> TMap --out--> tOracleOutput
In my tMap, I'm simply linking shape file geometry to Oracle table SDO_GEOMETRY column
But I've this issue (traduced from french):
readGeometry() method is undefined for ObjectInputStream type
writeGeometry() method is undefined for ObjectInputStream type
and
geometryColumnToExtends cannot be resolved
Have you an idea?
Thanks