Input
ODBC Input
Reads a whole table or view through ODBC — a DSN set up on the FlowDoo server, or a connection string naming an installed driver.
When to use it
Use it for any database with an ODBC driver: Sybase, Progress OpenEdge, Pervasive, Vertica, Netezza and others.
In a pipeline
ODBC InputFilter RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Table | select | Yes | Select a table |
Example
Orders through a DSN
- Connection=SalesDSN
- Table=dbo.orders
| order_id | customer | total |
|---|---|---|
| 77 | Harbour Foods | 420 |
| 78 | Cole & Sons | 133 |
Worth knowing
- Type a DSN name, or a full connection string such as Driver={Vertica};Server=vdb.example.com;Database=sales.
- DSNs are set up by your administrator on the FlowDoo server (odbc.ini); tables come from the driver's catalog.
- Runs through the server's Python bridge (pyodbc with unixODBC).