Symtrax BI Tool Now Works with Open Source Spreadsheet

March 9, 2010 Alex Woodie

Symtrax last month unveiled StarQuery for Calc, a new module of its StarQuery suite of business intelligence (BI) tools designed to work with Open Office‘s Calc, a free and open source alternative to Microsoft Excel’s spreadsheet program.

StarQuery is a collection of BI and reporting tools unveiled by Symtrax in late 2003. The software was designed to enable end users to generate their own reports and do their own data manipulation from the comfort of Excel (once an administrator has created the database views that users will have access to). By putting more power in the hands of decision makers, Symtrax felt it could free up IT administrators to chase more value-added tasks.

With the launch of StarQuery for Calc, Symtrax is opening up its flagship BI product to a new class of users. Organizations that do not wish to purchase Microsoft Excel can now get the same level of functionality–including report building, query execution, and multidimensional analysis–through the integration of StarQuery with Open Office Calc.

The new software even supports the automatic generation of data pilots (or pivot tables), and makes it easier for JD Edwards shops to view data (such as dates and decimals) in an understandable format, Symtrax says. Excel users who want to adopt Open Office Calc don’t have to recreate the data maps or queries, Symtrax says.

Symtrax managing director Bernard Aldebert expressed excitement at the new product. “With StarQuery for Calc, users can now work on, format and analyze their data directly in Open Calc with optimal security,” Aldebert stated in a press release. “It is also noteworthy that StarQuery Suite is the first business intelligence suite covering nearly all spreadsheet programs.”

StarQuery is used by a large number of JD Edwards shops, as well as companies running BPCS and MAPICS ERP applications, according to Symtrax. Other StarQuery components include StarQuery MapDesigner, StarQuery Scheduler, and StarQuery for the Web. For more information, see www.symtrax.com.

Symtrax Delivers ‘Dashboard’ Reporting Solution for iSeries

Symtrax Adds Automation to StarQuery Reporting Tool

Symtrax Ships New StarQuery Business Intelligence Tool

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

Strategic Partnerships Add Value

A Case for On-Prem IBM i Deployment

As organizations decide where to run their IBM i workloads with a growing range of strategies, it becomes more important to have strong differentiators in the various options to help make prudent IT decisions. Cloud options are now becoming more widely considered, but as UCG Technologies explains in a recent IT Jungle article, these options should be weighed in comparison to purchasing or leasing your own IBM Power Server and installing it on premises or at a Co-location facility.

On premise (on-prem) deployments largely remain most cost-effective and appropriate for midrange systems, especially when factoring in backup and disaster recovery. One way to maximize this approach is to capitalize on long-standing partnerships with complimentary expertise as in the case with IBM and UCG Technologies. The IBM i Solution Edition for UCG’s VAULT400 cloud backup & DRaaS is an offering that allows organizations the ability to combine the power of IBM Power Systems and IBM i with the strengths of business applications, along with superior services and support. The leads to improved productivity and responsiveness, adaptability and competitive Total Cost of Ownership (TCO).

Benefits to the end user include:

Discounted single or unlimited user entitlements – Save $6,000 to $60,000
No-charge IBM i processor core entitlements
No-charge IBM i access unlimited user entitlements
Discounted Rational Developer for i
No-charge service vouchers – 4 hours or 8 hours – Value of up to $ 1,800
IBM Spec Sheet for IBM i Solution Edition

To receive the above benefits, end user client must meet IBM requirements including contracting for a minimum of $6,000 of VAULT400 cloud backup services for P05 or $25,000 for P10 with UCG Technologies. The IBM i Solution Edition may be purchased directly from UCG Technologies or from another qualified – authorized IBM partner.

The IBM i Solution Edition for VAULT400 cloud backup & DRaaS is available for both the IBM Power System S914 and S924. Leverage a platform that utilizes the full power of IBM i while deploying a complete backup and disaster recovery solution that delivers rapid ROI. That is an on-prem win-win for mid-market organizations.

Request Complimentary POWER9 System Upgrade Analysis

Please visit ucgtechnologies.com/IBM-POWER9-systems for more information.

800.211.8798 | info@ucgtechnologies.com

Arrow ECS Adds Professional Services A Case for CASE

Table of Contents

Content archive

Recent Posts

Subscribe

Pages

Search