ODBC provides link to analyzing data stores
June 12, 2012
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.
Tomorrow 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.
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.