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
  • 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
• Excel and CSV
  • AIMMS Excel Library - AXLL
  • Read Columns of Data from Excel
  • Read and Write CSV Files
  • Determine Data Ranges in Excel Files
• Other Functions
  • Create Email Templates
  • Overview: Email Client Library
  • Create an External Function with Visual Studio
  • Exchange Data with External Source
  • Run Executable Files
  • Run Batch Commands with AIMMS Command Line Tool
  • Link AIMMS with Tableau
  • Connect AIMMS with Gurobi
  • Overview: Linking to AIMMS
• 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
• How to Integrate AIMMS with Models Built in Languages like Python or R
  • Overview
  • Development Tools
  • Deployment
  • Examples
• How to connect AIMMS with Python
  • Example and prerequisites
  • The Python model
  • The AIMMS model
  • Deployment
• How to connect AIMMS with R
  • Example
  • The R project
  • The AIMMS project
  • Deployment
  • Further reading