MS SQL Reader properties
Note
Before using this adapter, you must complete the tasks described in SQL Server setup for MS SQL Reader.
Before reading from SQL Server with an application deployed to a Forwarding Agent, you must install the required driver as described in Install the Microsoft JDBC Driver in a Forwarding Agent.
By default, SQL Server retains three days of change capture data.
Striim provides templates for creating applications that read from SQL Server and write to various targets. See Creating an application using a template for details.
The adapter properties are:
property | type | default value | notes |
---|---|---|---|
Auto Disable Table CDC | Boolean | False | SQL Server starts capturing change data when the Striim application is started. With the default setting of False, SQL Server will continue capturing change data after the application is undeployed. If set to True, when the application is undeployed, SQL Server will stop capturing change data and delete all previously captured data from its change tables. |
Bidirectional Marker Table | String | When performing bidirectional replication, the fully qualified name of the marker table (see Bidirectional replication). This setting is case-sensitive. | |
Compression | Boolean | False | Set to True when the output of the source is the input of a DatabaseWriter target that writes to Cassandra {see Cassandra Writer). |
Connection Pool Size | Integer | 10 | typically should be set to the number of tables, with a large number of tables can set lower to reduce impact on MSSQL host |
Connection Retry Policy | String | timeOut=30, retryInterval=30, maxRetries=3 | With the default setting:
Negative values are not supported. |
Connection URL | String |
If the connection requires SSL, see Set up connection to MSSQLReader with SSL in Striim's knowledge base. | |
Database Name | String | the SQL Server database name | |
Excluded Tables | String | If the | |
Fetch Size | Integer | 0 | The fetch size is the number of rows that MSSQLReader will fetch at a time. With the default value of 0, this is controlled by SQL Server. You may set this manually: lower values will reduce memory usage, higher values will increase performance. |
Fetch Transaction Metadata | Boolean | False | With the default value of False, the |
Filter Transaction Boundaries | Boolean | True | With the default value of True, begin and commit transactions are filtered out. Set to False to include begin and commit transactions. |
Password | encrypted password | the password specified for the username (see Encrypted passwords) | |
Polling Interval | Integer | 5 | time to wait between fetches; in seconds |
Start Position | String | EOF | With the default value See also Switching from initial load to continuous replication. |
Tables | String | The table(s) or view(s) in for which to return change data. Names must be specified as You may specify multiple tables and views as a list separated by semicolons or with the following wildcards:
For example, | |
Transaction Support | Boolean | False | If set to True, MSSQLReader will preserve the order of operations within a transaction. This is required for Bidirectional replication. Transaction support requires one of the cumulative SQL Server updates listed in FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database. If you have not applied one of those updates, or are reading from SQL Server 2008, leave this at its default value of False. |
Username | String | the login name for the user created as described in Microsoft SQL Server setup |