ODBC Library

Type: Library, Installed

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

• Examples and libraries by topic
• Libraries table
• WriteTableSql
• InsertRecSql
• Database functions
• Standard libraries