04-04-2018 11:44 AM
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.
04-06-2018 05:44 AM
I am executing using Cloud snaplex, Our Oracle DB is also on cloud.
04-06-2018 08:51 AM
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.
05-07-2018 06:55 PM
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
05-28-2018 08:31 PM
Yes, the SQLLDR needs to be installed in the Groundplex environment, and configured in the Snap with the path.
04-11-2018 03:39 AM
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?