Database and spreadsheet connection guide¶
The Guide is definitive. Reality is frequently inaccurate.
AMPL’s relational database facility
provides a convenient mechanism for accessing data in spreadsheets and
databases. A flexible
table declaration defines correspondences between
sets, parameters, variables, and expressions in AMPL models and external
tables managed by database systems or spreadsheet applications.
read table and
write table commands use these correspondences to
import data values into AMPL and to export data and solution values from
AMPL can connect to external data sources through a standard Open Database Connectivity (ODBC) interface. This requires an ODBC driver for the type of data source you are using. For example if you want to connect to an Oracle database, you should have an Oracle ODBC driver installed.
There are ODBC drivers for most database management systems (DBMS) and some non-DBMS data sources such as Microsoft Excel and even CSV files.
This document will guide you through the set up necessary to connect AMPL to one of the following database systems: