EcoSys Web Services API
The EcoSys web services API are available following the REST, SOAP, and OData standards in order to make it easy to integrate with a variety of external systems, data warehouses, and middleware platforms, This is the recommended approach to import or export data from EcoSys for integrations.
The EcoSys web services API is also the method for integrating with BI reporting tools, such as Power BI or Tableau. The OData API also shines when used with reporting tools because of the powerful query capabilities of the OData standard.
The following are general advantages of using a Web Services API approach for integrating systems:
Industry Standard: Web Services is an industry standard integration platform for interoperability between systems.
-
Adopted and promoted by leading vendors of enterprise software such as Oracle EBS, Oracle Primavera, SAP.
-
Compatible with industry standard middleware platforms including BizTalk, OpenESB, SSIS, Informatica, WebSphere, Talend, etc.
-
Preferred and adopted by enterprise-scale EcoSys customers.
Platform Agnostic: Web Services works with any integration client, language, network, or database technology.
Real-Time: Provides per-record results back to the sender of the data and fine-grained control over exceptions, allowing for real-time re-importing of data if required.
Backwards Compatible: The web service interface does not change with software upgrades or reconfiguration.
The EcoSys Web Services API provides the following key benefits:
-
Publish web services for subject areas and fields suited to each interface, exposing only what is needed.
-
Fine-grained control over read/update rules on a per-row and per-field basis.
-
Full access to EcoSys's formulas and rollup calculations.
-
Industry-standard SOA compatibility: REST, SOAP, XML, JSON.
-
Automatically leverages the EcoSys performance platform:
Each request broken into sub-tasks that are executed in parallel threads (PULS).
-
Supports API paging for large read queries
-
Multi-layered adaptive cache (query > request > session > global).
-
Detailed performance metrics and built-in logging.
There is a license fee for the EcoSys Web Services API.
EcoSys Connect
EcoSys Connect is an ultra-modern middleware platform designed with an intuitive user interface, EcoSys Connect provides features and utility that make it easy to set up and maintain integrations:
-
Cloud-enabled middleware platform. Purpose-built to work in concert with today’s infrastructure needs.
-
Job status dashboard which provides access to user dashboard audit logs and job statistics.
-
Job Scheduler which provides options for scheduling jobs according to simple or complex conditions.
-
Workflow automation allows jobs to be executed as part of user triggers.
-
Ability to quickly identify failed jobs to make sure you are always using the latest, most accurate data.
-
Configurable field mapping and data transformations.
-
Supports end points for web services API’s and SQL/ODBC.
-
On-premise to cloud integration capability allows Connect to be hosted in the cloud while integrating with systems in a local data center.
EcoSys Connect currently supports end points for SOAP web services API’s and SQL/ODBC. Support for OData and REST OpenAPI will be supported in subsequent releases.
There is a license fee for EcoSys Connect.
Live Connector
Live Connectors are a feature that allows OData API’s to be dynamically accessed and display real-time, read-only data within EcoSys spreadsheets. This enables use cases where data can be queried from external systems without requiring to be persisted within EcoSys. OData queries can be constructed with parameters from EcoSys dashboards (such as Project ID, WBS, and so on) and then displayed in EcoSys spreadsheets – even though the data is not actually saved in the EcoSys database,
Live Connectors are compatible with any OData web service API.
Spreadsheet/File Import/Export
Front-end file import/export is for cases where data is being imported into or exported out of EcoSys by an end-user who is accessing the application and needs to interactively make adjustments to the data. For instance, detailed budget line items received from a contractor in Excel format can be imported.
Data that you import into EcoSys needs to be in Excel or tab-delimited formats. Data that you export from EcoSys can be created in any of these formats: Excel, tab-delimited, PDF, pipe-delimited, CSV, RTF, XML.
Spreadsheet/file Imports can be set up in an automated fashion (via a batch process) but do require set-up time and require some maintenance.
-
If the data being imported exceeds approximately 10,000 records, we recommend using EcoSys Gateway.
-
There is no additional license fee for front -file import/export functionality.