# ODBC

Frends offers seamless integration with the [Open Database Connectivity (ODBC)](https://learn.microsoft.com/en-us/sql/odbc/microsoft-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`](https://tasks.frends.com/tasks/Frends-ODBC-ExecuteQuery/) task, we can create an integration that retrieves data from a database and generates CSV exports for further processing.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-c062df604204b0fba55532cf4d6664f995582f7b%2Fodbc-export.svg?alt=media" alt=""><figcaption><p>Export</p></figcaption></figure>

### Insert data into database

By using the file trigger and the [`ExecuteQuery`](https://tasks.frends.com/tasks/Frends-ODBC-ExecuteQuery/) task, we can create an integration that listens for incoming CSV files and inserts the data into the appropriate table in a database.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-3f9ca75d9d12e946a2168c96008af56002348f4e%2Fodbc-insert.svg?alt=media" alt=""><figcaption><p>Insert</p></figcaption></figure>