SAP CPS database
Our SAP CPS is installed in an Oracle database. To query the data model with the job defintion type 'oraclejob' or 'sqlplus', do we need to have 'ProcessServerService.JDBC.limit' license key. Please advise on how to proceed.
We have M33.92 build on NW7.4
Thank you in advance.
Nanda Kumar replied
in that case, you will have to buy JDBC licenses and create a process server to connect to CPS' own database and use the oraclejob or sqlplus. Even in that case, i am not sure whether you will be able to query the data model. My assumption is it will only allow to query the actual tables directly.
i have seen the filters and reports supporting sql queries over the data model.
What is that you are trying to do?