A model for integrating social network's data and enterprise information systems

Abstract

Nowadays c become part of our life and using them for different purposes such as communities and business finds value. Using power of social network websites in business and enterprise become a dramatic value and made integration of existing Enterprise Information System (EIS) with social networks to use its data value a challenge and new requirement from enterprises. This study investigate on data and it‘s format of social networks beside type and structure of EIS in different level and integration methods to purpose a proper model for integrating them. Next, after comparing different integration strategy and integration technologies besides conducting questionnaire from few companies, Extract, Transform and Load (ETL) technology has been chosen as the main concept to propose Social Network Extract, Transform and Load (SNETL) model. This model can use to enhance an ETL framework for integrating existing EIS functionality and Social Networks in data repository level based on Enterprise requirement by integration project‘s team. Finally, this study used SNETL Model to enhance Talend Open Studio (TOS) as an ETL framework with developing an example Input and Output module to integrate Facebook news and the number of its comments and likes as a social network data Example and news submission in SugarCRM as an EIS example.