I am pleased to announce that today expressor software's Engineering team has released version 3.5.2 (build 19918) of the expressor platform. It is positioned to be available for download later this week. (2/10 or sooner) In addition to the Salesforce Read and Write Operators released in version 3.5, this anticipated release increases product stability and adds 2 brand new extensions that allow simplified read and write access to Excel and QlikView data files. Talk about delivering stable, robust functionality in such a short timeframe. expressor's Engineering team deserves kudos across the board. (See release notes for more detail on this release.) Come visit the QlikView express site for more information and introductory videos.
The QlikView Extension This extension delivers high value to QlikView customers because it enables them to harmonize and standardize the metadata in use by QlikView applications.
Some Background QlikView customers build reporting applications using data from a variety of sources. Like most BI tools, the strength of the QlikView product is in its visualization capabilities. QlikView can source data from different sources but it doesn't provide an effective way to manage, reuse, or harmonize the metadata across those sources.
Without a solid metadata foundation, QlikView users are unable to provide meaningful insight into the source or lineage of the data that is being reported. QlikView created the QVX file format partly as a way to give QlikView users a chance to drive all QlikView applications from the same source type and, as a consequence, the same metadata format. A QVX file serves as another source to the Qlikview application. By providing a source that they control, QlikView can begin to address these metadata issues for its customers. But they can't do it alone.
In comes expressor …
QlikView customers can now use the QlikView extension in expressor to read and transform data to generate new QVX files. With the semantic types framework capturing all of the metadata being sourced and produced for QVX, QlikView customers can begin to harmonize the metadata for their QlikView applications inside of expressor and take advantage of expressor's expanding metadata capabilities. In addition, QlikView customers will benefit from the variety of connectors that expressor is in the business of developing over time. It's also possible for Qlikview customers to transform the metadata that is already locked-up in their Qlikview applications into real QVX schemas and semantic types in expressor. This provides a powerful path to unlock the metadata for existing Qlikview applications.
QlikView extension features
QlikView Schema artifact – This new extension includes a new expressor artifact that captures the metadata for a QVX file and maps it to a Semantic Type. It handles all relevant type conversions to/from the QVX file into the semantic type model and allows users to map QVX data to a common set of metadata types and constraints. This schema can be created from an existing Semantic Type in expressor making it easy to create standard Qlikview QVX data files from any expressor dataflow. A QVX Schema can also be created from the metadata that is embedded in the QVW and QVD files of existing Qlikview applications making it easy to convert the sources of those dataflows to QVX files produced by expressor dataflows.
Read Qlikview and Write Qlikview operators - As their name implies, these new operators can read and, more importantly, write QVX files. As with all operators, many properties for these operators can be parameterized in the same manner as other parameterizable properties in 3.4. All Qlikview metadata and operators in expressor are reusable. Along with the Salesforce capabilities in 3.5, this is expressor's second extension built on the evolving extension framework.
Salesforce to QlikView - from raw data to actionable insight using expressor and QlikView
Extension packaging and licensing
The 3.5.2 installer now includes all three extensions (Excel, Qlikview, Salesforce). Users must have a valid non-Community license to run dataflows for any of these.