Oracle and MDM integration

[Former Member]

Hi All,

Please send me a scenario invlolving the integration of Oracle 11.0 and MDM with screen shots.

I also have a question.

Can v use stored procedures to retrieve the data from database to XI ?

I read in some blog that it is recommended by SAP not to use stored procedures.

If so how do we retrieve the data when normal queries are not satisfying the requirement.

Any more information regarding this scenario is appreciated.

Thanks in Adavnce

[Former Member]

Hello Rambabu,

Just do the following steps:-

1.Configure the JDBC Adapter for retrieving the data From Oracle database.

2.Use the Pre -delivered Content provided by SAP (SAP MDM 5.5)

3.Do the corresponding Mappings in SAP XI

4.Configure the Receiver File Adapter to place the Data into the <i>Ready</i> Folder of MDM Port.

Yes, it is advised not to use stored Procedure for JDBC adapter especially on Sender Side.

Regards,

Ashwin M

<i>Do not forget to mark helpful answer</i>

[prabhu_s2]

SP with cursors are not supported but only resultsets. For MDM there are pre-defined contents available. So u may import it to ur IR and reuse it in ur SCV.