how to get non sap system database search while in customer search

[former_member293607]

Hi,

I have a requirement in MDG customer , when i am searching for customer in UI, search database needs to include NON SAP system data also to search for customer(i mean in MDG system how to get non SAP system data for customer, if i enter any data in search customer UI, search should be non SAP system database also )

Regards,

Sri

[loga201]

Hi Sri,

Connection can be done using DBCO tcode and you can enhance handler methods of BP to attach DB search results with MDG search results.

If user wants to change customer , you have to enhance lot more but it is not feasible one.

For an example-http://www.saptechnical.com/Tutorials/Basis/Oracle/RetrieveData.htm

SAP provides fuzzy,free text searches and HANA provides more . Not sure you can able to tune to get all from your external DB. It is better to create an interface to pull all the records to MDG. If you want ,create custom account group to group them all for unique identification. Instead of making two DB to search and aggregate the results better to make one(MDG) to work to avoid delays. This is even better approach if your non DB is a production Database so you can avoid overloading it.

Coming to Trex- go through https://archive.sap.com/discussions/thread/42786. I am not very sure about this.

Thanks