PLOX

You like to work with Excel, but…

The following sounds familiar to you:

• You send out an excel-sheet, get various modified sheets back and have to merge them laboriously?
• You lose track of your data?
• You don’t trust in the correctness of your information?
• Fixed spreadsheets constrain you at work, you miss flexibility?

Empower Your Spreadsheets

The solution is PLOX! PLOX is a convenient plug-in, directly integrated in your existing Excel - quickly and without additional system installation on the part of the user (like ODBC).

It offers an amazing array of database functions right in your spreadsheets: Once the data are loaded into Excel, they can be edited with PLOX directly in your spreadsheet. After revision the updated data will be stored back in the database.

Benefits for Excel-User

• Extract your data directly into Excel
• Update Oracle directly in your spreadsheets
• Consolidate data from various databases
• Use and analyse your business data effectively

Benefits for IT Professionals

• Data validation: The data will be written back in a controlled way
• Data security assured by strict access control
• Low administration effort

Database Security: Trust is good, control is better

Unlike conventional connections between Excel and databases, with PLOX you may read and write your data in a controlled manner. A service layer connected in between provides a maximum of security.

PLOX integrates your databases and applications

As a Mashup Client Excel takes over the editing and consolidation of data from different applications. You may link data from your databases with those of other systems, like for example SAP, to get valuable information.

PLOX Assistant: web services at the twinkle of an eye

PLOX Plug-In requires several web services for loading data. With the aid of the newly developed assistant these services can be created and edited easily. Genauere Informationen dazu finden Sie hier. Further information here.

Use Cases

• Resource planning and budgeting: The central validations remain the same in spite of the adaptation to the requirements of individual departments.
• Time recording: Central interpretation of distributed employee data
• Site inspection: All relevant parameter concerning the condition of sites are recorded offline and then transferred into the database, where they can be administrated in Excel.

Technical Facts

• Based on JavaEE and web services and therefore SOA Ready
• High performance from Oracle 10g R2 databases
• Compatible with Excel 2003 and 2007

You find further information in the detailed description below.