![]() WebFOCUS includes location analytics and machine learning capabilities, as well as support for cloud deployments. The suite gives users the capability to explore, create, analyze, publish, and collaborate on analytics content residing on a variety of platforms, including IBM i. ![]() WebFOCUS is unique because it’s one of the few BI suites that runs natively on IBM i. Ibi (formerly Information Builders) develops the webFOCUS line of products, which was the basis for IBM’s Db2 Web Query tool before the OEM relationship suddenly disintegrated. You may find more information at ibi webFOCUS The Essbase port was killed by IBM in 2011, just as it killed its own Db2 OLAP Server product six years earlier. While ShowCase was best known for the IBM i port of the multi-dimensional Essbase database, IBM killed the product after it acquired SPSS (SPSS, you will recall, acquired the ShowCase business from Hyperion). It also sells SEQUEL Data Access, which provides users with either a greenscreen or a GUI interface, as well as SEQUEL Web Interface for a browser-based experience.įortra also sells a collection of Windows-based reporting tools under the Showcase Deployment Bundle. The suite includes a native IBM i data warehouse called SEQUEL Data Warehouse that includes extract, transform, and load (ETL) and change data capture (CDC) capabilities. SEQUEL is a suite of products for storing and accessing data on Db2 for i. Cozzi says SQL Tools “pick up where IBM Services end.” Fortra SEQUEL and ShowCaseįortra (formerly HelpSystems) owns several business intelligence products for IBM i, including the SEQUEL line of products originally developed by Advanced Systems Concepts (ASC) and the Showcase tools that were originally developed by SPSS. SQL Tools, on the other hand, provides a collection of SQL functions and stored procedures that users can run from any SQL interface on IBM i. The software brings a handful of built-in functions that enables developers to write SQL statements to manipulate data in Db2 for i. Cozzi Research SQL WorldĬozzi Research develops two query tools for IBM i, including SQL iQuery and SQL Tools, and bundles them both in a single product called SQL World.Ĭozzi positions SQL iQuery as a native alternative to Query/400, the AS/400 query facility that has long since been fully depreciated. We’ll take a look at open source alternatives in a future article. Here are some potential business intelligence tools from vendors that could serve as replacements to Db2 Web Query. ![]() The good news is that IBM i software vendors offer a number of pre-built solutions that can fit the bill. The sudden demise of Db2 Web Query has sent customers looking for alternatives. You could also potentially use that as a placeholder to load immediately, while it is updated at a later point and re-saved if the value is different.IBM i Shops Have Alternatives to Db2 Web Query If the value is already defined, you could disable and populate components with the localStorage value instead. Though more difficult to set up, many queries could benefit from being saved to the user's cache in localStorage.Instead of the full stack trace, if a query is still within it's cache time and has exactly the same inputs, the request would go Browser -> Retool Server -> Browser and return the previous result. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |