CRM-BI Integration

Hi, I am trying to develop the ETL for CRM-BI process, I had two questions before I got started, 1) How does data from CRM get tranfered from CRM to BI. I know data from R/3 to BI gets transferred through IDOC's, does the same happen from CRM to BI t

Hi, I am trying to develop the ETL for CRM-BI process, I had two questions before I got started, 1) How does data from CRM get tranfered from CRM to BI. I know data from R/3 to BI gets transferred through IDOC's, does the same happen from CRM to BI too. 2) How do delta's work in CRM. For example in R/3 ( Logistics) we have Direct, Queued or V3 update, do we have the same options in CRM too? I specifically need to know how it works in opportunities, activities & account planning areas. Thanks Rashmi.

The replay answer

Advertisement

1) How does data from CRM get tranfered from CRM to BI. I know data from R/3 to BI gets transferred through IDOC's, does the same happen from CRM to BI too.
Data from SAP SRM gets transferred to SAP BW via the same meachnism as R3/ECC data does. This is the case for all SAP applications.
2) How do delta's work in CRM. For example in R/3 ( Logistics) we have Direct, Queued or V3 update, do we have the same options in CRM too? I specifically need to know how it works in opportunities, activities & account planning areas.
CRM deltas work more like the R3/ECC FI extractor deltas in that there are no setup tables and/or delta queue jobs required. It's pretty much "plug and play" (activate and start using) and has the capabilities of creating User Exits in CMOD on CRM, just like R3/ECC. This too is the case for most SAP applications (there are some idiosyncrasies in Solution Manager).

Dear Folks, We are in the process of doing the SAP CRM & BI Integration wrt Trade Promotion Mangement. For testing purposes, we tried to create a planning profile in BPS end i.e BW SEM system & trying to retrieve it from the CRM system using the b[More]

Hi Experts, Currently in ECC we did not activated Operating Concern. Our Organization don't required that. But when we are doing CO integration with CRM It is asking to assign controlling area to Operation Concern(COPA). Even though Operating concern[More]

Hi, we're running CRM groupware integration for replicating CRM contact persons to outlook private folder. This works fine in principle. However, I've got a question: When taking a look at an outlook contact one is able to maintain several phone numb[More]

Hi, I have a question regarding CRM WebUI integration with WD ABAP. My requirement is to trigger a particular CRM application (lets say, create quotation) from EP environment for a particular portal role, may be, from a WD application. I searched in[More]

hello all , we are in process of crm isu integration for regulated scenario . crm 2007 / ecc 6 isu currently bp and BA are getting replicated . we are in process of replicating technical master data . however i need to know as we are in regulated ma[More]

Hi all We have implemented the serverside groupware integration with CRM 2007 and Exchange. Usually the appointments in Outlook are created with category "CRM_ACT_001". Unfortunately some Mobile Phones (like the iPhone) are not able to set the c[More]

Hi I have a couple of requirements for CRM-COPA integration 1. The CRM system captures no of service calls attended by our franchises. This pertains to equipment maintenance. I want to flow this data to COPA i.e. the no of calls serviced by each fran[More]

Hi all, i am involved in a CRM upgrade project in order to repleace the client current release with CRM 7.0. currently, my client handles sales integration between ERP and CRM using middleware fucntion and in particular SCENARIO A that allows to crea[More]

When I add a new calendar item in iOS 7 calendar app, it allows me to select either my Exchange calendar or any of the iCloud calendars. However, some (or perhaps all) event invitations appear pre-destined for the iCloud calendars, and when I select[More]

Using an iPad1: What to do, if I want to show on a projector, how downloaded apps created by DPS works? :-) Nina StormI did make a search if it is possible. But I am in doubt if the iPad VGA connector cable will show DPS aps, or if it is only possibl[More]

As part of a school assignment, I we have output going to a textfield that is scrolled with JScrollPane. Part of it is for when it comes to 400 lines, and another line is added, that the first line of the output is erased, and the new one is added. A[More]

I have an ATE application that is used on several models of the same product. The models have optioning commands and status screen layouts that use different terms for the same function. For example: "LBO" on one model might be labeled "EQ&[More]

Hi , I have not used Object Groups and Object Libraries extensively....and am trying to understand them Having read the form builder help ,I am still not clear with the following. My questions are as follows 1)When should I be giving preference to Ob[More]

I have a 5G, 60gig, formerly Mac formatted, now PC formatted iPod. I keep my photos, music, contacts and calenders on the Mac. (I am full time Mac user). I only have USB 1.1 on my PB G4 so uploading video to the iPod is out of the question. This is w[More]

Hi How to create a icon on Hierarchical tree Regards ShahzaibThanks for your reply and i am sorry for not clear my developer version My developer version is 6I Database express addition Well i write the trigger when tree node activate :parameter.curr[More]

within the past few weeks, the manual on/off button does neither. i can program it to turn off and them back on at certain times. but if i need to use it before it is programmed to come on, the button won't work. i can take out the battery and whe[More]