Integration and Interfaces

PMWeb's 100% web-based structure allows interfaces via hyperlink to any system which has similar capabilities. System interfaces can also be achieved by a number of other means. PMWeb has several options for integrating data from existing systems. The method used is determined by several factors such as the type of data being integrated; the frequency of data exchange; and the direction of the data exchange. These aspects apply to both any up-front migration and subsequent data exchanges:

  • PMWeb’s “out of the box” integration with Excel includes field mapping for data exchanges
  • PMWeb’s Integration Manager toolkit item 
  • The PMWeb API (Application Programming Interface) - both SOAP and REST
  • One way exports out of PMWeb can be accomplished using Microsoft SQL Reporting Services
  • Microsoft SQL Server Integration Services (SSIS), Microsoft PowerShell and Microsoft Flow allow for more complex integrations where data transformations and direct table manipulations are needed. We have found that these tools have been able to address most complex integration needs.

We always recommend that a Client look closely at the need for an API-based integration, as well as any need for PMWeb’s Integration Manager. These two tools have an inherent cost that may or may not be warranted according to the functionality to be used in the Client's business. Just because an integration can be done does not mean that it should be done. Business needs should drive the integration approach. In major implementations for many major clients, integration was achieved by using SSIS packages to exchange information with other Enterprise systems – either directly or using client middleware. Each alternative should be explored on a cost/benefit basis.

A typical integration landscape is as follows:

Our integration experience includes:

  • SAP
  • Oracle Financials
  • PeopleSoft
  • JD Edwards
  • Microsoft Dynamics AX
  • Microsoft PowerBI
  • Yardi
  • IBM Maximo
  • Timberline/Sage 300
  • ViewPoint
  • DB2
  • ABB Ellipse
  • eCMS
  • Epicor
  • Kuali (Financials)
  • AS400
  • SharePoint
  • HP Desksite
  • Laserfiche
  • Microsoft Project
  • Oracle Primavera P6
  • Custom data cubes (e.g. Oracle or MS SQL databases for Tableau or other client specific integrations)


PMWeb - out of the box - is compatible with the a wide range of third-party software systems - read more