ADDVantage


ADDVantage™ enables you to easily produce and share reports that contain the information needed to make informed decisions. It leverages your HP e3000 data into one of your most powerful and valuable assets.

  • Professional - End user reporting made easy.
  • Warehouse - Create business critical reports without impacting HP e3000 performance.
  • Archive - Move but don't lose your history.
  • Web - The hooks required to internet enable your HP e3000.

For more information contact us today.

Professional

Open the Window to Your HP e3000 Data

ADDVantage PROFESSIONAL opens the window to your HP e3000 data. The product is designed to allow even non-technical users the ability to point-and-click their way to well-formatted, easy-to-read results. ADDVantage PROFESSIONAL combines Minisoft's state-of-the-art ODBC/32, Seagate Software Crystal Reports®, the acknowledged leader for Windows® report writers, and an easy to use and understand data dictionary. Top-notch training and complete installation services give you an out-of-the-box return on your investment.

ADDVantage PROFESSIONAL Includes:

  • Seagate Software Crystal Reports version 8.0
  • Minisoft ODBC/32 Drivers
  • The ADDVantage PROFESSIONAL data dictionary that standardizes formats, naming, and conventions

Features and Benefits

  • Point-and-click development
  • Sophisticated report generation from live data
  • Complete access to IMAGE, KSAM, ASCII, and even Cognos® Subfiles
  • Easy-to-use for even non-technical personnel
  • Leverages data into a powerful, usable tool

Leverage Your HP 3000 Data

ADDVantage PROFESSIONAL gives you the most complete access to all HP e3000 data. GrowthPower® users can also get access to Materials Requirements Planning (MRP), Capacity Requirements Planning (CRP), and manufacturing transaction files in an easy to use format not otherwise available. You can even add data from HP 3000 files and databases to complete your reports. The ADDVantage Dictionary creates consistency with easy-to-understand names and conventions. Because ADDVantage PROFESSIONAL is so easy to use, even end users can create the report they need to make an informed decision.

Professional, Sophisticated Reporting

ADDVantage PROFESSIONAL includes many report format options, and even allows you to combine formats in a single report. Calculate derived fields and apply aggregate functions such as sum, average, minimum, maximum, count, first, and last to facilitate data interpretation. Perform multilevel sorts in ascending or descending order, or sort by value or custom group specifications. Using design Experts to guide you through reporting and graphing tasks facilitates rapid development of presentation quality output.

Report Format Options:

Cross-tab
Mailing label
Summary
Graph
Top/N
Drill down
Listing
Combination of two or more formats

Superlative Support

We are committed to helping you take full advantage of personal reporting. We offer ADDVantage PROFESSIONAL training, installation, and professional services. With your support agreement, you'll gain access to unlimited support of the dictionaries, periodic updates to accommodate new software releases of ODBC/32, Crystal Reports, or your ERP product. Pivital Solutions can provide all the application, system software, networking, and hardware optimization support services to help you maximize your ERP and ADDVantage investments.

ADDVantage PROFESSIONAL satisfies one of the ERP's greatest shortcomings, information accessibility. This low-cost high-return product can extend the useful life of your HP e3000 and compare prices starting below $5,000 to the cost of an ERP implementation.

Warehouse

Rapid Access to HP e3000 Data

ADDVantage WAREHOUSE works with the original ADDVantage PROFESSIONAL product to give you rapid report-writing capability, increase your performance, and reduce the load on your HP e3000. Either in real-time or once per day, at a time that is best for you, ADDVantage WAREHOUSE replicates data from your HP e3000 to a SQL Server® database. Once the data is available in the SQL Server database, you can access the full power of Crystal Reports® at speeds impossible with a direct interface to the HP e3000. And, since the report database doesn't reside on the HP 3000, there is no load on this valuable resource when you process reports.

ADDVantage WAREHOUSE Includes:

  • ADDVantage PROFESSIONAL
  • SQL Server (if needed)
  • Seagate Analysis
  • Automatic data capture to SQL Server
  • Direct connection of Crystal Reports to SQL Server

Features and Benefits

  • Rapid report-writing capability
  • More efficient data handling for extended reports
  • Reduced load on the HP e3000

More Options

ADDVantage WAREHOUSE includes ADDVantage PROFESSIONAL so you never lose your capability to generate reports from real-time data. Because SQL Server is a relational database, data is managed efficiently enabling more extensive and more complex reporting than is possible using IMAGE databases. Extended reports take minutes instead of hours and inquiries can be made in seconds.

Archive

Avoid the Burden of Data History

ADDVantage ARCHIVE allows you to report sales trends, compare performance to forecast, see this year versus last year comparisons, inquire on historical transactions, and much more without burdening the everyday use of your HP e3000. ADDVantage ARCHIVE works with the ADDVantage WAREHOUSE product.

ADDVantage ARCHIVE Includes:

  • ADDVantage PROFESSIONAL
  • ADDVantage WAREHOUSE
  • Data replication with integrated data removal

Features and Benefits

  • Relocate historical information off-line
  • Improve HP e3000 performance without additional CPU or disk
  • Simple, automated processing from predefined settings
  • Retain all detailed transaction data for reporting purposes

Free-up Your HP e3000 for More Important Tasks

You can safely and securely archive data while still maintaining access for historical reporting or inquiry purposes. Performance of your most valuable resource, your HP e3000, improves in two ways. Not only will you physically free up valuable disk space, but by reducing the amount of data it needs to manage, you will increase the performance of other processes, thereby improving response speeds.

ADDVantage ARCHIVE replicates data from your HP e3000 to a SQL Server database on any desired interval. Based on user-defined settings, the data is then removed from the HP e3000. All data is available in the SQL Server® database, but only current data remains on the HP e3000. You can produce reports from all or only archived data directly from SQL Server.

What ADDVantage ARCHIVE Will Do for You:

  • Improve performance by safely and securely removing out-of-date information without touching active data
  • Produce reports from all or selected data directly from SQL Server
  • Consolidate data-deletion system maintenance tasks in a single user-definable tool

Web

Internet Enabled HP e3000 Data

ADDVantage WEB goes one step further than the simple e-reporting capabilities of ADDVantage WAREHOUSE, allowing e-interaction with your ERP system. ADDVantage WAREHOUE replicates data from your HP e3000 to a SQL Server® database making all your data available for e-reporting; ADDVantageWEB easily expands data access use to new limits.

Give customers more then just visibility to open sales orders on-line; let them actually enter orders and get instant feedback on inventory availability and scheduled ship dates. Share MRP and performance information with vendors to help improve the entire supply chain. All the data on your HP e3000 is available for e-interaction.

Use ADDVantageWEB to build content portals. Easily and securely manage delivery and presentation of data to the entire enterprise. Customers, vendors, and employees easily establish individual links to the information most important to them. Host any Crystal Report® on the Web by simply linking it to your web server. Multiple systems come together, seamlessly integrated, allowing viewing and interaction with all relevant information. For example, technical product data can be available during sales order entry.

ADDVantage WAREHOUSE Includes:

  • ADDVantage PROFESSIONAL
  • ADDVantage WAREHOUSE
  • e-reporting and interaction

Features and Benefits

  • On-line access to data
  • New levels of customer, vendor, and employee interaction
  • Bi-directional interaction with the HP e3000
  • Facilitates creation of content based portals