After a long gap I make a comeback into pure play technobabble. But I promise I will try to keep it as simple as possible.
Social CRM from an IT perspective needs to deal with lots of data (petabytes) because it has to deal with data coming in from social media, online community platforms, various new enterprise systems (especially given the rise of enterprise 2.0, social collaboration, activity streams and what not where employees are creating a lot of data too). And not to forget traditional data. As my friend Esteban Kolsky likes to remind me everytime, Sears had a terabyte of customer data a decade back and apparently did not know what to do with it.
- Data in social media can be collected in various ways – RSS feeds, APIs (Twitter & Facebook firehoses) or just plain scrapping them from the various sites by crawling & spidering. Radian6 and Attensity360 do a great job of data collection. Both tools provide realtime capabilities for response/action however very little is analysed at this stage in these tools. Thus a lot depends upon the ability of the end users of these tools when responding in realtime is concerned.
- Data preparation or ETL typically deals with bringing in the raw data and loading, cleaning and conforming it to selected data model; joining with other data sources and producing data sets ready for data users to consume. Data Preparation is not so realtime because of the huge amounts of data involved, but in-memory analytics seems to be getting hotter by the day. Recently SAP integrated its HANA (High Performace Analytic Appliance) with IBM’s DB2 database increasing its alignment against rival Oracle’s Exadata platform.
- Data presentation is typically taken care of by data warehouses in IT architecture. Here the data is presented to the consuming applications like CRM/BPM systems or BI reports. BI reports can be realtime or not, depending upon the amount of analysis that takes place. CRM/BPM systems route the massaged data into the various business processes and is acted upon by pre-configured rules or by humans manning these systems (ACM, Social BPM can be leveraged here).