Hello All,
We are integrating the S20 DB with third party application using ODI. S20 is restricted DB and don’t have access to connect and query just like other on prim DB. So, I think the only approach I see is through RESRfull
service. Create the RESTfull service in S20 DB and consume the service in ODI using RESTfull operation.
Issue I’m facing is:
For a simple select query written in Apex, I’m passing a bind variable in WHERE clause. But I’m not getting an output data by passing a value to the bind variable. Output format is in .TXT file.
If I hardcode the value in WHERE clause, I’m getting expected output result in TXT file.
DB is Cloud and ODI is also in Cloud.
Need a help in this.
Thanks
Praveen K