Configuration
This section explains each of the properties in the configuration blade.

General

Property
Description
Collection
This associates this Agent to a specific Collection and defaults to that of the current Data Stream.
Visit Collections and Stream Hosts to understand more about Collections.

Server Details

Property
Description
Use Connection Variables
Tick to select saved variables; or enter the text manually for server connection properties.
Hostname
The MySQL server name / IP address.
e.g. localhost / 127.0.0.1
Username
The MySQL login username.
Password
The MySQL login password.

Database

Property
Description
Database
A list of databases for selection.
Create New Table
Tick to create a new table if the Table name does not exist in the selected database.
Table
A list of tables available for the selected Schema.
Applies when Create New Table property is unticked
Table Name
The name of the table to be created.
Applies when Create New Table property is ticked.
Before configuring the Action Agent, please ensure that its input endpoint is connected to a parent Agent which will be sending data to it.

Input Mapping

Each parent Agent attribute is mapped against a column in the selected database table.
Refer to Setup Input Mappings for step-by-step instructions.

Endpoints

Property
Description
Input
This endpoint is used to receive data from the parent Agent.
Output
An event per record created is made available to this endpoint. The output attributes are the same as the input events.