This tutorial provides guidance on how to exchange data between GAMS and other applications. GAMS offers various ways of data exchange. The GAMS Connect framework allows users to read data from various data sources, transform data, and write data to various data sinks. It is a powerful and highly flexible framework based on so-called agents that perform specific instructions (e.g. reading from an Excel file) and can be combined for complex data operations. Besides reader and writer agents, the GAMS Connect facility offers various agents to transform data allowing the user to clean up, filter, etc. data directly in GAMS. For simple data exchange, GAMS provides data tools in the GAMS Tools Library that can be called in one line of code.

Note

GAMS offers a number of executable tools that can be found at Data Exchange. Many of these executable tools are deprecated and not maintained anymore, and therefore, have been or will be replaced over time by GAMS Connect agents and tools from the GAMS Tools Library.

The following sections provide advice on how to exchange data between GAMS and the most popular data sources: Text files, Excel files and Databases.

• Data Exchange with Text Files
• Data Exchange with Microsoft Excel
• Data Exchange with Databases
  • Data Exchange using PyODBC
  • Data Exchange using SQLAlchemy
  • Data Exchange with MS-Access
  • Data Exchange with MySQL
  • Data Exchange with Postgres
  • Data Exchange with SQLite
  • Data Exchange with SQL Server