Using the Import Export Connector (IEC)

Objectives

After completing this lesson, you will be able to:
  • Describe the Import Export Connector (IEC).
  • Outline the steps involved in using an Import Export Connector.

The Import Export Connector (IEC)

Business Example

As a price model developer, you want to test your new model with consumption data. To do this, you create CSV files containing test data that simulates CPU, RAM, and Bandwidth usage for your rating and charging scenarios. These CSV files are uploaded as chargeable items into SAP Convergent Charging using the Import Export Connector. The SAP Convergent Charging Import/Export Connector (IEC) is an application that facilitates the import and export of low volume data between different systems, applications, sources, and destinations. The IEC application is responsible for scheduled data transfers between the external systems and the SAP Convergent Charging system.

Note

It should be noted that an IEC does not replace a mediation system, but rather provides an interface between the SAP Convergent Charging system and an information or mediation system.

IEC Overview

Info graphic showing the four elements of IEC: CAT Tool, CCIEC Server, Convergent Charging Core Server and SAP S/4HANA Convergent Invoicing.

IEC allows you to do the following:

  • Transfer data from external systems to SAP Convergent Charging.
  • Modify and consolidate transferred data regardless of the transfer method.
  • Collect data from files or external databases.
  • Extract lines from files, line by line, or extract all the lines which are inserted between two specific lines.
  • Manipulate complex character strings, such as CSV parsing.
  • Create chargeable items from collected data.
  • Send XML API requests to SAP Convergent Charging Core Server.
  • Execute SQL requests.
  • Perform XML and XSL operations.

Steps Involved in Using an Import Export Connector

Scenario Description

A scenario consists of a series of interconnected actions to be carried out, and can be scheduled based on the parameters specified in the scenario's root element. The execution of a scenario can be performed using SAP Convergent Charging IEC.

Graphic explaining the scenario. Starting with a file, which is imported, and the modified. At the end data is exported and sent to SAP Convergent Charging, Core Server.

A scenario is a set of linked actions to be executed. This entity may be scheduled according to the parameters defined in the scenario root element.

A scenario can be executed by SAP Convergent Charging Import/Export Connector.

To define the scenario, the following four steps need to be considered in a business context:

  • Data Collection: Identifying the process for importing data in the scenario. For example, collecting Consumption Data Records from files line by line.
  • Data Modification: Determining how to make the collected data exportable, such as generating one chargeable item from each collected line and parsing them through a CSV parser.
  • Data Export: Outlining the process for exporting data from the scenario, such as sending chargeable items to be rated to SAP Convergent Charging Core Server using Message API.
  • Execution Period: Establishing the frequency of executing the scenario, such as every hour.

Analyze Scenarios for Import Export Connector (IEC)

Business Scenario

As a developer of price models, you want to test your new price model with consumption data.

You want to create CSV files that include CPU, RAM, and Bandwidth usage for your rating and charging scenarios.

The Import Export Connector is used to upload CSV files as chargeable items to Convergent Charging. Analyze the implemented Import Scenarios to understand how the Import Export Connector converts usage data provided in CSV files into a format that SAP Convergent Charging can work with.

Task 1: Start the CAT Tool

Steps

  1. Start the CAT Tool and open the existing Import Scenario located at N:\My Documents\CC_Tools_2022\iec\iec-repository\Cloud Selection Service Scenario -- Usage Event HRB4 - CIT.xml.

    1. Choose Start.

      System screenshot showing the Start button.
    2. Find the start menu entry "cat_tool.bat – 2022" and choose it to start the CAT Tool.

      System screenshot showing cat tool.bat -2022
    3. After a few seconds, the CAT Tool opens welcoming you with the main window:

      System screenshot of the SAP Convergent Charging 2022 - CAT Tool
  2. Open the existing Import Scenario located at N:\My Documents\CC_Tools_2022\iec\iec-repository\Cloud Selection Service Scenario -- Usage Event HRB4 - CIT.xml. 

    1. In the CAT Tool, choose FileOpen.

      System screenshot showing the Open option on the File dropdown menu.

      A file selection dialog window is shown.

    2. In the file selector dialog, enter "N:\My Documents\CC_Tools_2022\iec\iec-repository\Cloud Selection Service Scenario -- Usage Event HRB4 - CIT.xml" in the File name field and choose Open.

      System screenshot showing the File dialog window.
    3. The scenario is shown in the CAT Tool window.

      System screenshot of the CAT Tool window.

Task 2: Analyze the Import Scenario and Answer the Following Questions

Two CAT Scenarios are delivered with Convergent Charging Client Tools. One scenario is for the upload of chargeable items to CIT Class HRB4, and the other scenario is for the upload to CIT Class HRB5.

Analyze the CAT Scenario "Cloud Selection Service Scenario – Usage Event HRB4 CIT" according to the following aspects:

Steps

  1. Which Default Properties and which user properties are in use?

  2. Check the sequence of the fields. In which order are the fields Service Identifier, User Identifier, Consumption Date, ZZ_CPU_HOUR, ZZ_CPU_NUMBER, ZZ_RAM_QTY expected in CSV File by CSV Parser? 

  3. What URL does the scenario use to send the chargeable items to SAP Convergent Charging? 

    1. Analyze the following aspects:

      System screenshot of the CAT Tool window.

      1. Analyse Properties. Which Default Properties and which user properties are in use?

      Default Properties are Service Identifier, User Identifier and Consumption Date.

      User Properties are ZZ_CPU_HOUR, ZZ_CPU_NUMBER and ZZ_RAM_QTY.

      2. Analyse CSV Parser:

      Check the sequence of fields. In which order are the fields Service Identifier, User Identifier, Consumption Date, ZZ_CPU_HOUR, ZZ_CPU_NUMBER, ZZ_RAM_QTY expected in CSV File by CSV Parser?

      Choose CSV Parser. The field sequence is indicated by Value in CSV Parser in Mapping Rules.

      System screenshot of the CAT Tool window.

      3. Analyse the URL address where the chargeable items are sent to.

      Choose Create CIT only. The Server URL is tcp://wdflbmt7132:2000.

      System screenshot of the CAT Tool window.

Log in to track your progress & complete quizzes