SQL Server Table Consumer

Microsoft SQL Server Table Consumer (com.sap.dh.ds.microsoftsqlserver.table.consumer) is based on system.externalOperator and uses datahub-flowagent for execution.

Configuration Parameters

Parameter	Type	Description
SQL Server Connection	object	The object containing the connection parameters to a MySQL database. Version (type enum) SQL Server database version. Microsoft SQL Server 2012 Host (type string) SQL Server host name. Port (type number) SQL Server port. Default: 1433 Use TLS (type boolean) Enable secure connection. Default: false Database name (type string) SQL Server database name. User (type string) SQL Server user. Password (type string) SQL Server password. Additional Session Parameters (type string) Set session parameters which will affect the connection with the source.
Source Table	string	SQL Server 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
`inTableName`	string	SQL Server table name from which the data will be read, usually in `<Schema>.<TableName>` format. Note This is optional. If Source Table is presented, this port is ignored.

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.