Oracle Bulk Load - SQLLDR Path Issue

[Hemanth]

Hi,

I am trying to use the Oracle Bulk Load option for inserting the data, currently getting the issue for SQLLDR path. I have provided the path of SQLLDR like this and SQLLDR is available in this path on Oracle Database Server. Tried with both
u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr.exe
u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr

Error Message
Failure: Specified SQLLDR path is not an executable file, Reason: Snap failed unexpectedly and did not provide any reason

Please could suggest me on the path of SQLLDR.

[Hemanth]

I am executing using Cloud snaplex, Our Oracle DB is also on cloud.

[cstewart]

As Oracle bulk load uses the native utility, that is not available in Cloudplex environments. If you want to use endpoints requiring local utilities or libraries then you should use a Groundplex in your own domain, where you can provision those proprietary native resources. Other Snaps which use native libraries include SAP (ECC - BAPI and IDOCS), Tableau TDE formatter and SQL Server Bulk load.

[Hemanth]

I tried using the groundplex still the Oracle Bulk load snap is not working. how to configure the SQLLDR ? we are providing the SQLLDR utility path where the DB is located, how the snaplogic can access this SQLLDR? we are providing the DB details not the OS details. Do we need to have the SQLLDR in the snaplogic environment?

Regards,
Hemanth

[cstewart]

Yes, the SQLLDR needs to be installed in the Groundplex environment, and configured in the Snap with the path.

[Surendar]

cstewart:

Are you running on a Groundplex node that you have access to?

Even I too facing the same issue. unable to access the SQLLDR in Groudplex as well. Kindly suggest me what is the solution for this?