System-Integration-and-Architecture.pptx

SYSTEM INTEGRATION AND ARCHITECTURE Franklin M. Miranda Jr.   System integration aims to synchronize important data, streamline processes, and enhance efficiency in your business. Creating a cohesive technological infrastructure empowers business...

SYSTEM INTEGRATION AND ARCHITECTURE Franklin M. Miranda Jr.   System integration aims to synchronize important data, streamline processes, and enhance efficiency in your business. Creating a cohesive technological infrastructure empowers businesses to automate tasks and eliminate the need for manual data transfers WHAT IS THE PURPOSE OF SYSTEM INTEGRATION? WHAT IS SYSTEM INTEGRATION IN LAYMAN TERMS?  In layman's terms, system integration aims to connect various system components to create a functional, interwoven system that connects all applications on a single data integration platform. Using integration platforms for your company, a systems integrator lays the groundwork for future success and growth WHAT IS AN EXAMPLE OF INTEGRATION SYSTEM?  For example, integrating HR management systems, payroll processing systems, and benefits administration systems within the HR department. By connecting these departmental systems, vertical integration allows for smoother data flow and eliminates the need for manual data entry between them BUSINESS INTEGRATION TYPES OF BUSINESS INTEGRATION INCLUDE:  Horizontal integration: A company merges with other companies in the same industry to expand its operations and increase market share.  Vertical integration: A company buys another organization that operates at an earlier or later stage of production. There are three types of vertical integration: backward, forward, and balanced. For example, a car manufacturer might control companies that produce tires or engines.  DATA INTEGRATION  Data integration involves extracting, transforming, cleaning, and loading data. Data scientists have combined and rearranged these steps to create four data integration processes: batch, ETL, ELT, and real-time integration. SYSTEM INTEGRATION TYPES OF SYSTEM INTEGRATION INCLUDE:  Point-to-point integration A simple and efficient method for connecting two systems and establishing a direct communication link between them STAR INTEGRATION  Connects multiple apps and/or subsystems, which can be considered a collection of point-to- point integrations WEBHOOKS  Event-based integration that requires programming modules within each subsystem that are triggered by third-party services. TYPES OF SYSTEM INTEGRATION:  Data integration  Combines data from different sources into a single view for analysis, reporting, or warehousing. This can include data from databases, CRM, ERP, and social media. Data integration often involves processes like data extraction, transformation, and loading (ETL) PROCESS INTEGRATION  Aligns and coordinates business processes across different systems. This can include automating processes and synchronizing activities across platforms. The goal is to streamline workflows and operations, reduce redundancy, and improve efficiency. HORIZONTAL INTEGRATION  Also called "hub-and-spoke", this model uses a single platform to connect to all other platforms. The central platform, or hub, acts as a gateway to other applications.  For example, an organization might use a CRM like Salesforce as the foundation of their horizontal tech stack, and then connect inventory, logistics, and marketing systems. STAR INTEGRATION  Also known as point-to-point integration or spaghetti integration, this model connects each subsystem with other subsystems using point-to- point connections.  This allows for more functionality, but the number of integrations increases significantly as the number of integrated systems increases. WHAT ARE THE CHALLENGES IN INTEGRATION OF HETEROGENEOUS INTERNET OF THINGS?  Some of the identified challenges are “heterogeneity of devices,” “heterogeneity in formats of data,” “heterogeneity in communication,” and “interoperability issue due to heterogeneity.” The identified challenges have been analyzed from digital libraries and timeframe perspectives HERE ARE THREE CHALLENGES GENERALLY FACED BY ORGANIZATIONS WHEN INTEGRATING HETEROGENEOUS DATA SOURCES AS WELL AS WAYS TO RESOLVE THEM:  Data Extraction.  Data Integrity.  Scalability. DATA EXTRACTION  is the process of retrieving data from different sources for analysis or storage. EXTRACTING CUSTOMER INFORMATION  A company can use SQL or ETL tools to extract customer information from a relational database, such as purchase history, demographics, and interaction data. This data can be used to analyze customer behavior, preferences, and trends, which can help organizations improve customer satisfaction, tailor marketing strategies, and grow their business.  Data extraction tools like Import.io and Scraper API can be used to extract data from web pages. Import.io is a cloud- based tool that can scrape data from web pages without the need for coding. Scraper API can handle proxies, CAPTCHAs, and browsers, and allows users to scrape web pages with a simple API call EXTRACTING DATA FROM WEB PAGES   Data extraction tools like Hevo can capture and process data from audio files, in addition to web pages. Hevo can also connect various sources to build a data pipeline and support over 50 file formats EXTRACTING DATA FROM AUDIO FILES  Data extraction can automate the processing of emails and extract relevant attachments.  Data extraction can automatically collect data from sensors and upload it to an analytics platform. EXTRACTING ATTACHMENTS FROM EMAILS & EXTRACTING DATA FROM SENSORS THE END