The Database connector allows you to perform CRUD tasks against an OLEDB compliant database.
- OLEDB Execute – performs a SQL execute against the database e.g. Update customers set trading_terms = 30
- OLEDB Execute Scalar – performs a SQL query returning a single result e.g. select sum(balance) from customers
- OLEDB 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.
- OLEDB Select – performs a SQL query against the database returning an XML data set e.g. select * from customers
All data is returned and expected in XML format. You can use XSLT or data adaptors to convert to any other format.
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/oledb-integration