MySQL
HomeContact Support
  • MySQL
  • LIstener
    • Example
    • Configuration
  • Context Provider
    • Example
    • Configuration
  • Action Agent
    • Example
    • Configuration
Powered by GitBook
On this page
  • General
  • Server Details
  • Database
  • Input Mapping
  • Endpoints
  1. Action Agent

Configuration

PreviousExample

Last updated 3 years ago

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.

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.

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.

Visit to understand more about Collections.

Refer to for step-by-step instructions.

Collections and Stream Hosts
Setup Input Mappings