Integration
There are five mechanisms of integrating with Eclipse / Eclipse Pro:
- Flat ASCII Files
- SQL Tables (not just SQL Server)
- JSON API (Eclipse Pro)
- On-Demand / Sync (Eclipse Pro)
- Directly (Eclipse Pro)
These mechanisms can be used concurrently. For example, Eclipse Pro can be configured to import from ASCII files and export to SQL tables.
The pages below are organized by mechanism. If you want the other axis — "for this kind of data, what are all the ways it can enter or leave Eclipse?" — see Data Domains.
Flat ASCII / SQL Tables (Eclipse Pro and Eclipse Classic)
Flat ASCII files and SQL tables share the same data structures. The only difference is the interface mechanism. The ASCII file is CSV (comma separated value) table without headers. The processing logic is identical after reading either the ASCII file or the SQL table. Therefore, we will refer to both methods as Table Import.
Eclipse is known to work with the following SQL databases:
- Microsoft SQL Server (all versions and editions)
- Oracle
- PostgresSQL
- MySQL
- AS/400 / DB2
Eclipse Classic should be able to work with any 32-bit ODBC driver. If your database is not on the list and you run into problems, contact AMS as we might need to create formatting rules (for example, Oracle requires a different date format than SQL Server).
We have no plans on deprecating the table based interfaces, even as we develop newer mechanisms.
JSON API (Eclipse Pro)
This will be where more advanced interactions are possible. The current interface is limited, but we can add new data endpoints as requested by customers. In addition to the transactional data that the table interface exposes, APIs can be used to access real-time status.
On-Demand / Sync (Eclipse Pro)
On-Demand and Sync are event-driven: the external system makes data available and Eclipse Pro requests it when needed. Unlike the table and API integrations, which are more transactional, these mechanisms suit reference data (On-Demand) and frequently-changing data that must stay in sync (Sync).
Directly (Eclipse Pro)
With Eclipse Pro, we have more ability to interface with external systems directly. Each implementation of this interface is unique and requires custom development work.