MS SQL Reader simple application
The following application will write change data for the specified table to SysOut. Replace the Username and Password values with the credentials for the account you created for Striim (see Microsoft SQL Server setup), dbo.mytable
with the name of the table to be read, and watestdb
with the name of the database containing the table.
CREATE APPLICATION SQLServerTest; CREATE SOURCE SQLServerCDCIn USING MSSqlReader ( Username:'wauser', Password:'password', DatabaseName:'watestdb', ConnectionURL:'192.168.1.10:1433', Tables:'dbo.mytable' ) OUTPUT TO SQLServerCDCStream; CREATE TARGET SQLServerCDCOut USING SysOut(name:SQLServerCDC) INPUT FROM SQLServerCDCStream; END APPLICATION SQLServerTest;