SQL Server Reader Activity

Reads SQL Server 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 SQL Server database is hosted.

text

Port

Port number which SQL Server database is configured with.

int

1433

Database Name

Name of the database.

text

User Name

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

text

Password

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

text

Table Name

SQL Server 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 SQL Server table.

text

Options

Additional options.

key-value