User Guide › Design › Data Acquisition › Adapters › Adding Adapters › Add an SQL Adapter › Mapping

Mapping

The Mapping step enables you to:

• Create or modify inputs, which specify the structure of data retrieved from data source (i.e. how a data row is to be cut into fields and what are the field types and formats). Initial data filtering and data manipulations may be performed by using the validation and compound fields respectively. This is performed by using the Input toolbar.
• Create or modify outputs, which specify how to translate the parsed and manipulated data source record extracted in the input to the CA Business Service Insight event. This is performed by using the Output toolbar.
• Delete and view the relation types between the inputs and outputs. This is performed by using the Relations toolbar.
• Add more data source interfaces. This is performed by using the Data Source Interface toolbar.

In the Mapping step:

1. In the Output1 box, click the Select Event Type row to select an event type. The Select Event Type windows appears.
2. Select an event type and click Select.

   -OR-

3. In the Output1 box, click the Create New Event Type row to create an event type. The Add New Event Type windows appears.
4. Fill-in the fields and parameters to create a new event type. For more information, see Adding an Event Type.
5. Click on the cell in the Input table and drag an arrow to the cell in the Output table to connect them.
6. Perform any other tasks on the Input and Output tables as required using the toolbars. For more information, see Input Toolbar, Output Toolbar, Relations Toolbar and Data Source interface Toolbar.
7. Click Finish. the adapter is created.