Modeling Guide for SAP Data Hub

MySQL Table Consumer

MySQL Table Consumer (com.sap.dh.ds.mysql.table.consumer) is based on system.externalOperator and uses datahub-flowagent for execution.

Configuration Parameters

Parameter

Type

Description
MySQL Connection object The object containing the connection parameters to a MySQL database.
Version (type enum)
MySQL database version.
MySQL 5.6
Host (type string)
MySQL host name.
Port (type number)
MySQL port.
Default: 3306
Database name (type string)
MySQL database name.
User (type string)
MySQL user.
Password (type string)
MySQL password.
Additional Session Parameters (type string)
Set session parameters which will affect the connection with the source.

Source Table

string

 MySQL table name from which the data will be read, usually in <Schema>.<TableName> format.
Additional Session Parameters string Set session parameters which will affect the connection with the source.
Fetch Size

integer

 Indicates the number of rows that will be fetched from the source in each request. For wide tables, smaller values are better. For tables with fewer columns, larger values are better.

Default: 100

Input

Input

Type

Description

inTableNam

string

 MySQL table name from which the data will be read, usually in <Schema>.<TableName>.

Output

Output

Type

Description

outConfig

string.flowagent.config

 Flowagent type port, which only Flowagent producers can consume (i.e., Flowagent File Producer). In order to get the data as string, Flowagent CSV Producer can be used as producer.

outError

string

 Operator error. If mapped, the operator error will be sent to the operator this port is mapped to and the graph will remain running. If not mapped, the graph will terminate with the operator error.