Steps involved in MDM - BI integration
Could you please let me know the Steps involved in MDM - BI integration.
Thanks in advance,
Nitin Jain replied
BI is a tool basically required for reporting purposes and the advantage of integarting MDM with Bi is to get accurate and correct reports based on correct Master Data. This helps companies to take a correct abd better decision for their growth.
Now, coming to the Bi-MDM integartion,
It can be done in 2 ways,
1) File exchange mechanism - MDM can accept files in the format of .CSV ( also other formats)
ANd BI also understands .CSV format. Hence MDM and BI can transfer data in the .CSV format.
This method was used with previous versions of MDM and BI.
2) Using ABAP API's :Now, with MDM SP05 and above we use another mehtod of using ABAP API's where in you can connect to any repository, infact create it from BI. Hence, we only perform the Data Manager wok using MDM and rest can be done using BI iteslf with the help of ABAP API's.
Here are some link to get the complete process:
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b01e4269-f744-2b10-929b-fa7b49aac540 - MDM-Bi7.0 using ABAP APi's - Part 1
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d06a92de-614e-2b10-4989-d913c2154a64 - MDM-Bi7.0 using ABAP APi's - Part 2
Connectivity - BI-MDM Integration - Wiki - Wiki
You will get plenty of information with the help of these links.
Hope it helps.
Thanks and Regards