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.

Property	Description
Collection	This associates this Agent to a specific Collection and defaults to that of the current Data Stream.

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.

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.

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.

Last modified 1yr ago