execute sqlldr from remote machine

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

clover_user3012
Posts: 2
Joined: Tue Jan 05, 2016 2:25 pm

execute sqlldr from remote machine

Postby clover_user3012 » Mon Feb 01, 2016 1:51 pm

I am executing job flow from the clover server and the execute graph is having oracle data writer component. There is no sqlldr utility installed in the clover server and I've pointed sqlldr utility from a remote server.
When I execute , job flow is throwing
Cannot run program "sftp://####:***@server ip address/opt/oracle/product/11.2.0.3/client/bin/sqlldr": error=2, No such file or directory

In the same job flow I can copy file from this remote server successfully.
Is it not possible to execute sqlldr from remote server?
Is there any class path variable to be set?
Is it mandatory to install sqlldr in clover server?

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: execute sqlldr from remote machine

Postby slechtaj » Thu Feb 04, 2016 12:05 am

Hi,

In case you want to use OracleDataWriter, the Sqlldr utility has to be installed locally on the same machine. You cannot use sftp in this case. For more information on OracleDataWriter please refer to our documentation. In case you cannot access the Sqlldr utility locally, you can still use DBOutputTable, which doesn't use native client, instead of OracleDataWriter.
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support