ODBC Integration Connector

Easily integrate your ODBC databases with external systems using Zynk as your middleware.

SKU: ZNK-ODBC Category:

Description

The Database connector allows you to perform CRUD tasks against a ODBC database.

Tasks include

  • ODBC Execute – performs a SQL execute against the database e.g. Update customers set trading_terms = 30
  • ODBC Execute Scalar – performs a SQL query returning a single result e.g. select sum(balance) from customers
  • ODBC 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.
  • ODBC 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.

Technical Documentation
https://docs.zynk.com/workflow/documentation/database/odbc.html