Uncategorized SAP Blogs Page 2. Heres an example of a simple HANA smart data streaming project that sends an email whenever a particular situation is detected. Raspberry Pi Python. In this case,  it is monitoring events from some machines and watching for power outages that are longer than 2. Specifically, it watches for a Power Out event that is not followed by a Power On event from the same machine within 2. When the situation is detected, the ALARMPOWER stream emits an event. The SMTP output adapter attached to the ALARMPOWER stream sends events from that stream as emails. Note that we join the event stream to a HANA table where we pull information about each machine. This uses the CCL REFERENCE element which is sort of a proxy for a HANA table within a CCL project. To optimize performance, the REFERENCE element is configured here to cache results from HANA. The data is pulled in from HANA when needed lookup by MACHINEID and cached, with cache refresh time specified. For details on configuring the SMTP output adapter, see the SDS Adapters reference guide. This blog gives the check pointssolution to establishtroubleshoot the connectivity between onpremise ERPCRM system, SAP C4C ondemand CRM version to SAPs new. Build your customer base and lifetime loyalty with integrated marketing capabilities in SAP CRM. Our onpremise CRM marketing tools make it easier to segment. Lior Arussy gives the top six reasons CRM programs fail in this expert tip. Find out how organizational change management can contribute to successful customer service strategy. Big data and data management white papers DBTA maintains this library of recent whitepapers on big data, business intelligence, and a wideranging number of other. How To Create Loyalty Programs In Sap Crm Tutorial' title='How To Create Loyalty Programs In Sap Crm Tutorial' />CREATEINPUTSTREAM MACHINEDATA SCHEMA       MACHINEID string ,      EVENTTIME msdate ,      EVENTNAME string ,      EVENTDESCRIPTION string ,      EVENTVALUE string references a HANA table caches results to improve performance. CREATEREFERENCE MACHINEREFreference. SCHEMA       MACHINEID string ,      MACHINETYPE string ,      MAXTEMP decimal4,2 ,      MINTEMP decimal4,2 ,      IMPORTANCE string ,      ADDRESS string ,      SUBJECT string       PRIMARYKEY MACHINEID       PROPERTIES service HANAPM ,      source MACHINEREF ,      source. Schema MYSTREAMINGUSER ,      cache. Policy ONACCESS ,      max. Cache. Size. MB 5 ,      max. Cache. Age 1. 2 HOURS joins the event stream to a HANA table. CREATEOUTPUTSTREAM EVENTS ASSELECT    MACHINEDATA. MACHINEID MACHINEID ,      MACHINEDATA. EVENTTIME EVENTTIME ,      MACHINEDATA. EVENTNAME EVENTNAME ,      MACHINEDATA. EVENTDESCRIPTION EVENTDESCRIPTION ,      MACHINEDATA. Garmin Nuvi Safety Cameras Ireland on this page. EVENTVALUE EVENTVALUE ,      MACHINEREFreference. MACHINETYPE MACHINETYPE ,      MACHINEREFreference. MAXTEMP MAXTEMP ,      MACHINEREFreference. MINTEMP MINTEMP ,      MACHINEREFreference. IMPORTANCE IMPORTANCE ,      MACHINEREFreference. ADDRESS ADDRESS ,      MACHINEREFreference. SUBJECT SUBJECT FROM MACHINEDATA INNERJOIN MACHINEREFreference. ON MACHINEDATA. MACHINEID MACHINEREFreference. MACHINEID atch for a power out event thats not followed by a power on event for same machine within 2. CREATEOUTPUTSTREAM ALARMPOWER ASSELECT    A. Download Civilization 4 Full Rip. MACHINEID MACHINEID ,      A. EVENTTIME EVENTTIME ,            POWER ALARMTYPE ,            POWER Out for more than 2. ALARMDESC ,            A. IMPORTANCE IMPORTANCE ,            A. ADDRESS ADDRESS ,            A. SUBJECT SUBJECT FROM EVENTS A, EVENTS B MATCHING 2. SEC A, B ON A. MACHINEID B. MACHINEID AND A. EVENTVALUE Power offAND B. EVENTVALUE Power on receives events from ALARMPOWER stream and sends them as email body contains all fields but this is configurableATTACHOUTPUTADAPTER SMTPOutput. TYPE smtpout TO ALARMPOWERPROPERTIES smtp. Host xxx, address. Column ADDRESS, subject. Column SUBJECT, importance. Column IMPORTANCE, from.