You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-20 20:59:26

siegfried
Member
61 posts

siegfried said:

SQLLDR Functionality Usage

Tags: [oracle]

Hi experts,
I want to use tOracleBulkexe component to load data from file into Oracle DB from file placed into Job server. So I have installed Oracle Client on Job server.
When I ran this job from Studio installed on Job server, it works fine but when I ran the same job from studio installed in another virtual machine, it does not work though I have selected target execution  as Job server IP. The error is "Cannot run program "sqlldr": java.io.IOException: error=2, No such file or directory" . I have setup Oracle_Home and Path environment variable in Job server machine.
When I run from studio installed on Virtual machine, it is creating *.ctl file. That means studio from VM able to access file available on Job server.
My question is do we need to  install Oracle client on each VM, which I do not think is the right option. Please provide your views to resolve this issue.

 

Offline

#2 2017-03-21 08:37:48

siegfried
Member
61 posts

siegfried said:

Re: SQLLDR Functionality Usage

Please let me know experts views. Really Urgent.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy