Hi, I'm using Open Studio Data integration 6.3 and have added a Oracle db connection. It checks fine. But when I want to use it in a job I get an error stating I need 2 additional jar files: sdoapi and sdoutil.jar.
I'v searched in the Oracle server, on the Oracle website and googled around. But I can't find the 2 files. Can someone tell me where to get them? Thank you.
It looks like sdoapi and sdoutil.jar are used for Geometry in oracle. Do you want to write geographical data to an SDO_GEOMETRY column in Oracle? What's JDK version you are using?
It is strange why TOS wants the jars because I want to extract plain data from a Oracle db and not geographical info. I'm using jdk1.8.0_112.
But I have found the jar on https://mvnrepository.com/artifact/oracle/sdoapi/11.2.0. Talend accepts the 2 jars and now I have a working connection.
We have made a testing on talend open studio V 6.3 and it doesn't want the jars. What's oracle version you are trying to connect?
Hi, I had it with 2 db connections. One Oracle 10 and one Oracle 11. As soon as I dragged the db from the metadata to the job field it gave the error.
Does this issue also repro on V 6.5.1?
Hi, I've installed V6.3 and V6.5.1 locally for this test.
Version 6.5.1 works nicely. The local 6.3 also gives the error. I've added a printscreen. But most important is that it functions. I can't upgrade to 6.5 just yet because if I create jobs in 6.5 there's a risk it won't run on 6.3 environments. I share my jobs with other organisations in the same field (local government) who also run 6.3. I'll ask if they also have the jar problem.
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
Read about some useful Context Variable ideas