Data Connection
We’re aware that AIMMS is one of many tools in your workspace. This section provides help to connect your AIMMS Software to external data sources, such as spreadsheets, databases, and R-based computations. You will also find topics for using libraries built-in to AIMMS.
- Databases
- Which ODBC Drivers
- Link an SQLite Database to a Project
- Install Side-by-Side Drivers
- Connection string for Access database files
- Write Selected Database Tables
- Write to a database efficiently
- Write data to a table
- Adapt model when linked database table is modified
- Exchange data with the AIMMS Cloud Platform
- Reading relations and indexed sets from databases
- DirectSQL Example
- Excel and CSV
- HTTP Library
- Overview: HTTP Client Library
- Extract Data from an XML File
- Extract XML File from a Server with the HTTP Library
- Retrieve Geographic Data with Google Maps API
- Retrieve Geographic coordinates with Google Maps API
- Extract Photos Using the Flickr API
- Convert Audio File with IBM API
- Use the IBM Image Recognition API
- Integrate AIMMS with Models Built in Languages like Python or R
- Integrate AIMMS with Python
- Integrate AIMMS with R
- Data Exchange Library
- Other Functions