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.
- Data Exchange Library
- How to integrate the Data Exchange Library
- How to use the Data Exchange Library for extracting files and data
- How to create mappings for matrix-oriented data via name-binds-to
- Reading slices of data via ExternalBinding mapping element
- Dealing with different data types in the DEX
- Using OAuth2 for API authorization with DEX
- Use the AIMMS Cloud Azure Data Lake Storage for integrating data
- OpenAPI
- Develop an AIMMS Service
- How to access the Azure Data Lake Storage from an external location
- Databases
- Connecting to and using the AIMMS Cloud database
- 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
- Create a static AIMMS Library from a runtime library
- 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
- Other Functions