Using Oracle Datawarehouse with PC 10.0

[Former Member]

Hi all,

We are developing a solution for a company focused on distribution. The data source of PC 10.0 will be a Oracle DW. What do you think about MQT Connector?

Is there another way to use Oracle as a datasource without data replication?

Thanks

[rajeshwari_akkamgari · Accepted solution]

Hi Gabriele,

To use external  database like oracle, MQT is the only way and you can download MQT from  "PC Multiapplication Query 10.0" from the service market place.

Continue following the steps as per the guide "PC10 External Partner Integration for Continuous Monitoring".

regards,

Rajeshwari

[Former Member · Accepted solution]

Thanks for your fast answer.

Do you know if the GRC License includes this component? Is it free or we need a separate license?

Thanks in advance

[rajeshwari_akkamgari · Accepted solution]

Hi Gabriele,

This is included and you can install the MQT from SMP (Software Downloads->SAP Solutions for Governance ,risk and compliance->SAP Process Control->SAP Process control 10.0->Adaptors->PC Multiapplicationquery 10.0).

Hope this helps.

Rajeshwari

[Former Member · Accepted solution]

Hi Rajeshwari,

the SMP retuns me this message when I try to donwload MQT:

---------------------------------------------

Error Message - No download
authorization

   What happened?

  You do not have permission to
access this Object.

What can you do?

• Please refer to the SAP
       Note 1037574
• Error code: SAPSMPDL1-20120413113009-0003
  
       Error details: 10021DD9-702/1A053/3162-63F0D6C5-3CB8B45-2992FF
• Service Name:
  SAPIDB
• Service Server:
  SAPSMPDL1
• Process-ID: 4960
• Thread-ID: 2308

Sorry for any inconvenience.

Your SAP Service Marketplace Team

--------------------------------------------------

It's a license problem?

[rajeshwari_akkamgari · Accepted solution]

Hi Gabriele,

Its may be because you do not have the authorization object SWDOWNLOAD assigned to your S user.

You can refer to SAP note 1037574 if you need to get this authorization.

regards,

Rajeshwari