Examples of ProjectsERP Integration

I decided to take a closer look at some of the ERP-based solutions, starting with the one offered by Oracle. It appears to deliver the capabilities advertised in their statement. Looking specifically at the role of a suite of products (sold under the umbrella label of Oracle Projects), we do find a bridge between projects-oriented data and the corporate operations data. Oracle Projects is their doorway into Oracle Financials and other Oracle components, as shown in Figure 10.2a. By partnering with PMS vendors, they create a second doorway, which allows continuity between projects and accounting data, with single entry. This is what people are asking for when they talk about enterprise PM systems.

Tool Tip The discussion here on ERP/PM integration focuses on a solution offered by two vendors, Oracle and Artemis. This is only one of several offerings from many of the popular PM and ERP vendors, and is used solely as a means to illustrate the types of solutions that are available in this area. The mention of any of these offerings does not constitute a vendor choice by the author.

Figure 10.2a Oracle Projects Integration

Figure 10.2a Oracle Projects Integration

Oracle

Artemis

*In Development

Oracle

Artemis

*In Development

Oracle has developed partnership agreements with several PM vendors, including Artemis, Primavera, Welcom, and Mantix, and is adding new partners every year. The role of the partners is to develop, market, and support an interface product, which will facilitate two-way transfer of data between the project management program and the Oracle Projects Activity Management Gateway module.

For instance, Primavera has developed a set of Application Programming Interfaces (APIs) which enable rapid data access between applications. In addition to linking Primavera Project Planner (P3) to Oracle Projects, an interface can provide access to Project System, from SAP. This facilitates integration with the SAP R/3 system. Primavera also has interfaces to PeopleSoft and J.D. Edwards. All of these interfaces will work with the full range of Primavera's project tools: SureTrak, P3, P3e, Team Play, and Expedition.

Welcom has developed links between Open Plan and Cobra (their PM and Earned Value products) and two ERP products: SAP/R3 and Baan (IV & 5).

Artemis has developed their ArtemisViews/Oracle Projects interface to link ProjectView, TrackView, and CostView with Oracle Projects, as shown in Figure 10.2b. The ProjectView/Oracle Projects interface facilitates the transfer of system-level data, such as organizational structure, calendars, and resource data from Oracle Projects to ProjectView. Project templates stored in Oracle Projects can also be used to open a standardized project in ProjectView. Once the project is established, via either transfer or development in ProjectView, the project data can be sent to Oracle Projects. This might include work breakdown structures, activities, resource requirements and budgets, performance, and earned value data. During project implementation, accounting data, such as charged hours and invoiced costs, can be entered directly into Oracle, and passed down to the scheduling system, as well as on to Oracle Financials.

Artemis' CostView software manages the extensive cost data usually associated with government projects (C/SCSC). With the CostView/Oracle Projects interface, these cost data can be transferred between both products. The interface provides three window tabs, for Actuals, Budgets, and Earned Value.

Artemis has also joined SAP's Complementary Solution Program, for integration with SAP R/3.

In addition to the three partnership agreements between Oracle and Artemis/ Primavera/Mantix, Oracle has determined that an interface is needed to integrate with Microsoft Projects. In this case, rather than development and sales of the interface tool by the project management software vendor (Microsoft), the tool (Project Connect) is provided by Oracle.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment