Staying in Orbit of 3000's Spoken Stories
Is HP porting HP-UX to Xeon, or not?

ODBC provides link to analyzing data stores

An essential database feature of the HP 3000 is still providing the means for advanced analysis. A new alliance between the top-rank ODBC provider for MPE and a data analysis firm is also delivering better access to the value of deep data on HP 3000s, as well as other servers in the enterprise.

VisualAnalyzerTomorrow MB Foster and InfoPlanIT will show off tools and practices to make operational data stores and warehouses more valuable to companies. InfoPlanIT has been working with manufacturers who use HP 3000 and MANMAN for more than a decade. MB Foster created the bundled ODBC driver in MPE/iX, ODBCLink/SE. That product has evolved to become the UDA Series during the 15 years since HP wired ODBCLink/SE into the 3000's data services.

The June 13 Webinar at 2PM EDT (11AM Pacific) will show how to monitor the vital signs of a business by combining the InfoPlanIT Visual Analyzer. The companies say that the Visual Analyzer is "web-based and works with virtually every desktop, laptop and mobile device." It can be fed with data from ODBC sources, not to mention the ubiquitious SQL Server, Oracle, DB2, MySQL, MS Access, SQLite and even Excel.

MB Foster has created report templates that streamline integration with the Visual Analyzer capabilities. The 45-minute program will also show the benefits of using an operational data store or a data mart. You can sign up online for the presentation, which is free.

Business applications such as MANMAN are especially reliable IT resources, but the reporting elements often can use help. There's been a healthy cottage industry that's grown up to serve ERP and MRP apps like MANMAN. The better ones make an offer to simplify analysis using connection wizards and templates for data. The InfoPlanIT product has got both of these. Visual Analyzer's very deep web page says the product can let users skip Excel skills to get business insights into circulation among managers.

The beauty of using InfoPlanIT Visual Analyzer is that there is no need to take your data to Excel. InfoPlanIT Visual Analyzer has a lot of built-in functionality that enables real time visual analysis. If you do find that you need to take your data into Excel, there is a built-in export for that.

The product also ships with a Microsoft Office Add-In that allows analysis results to be easily embedded into PowerPoint presentations, Excel spreadsheets, and Word documents. Using this add-in, users can simply choose a layout from their drop down and add it to their report. Next month, they simply have to update the chart with the latest numbers.