MySQL Reader Activity

MySQL Reader Activity reads MySQL table as a view.

Parameters

Name

Description

Type

Default

Title

Title of the activity to display on the designer.

text

Host Name

Name or address of the server where MySQL database is hosted.

text

Port

Port number which MySQL database is configured with.

int

3306

Database Name

Name of the database.

text

User Name

Valid MySQL user name. Consider using vault feature with templating (e.g. ${vault:secret-myql-user})

text

Password

Password associated with above user. Consider using vault feature with templating (e.g. ${vault:secret-mysql-password})

text

Table Name

MySQL table name.

text

Batch Size

Read batch size. Default value is 0 (let driver estimate best number)

int

1000

As

Name of the DataRow view linked to the MySQL table

text

Options

Additional options.

key-value