Page 314 - Untitled-1

WHAT’S DIFFERENT? 293

Figure 10.2b ArtemisViews/Oracle Projects Interface

ArtemisViews Project Data Oracle Projects
Tasks
Project Definition Organizations
Create WBS Resource Lists Employees
Budget/Forecast Plan
Schedule Project Actual Costs Expenditure Types
Assign Resources % Complete / Earned Value Expenditure Categories

Status Progress Oracle Database Labor
Shared Inquiries Vendor Invoices
ArtemisViews Tables Expense Reports

Usages

Oracle Projects Tables

What’s Different?

The ability to transfer data between applications is certainly neither new nor
unique. If fact, even some of the vendors discussed above have accessory pack-
ages to facilitate such connectivity. Primavera’s DataStore allows the saving of P3
data in native Oracle formats, as do several other programs. Artemis’ ProjectView
has long used Oracle as one of its file formats. Furthermore, most programs sup-
port ODBC protocols to allow exchange of SQL-formatted data. Artemis also
markets GlobalView, an OLAP-based tool to facilitate the multifaceted analysis of
project data generated by their other Views products.

Where we gain from the ArtemisViews/Oracle Projects modules, and other
similar capabilities, is improved automation and control. Working within the
Oracle Projects modules, we can define process workflows and rules. Oracle
Workflow is one of the tools available to define such things as required ap-
provals for changing project status or budgets, as well as defining the notifica-
tion process.

The Oracle Projects Activity Management Gateway (AMG) is the mechanism
used for connectivity to project management software packages, to other Oracle
systems, such as Financial Accounting, and to a data warehouse. The AMG mod-
ule also provides for security and standards by defining the rules for data ex-