ODBC Library

Revision as of 19:56, 2 November 2026 by Mhenrion (talk | contribs) (New page for this library (from Standard/Additional libraries))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Type: Library, Installed

ODBC Library: Functions to help write data from Analytica into relational database tables via ODBC -- most notably WriteTableSql, as well as InsertRecSql and ValList. Includes utilities to validate and sanitize SQL identifiers (table and field names), convert Analytica values and arrays into SQL-friendly lists, and generate INSERT statements for individual records or whole tables. Useful when exporting results to a database for reporting or downstream processing.

Using ODBC requires Analytica Enterprise.

It is installed with Analytica in the Libraries folder. To use it, select Add Library... from the File menu.

Download: ODBC-Library

Keywords: Data import and cleaning

See Also

Comments
Loading comments...