Issues in extracting oracle table where security is built around it using sap DS

[kpandi215]

We are working on a project migrating oracle ERP data to SAP HANA Using SAP data services. Our Current SAP HANA Version is HANA 2.0 SPS 05.   SAP Data Services  4.3 SPS 02

There are certain tables in Oracle where security is build around it.

We have a run a procedure before viewing the data in Oracle .  MO_GLOBAL.SET_POLICY_CONTEXT ('S','ORG_ID')  and run the select query to read the data.

These should happen in the same session, but when trying to do this in SAP Data services, the session changes.  

Please provide your suggestions on extracting data from security built tables.

Regards,

Karthik Rajan P

[michael_eaton3]

In your dataflow, use the Pre-load Command feature in the source Oracle table to execute your procedure.