File-Based Integration

This section provides an overview of the implemented File-Based Integration approach with OCS.io, providing a versatile method for data exchange involving various systems. The integration via files supports interactions with external systems such Customer Relationship Management (CRM), Ordering system, Financial system, Mediation/ETL system and other relevant sources, facilitating efficient customer management, order processing, and broader data synchronization.

Overview

File-based integration involves the exchange of data between OCS.io and diverse systems through files. These files, structured in formats like CSV, XML, or JSON, offer flexibility in representing data. This method ensures a streamlined synchronization process for crucial information related to customer interactions, orders, billing, financial transactions, and events for rating and charging.

Use-Cases

File-based integration caters to a range of use-cases, highlighting OCS.io’s adaptability to diverse business scenarios:

1. Customer Information Synchronization: Synchronize customer information seamlessly between various systems and OCS.io. This ensures consistency across platforms concerning customer profiles, preferences, and contact details.

2. Order Data Exchange: Facilitate the transfer of order-related data, including product details, quantities, and transaction information, between OCS.io and relevant systems. This integration ensures accurate order processing and maintains coherence across different platforms.

3. Billing and Invoicing Data: Exchange billing and invoicing data between OCS.io and other systems, facilitating the harmonious maintenance of financial records. This includes details of charges, discounts, fees, and other financial transactions associated with customer orders.

4. Financial System Related Data: Integrate financial system-related data, including incoming and outgoing payments, credit/debit card transactions, and other monetary transactions. This ensures accurate recording and reconciliation of financial activities across systems.

5. Events for Rating and Charging: Manage events for rating and charging, such as MOC (Mobile Originated Call), MTC (Mobile Terminated Call), SMS-MO/MT (Short Message Service - Mobile Originated/Mobile Terminated), and any other relevant events. This integration ensures that OCS.io accurately rates and charges for different types of communication and services.

IN Direction - Ingesting Data into OCS.io

File Formats

OCS.io supports various file formats for data ingestion from multiple sources. Ensure that your files adhere to the specified format guidelines for a seamless integration process.

Process Overview

  • File Reception: OCS.io regularly checks for incoming files from various systems in predefined locations.

  • Data Parsing: The received files are parsed to extract relevant information, adhering to the defined structure.

  • Validation: Data undergoes validation checks to ensure accuracy and adherence to OCS.io standards.

  • Data Integration: Validated data is integrated into OCS.io, updating customer records, orders, financial transactions, and other relevant modules.

OUT Direction - Extracting Data from OCS.io

File Generation

Configure OCS.io to generate files in specified formats for outbound data transfer to various systems.

Process Overview

  • Data Extraction: OCS.io extracts relevant data from its database based on scheduled intervals or triggered events.

  • Data Formatting: Extracted data is formatted according to predefined structures for compatibility with various systems.

  • File Creation: Formatted data is compiled into files ready for transmission.

  • File Transmission: Files are transmitted to designated locations accessible by the relevant systems.