ODBC

ODBC (Open Database Connectivity) is a standard API that allows applications to interact with different database management systems.

Frends offers seamless integration with the Open Database Connectivity (ODBC) API, enabling you to effortlessly connect and automate data flows involving ODBC.

Frends has tasks for performing all core ODBC operations.

By leveraging Frends' task-based approach, you can configure and customize ODBC integrations according to your specific requirements. Frends offers a wide range of tasks that facilitate integrations to a variety of systems and protocols.

Use cases

Below you will find typical use cases for ODBC integrations and how they are implemented in Frends.

Query data and save as CSV

By using the ExecuteQuery task, we can create an integration that retrieves data from a database and generates CSV exports for further processing.

Export

Insert data into database

By using the file trigger and the ExecuteQuery task, we can create an integration that listens for incoming CSV files and inserts the data into the appropriate table in a database.

Insert