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
  • Exchanging Data with Excel Files
  • 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
  • Convert JSON to XML
• 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

Last Updated: October, 2019