Page 1 of 1

execute sqlldr from remote machine

Posted: Mon Feb 01, 2016 1:51 pm
by clover_user3012
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?

Re: execute sqlldr from remote machine

Posted: Thu Feb 04, 2016 12:05 am
by slechtaj
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.