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
  • Connect to Access database file
  • Write Selected Database Tables
  • Adapt model when linked database table is modified
  • Exchange data with the AIMMS Cloud Platform
• Excel and CSV
  • Overview: AIMMS Excel Library
  • Read Columns of Data from Excel
  • Read and Write CSV 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

Last Updated: June, 2019