Property | Description |
---|---|
Server Name | Specifies the server’s name to connect. This is a mandatory property. |
Port | Specifies the port to connect on the Server Name. The default value is 1433. This is a mandatory property. |
Database | Specifies the name of the database. This is a mandatory property. |
User | (Optional) Specifies the username for the connection or database login. |
Password | (Optional) Specifies the password for the connection or database login. |
Property | Description |
---|---|
Source | Specifies the data source object type. It has two possible values: Table (default) and Query. |
Schema | (Optional) Specifies the schema name. |
Table | Specifies the table or view name. This is a mandatory property. |
Query | Specifies the SQL statement to select data from the source. This is a mandatory property. This field is enabled when Source field is selected to Query. |
Row Limit | (Optional) Specifies the maximum number of records to return from the database. The value 0 means all records are available. |
Burst Size | (Optional) Specifies the number of records that the connector concatenates and returns as a single logical data unit per burst. The Value 0 instructs the connector to concatenate all available records and return them as a single unit of data. This property is enabled in burst mode. In integral mode the value 0 is always used. |