Oracle Bulk Load - SQLLDR Path Issue
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 ...
Forum Discussion
Tried with opening / as /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr this also did not work.
Are you running on a Groundplex node that you have access to? (SQLLDR is not available in Cloudplex environments) .
I am executing using Cloud snaplex, Our Oracle DB is also on cloud.
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.
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
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?
I was using cloudplex, it did not work. Then tried using Groundplex, still did not work.
