The Database connector allows you to perform CRUD tasks against a SQL server database.
- MSSQL Execute – executes a SQL query returning a Rows/Row XML data set
- MSSQL Execute Scalar – Executes a SQL query that returns a single result e.g. select SUM(Balance) from Customers
- MSSQL Repeater – Container task that executes a SQL query and allows you to perform additional tasks inside this task to process each row in the query.
- MSSQL XML Select – performs a hierachical query returning structured XML
Price quoted is for a 12 month license which renews annually. All prices exclude VAT.
Full documentation relating to the connector can be found http://help.zynk.com/kb/connectors/sql-server-integration