Technical Bulletin

8 Posts authored by: Michael Tarallo

QlikView Expressor version 3.12 is available for download at: http://www.qlik.com/download

 

The following is a list of new functionality found within this release, including many bug fixes and improvements:

 

  • QlikView QVX protocol based 32-bit connectors can now be used from within QlikView Expressor
    • Supporting 32-bit connectors built upon the QVX protocol, a developer can now access those same connectors that are available for QlikView from within QlikView Expressor
    • QlikView Connectors are used with the new QlikView Read QVX Connector operator in conjunction with the new QVX Connector Connection and QVX Connector Schema artifacts
    • You must have the 32-bit version of the QVX connector installed in order to be configured


qvx.jpg

  • Apache Hive and Cloudera Impala databases are now supported with built in ODBC drivers


hive.jpg

  • Windows 8 and Windows Server 2012 are now supported platforms for running QlikView Expressor Desktop
    Standard, and Enterprise editions
  • QlikView Expressor Connector supports QlikView.Next as well as QlikView 11
  • Extensions SDK contains new functions for building Connection Descriptors and Schema Descriptors that create specialized Connections and Schemas for interfacing with QlikView Connectors.


Please review the release notes for latest features and changes when browsing the download interface.

 

downoad.jpg

 

Regards,

 

The Products Team

We are pleased to announce the general availability of the QlikView Governance Dashboard version 1.1 to our customers & partners.

 

You may download the release http://download.qlik.com - requires registration and login.

 

QlikView Governance Dashboard 1.1 SR1 Highlights


Major Improvements:


  • Ability to use the Governance Dashboard app to scan multiple QlikView clustered environments
  • Improved License support includes Concurrent Sessions metric, session trend lines, more usage details
  • New Dashboard landing page with at-a-glance summary of QlikView deployment which can be easily printed
  • Field Usage page containing high level analysis of where fields are referenced in expressions, variables, labels, dimensions, and groups

 

Minor Improvements:


  • Additional publisher statistics including: duration of last reload, days since last reload, and section access
  • Additional Sheet Object metadata: sheet reference for objects (QV 11.2 SR4), text "definition" for text objects, expressions in Listboxes
  • Direct Discovery indicator in data lineage for scripts written in QV 11.2
  • More meaningful navigation bar with clearer tab labels

 

More than 100 Bug Fixes and Enhancements:

  • Notable: Issue with using UNC Paths in the configuration of the Dashboard fixed.

Please make sure to read the included release notes, attached to this post for your convenience.

 

Regards,

 

The QlikView Products Team

 

qvgd1.1.png

We are pleased to announce the general availability of QlikView Expressor 3.11 to our customers and partners. You may download the release here.

 

QlikView Expressor 3.11 Release Highlights

 

In addition to visual improvements and bug fixes, QlikView Expressor 3.11 now includes Read and Write QVD file support.

 

Brief Description of a QVD File

 

A QVD file is QlikView's native, proprietary Document Data storage format or stream that is commonly stored on disk. It is used in various capacities, but commonly to store and load data in to QlikView very rapidly.  Its structure reflects the uncompressed version of the native optimized in-memory representation of data used within QlikView applications. QVD files only store unique values and everything else are pointers to the parent data; reducing the amount of memory or disk space needed and providing speed-of-thought analysis when using QlikView. Reading data from a QVD file is typically 10-100 times faster than reading from other data sources.

 

Common Uses of QVD Files

 

  • Increasing Load Speed
  • Decreasing Load on Database Servers
  • Consolidating Data from Multiple Data Sources (RDBMS, Files, Web, etc.)
  • Consolidating Data from Multiple QlikView Applications

 

What this means for QlikView Expressor?

 

QlikView Expressor adds a layer of data governance and data management to your QlikView deployment by providing a graphical, reusable and consistent approach to consolidate and prepare data for QlikView. (learn more here)

 

With the addition of  QVD support, QlikView Expressor can now utilize the popular QVD storage format for not only writing QVD as output, but also for reading QVD as input; allowing the reuse of existing QlikView QVD assets as data sources for other applications.

 

How do I use it?

 

  • Use the QlikView Read operator for reading both QVD and QVX file formats with the respective extensions (.qvx or .qvd).
  • Use the QlikView Write operator for writing both QVD and QVX file formats with the respective extensions (.qvx or .qvd).

 

Watch the embedded companion video below: (YouTube (public)  / Jive (requires community login)

 

 

 

 

 

Please make sure to read the included release notes, attached to this post for your convenience.

 

Regards,

 

The QlikView Products Team

QlikView Expressor 3.10 is now generally available to customers and partners. The software and release notes can be found on the download site (http://global.qlik.com/download).

As we continue our efforts to integrate QlikView Expressor (QVE) with QlikView we’re pleased to announce a feature and maintenance release of QlikView Expressor Desktop 3.10. In addition to over 90 bug fixes and a simple name change, QlikView Expressor Desktop (previously QlikView Expressor Studio) introduces MongoDB connectivity, Datascript debugging, a new library of functions and a small set of features that increase productivity. We are always working to make QlikView Expressor more functional and intuitive, and we’re listening. If you have anything you’d like to tell us, don’t hesitate to let us know.

Please see the PDF attachment at the end of this post for detialed information and supporting resources on these features.

QlikView Expressor 3.10 Release Highlights

 

  • NoSQL Connectivity with MongoDB – PLEASE NOTE: This connectivity is available through writing the Datascript synatx. The Datascript language has been extended to include driver integration to MongoDB, a rapidly emerging NoSQL database.

  • Datascript Debugging – It is now possible to attach a Lua debugger, such as Decoda, to a running Expressor Datascript operator. This is a very exciting productivity enhancement for Dataflow developers and developers of Expressor extensions, which are also written in Datascript.

  • The DSEX Lua Library – The Datascript language has been extended with a number of additional system level functions that are especially useful when launching and including child processes to perform data processing within the Dataflow.

  • Deployment Package Publishing – The Expressor Desktop now has the ability to directly “publish” an Expressor Deployment Package to a remote destination, such as the backend server for a QlikView deployment. This eliminates some of the manual work previously needed to perform this task.

  • Copying Project and Libraries – It is now possible to make copies of Expressor Projects and Libraries, making it even easier to create new versions of existing applications and artifacts.

 

Kind Regards,

The Products Team

We are excited to announce the availability of QlikView Expressor 3.9 and the QlikView Governance Dashboard 1.0. Please access the links below for more detailed information.

 

Regards,

The Global Products Team


QlikView Expressor 3.9

 

  • Extensions SDK- The first productized version of an Expressor SDK including interfaces, wizards, tutorials, and documentation to help developers extend the functionality of the QlikView Expressor data management environment. The SDK leverages the built-in integration of the Lua programming language (branded as Datascript). The online help system contains extensive documentation for the SDK, and it includes a series of tutorial exercises to orient the Extension developer to the user interface for constructing Extension artifacts and writing the Datascript to support those artifacts.  This SDK is an important step to ensure  customers and partners the ability to develop additional connectivity and "metadata" for QlikView Expressor.

 

  • Conformance Mapping– A new metadata management feature that enables users to more easily manage their metadata definitions across projects. Specifically, users can now unify the attributes mapped to Schema fields by finding and reusing existing mappings from source fields to target attributes in the semantic model. This helps improve consistency and reduces the proliferation of unnecessary variations that can cause inconsistent results in data processing.

 

  • Advanced search capabilities– Another metadata management capability that provides dependency and impact analysis tools to users and new visibility into the relationships within data management applications.. For example, this allows a user to easily identify all dataflows that may be impacted by a change to a given schema, or to identify all schemas that are used by a given dataflow.

 

  • Multi-output Transform operator– Improves the overall efficiency and management of large dataflows that may require finer control on how data is transformed and where it resides. It enables data to be transformed and directed without the need for additional Filter operators.

 

  • The QlikView Extension is now enabled by default in all Workspaces. This eliminates the need for users to install and enable the QlikView extension within Expressor. Beginning with 3.9 the QlikView capabilities are automatically enabled.

 

Technical Brief: http://community.qlik.com/docs/DOC-4001
Software:  http://us.demo.qlik.com/download/

 

 

QlikView Governance Dashboard 1.0

 

There have been significant and beneficial updates to the QlikView Governance Dashboard since its Beta 2 release in December 2012. These updates include new KPIs, support for multi-node QlikView clusters, alert indicators, improved data lineage as well as navigation and usability improvements.

Review the Governance Dashboard 1.0 technical brief for more detail.

 

Technical Brief: - http://community.qlik.com/docs/DOC-4002
Software: - http://market.qlik.com/qlikview-governance-dashboard.html

The QlikView Governance Dashboard Beta 2 is now available on QlikMarket: http://market.qlik.com/qlikview-governance-dashboard.html

 

The Beta 2 version of the Governance Dashboard fixes a number of bugs and adds the following new features and improvements:

 

  • Session Activity Heat Map: The Statistics Sheet has a new Session Overview tab that presents a heat chart of QlikView session activity over the preceding 14 days. The heat chart makes it possible to see the most active time periods. By selecting on a specific hour cell on the heat chart, users can immediately see the sessions that were active during that hour and the users and documents that were in use.

 

heat.png

  • Publisher Task Duration and Error Reporting: The “Publisher Task Listing” on the Publisher tab of the Statistics Sheet now shows the duration for completed tasks. (Note that the new Publisher Datetime format field on the Configuration Sheet must be set to match the Publisher’s datetime format to get valid durations.) The “Publisher Task Listing” has also been improved to use red text for tasks that failed to execute. The Status field value for jobs that failed to execute begin with the word “Errors” and contains the full set of error messages scanned from the TaskResults file of the failed job.

 

task.png

  • Lineage for QlikView Expressor Dataflows: The Data Lineage Sheet contains a new Expressor source type that can be selected to easily show all sources of data used by QlikView Expressor Dataflows whose output QVX files are included in the scan. The “Sources” listing for QlikView Expressor data provides the names of all dataflow operators that contributed data to the generated QVX file. The “Processes” list provides the name of the dataflow and step within it as well as the Deployment Package and Deployment Package directory. The “Load, Select Statements” list shows the list of all queries used by the selected process or source as well as the connection parameters associated with the query.

 

lineage.png

  • User Config Variable Script: Users can now have the Governance Dashboard execute a script to define common variables to use on the Configuration Sheet. This makes it easier to use a single configured Governance Dashboard in multiple environments, such as development and test environments, by changing the variable settings in the script file rather than the Governance Dashboard itself.

 

userconfig.png

 

Regards,

 

The Products Team

Qliview Expressor 3.8.3 is now generally available for customers and partners to download at http://global.qlik.com/download. This is an update release that addresses a number of issues identified in the releases notes. This release contains an important fix for the QlikView Expressor Connector in which the connecter dialog would lock of the QlikView Desktop script editor when attempting to reference previously used QlikView Expressor deployment packages.

 

Please review the release notes for more information.

 

http://global.qlik.com/download

 

NOTE: When searching for the software ensure to use the View All / Search tab to enable the Expressor filter in the select box.

 

Please report any issues to the QlikTech Support group through the normal channels

 

Regards,

 

The Products Team

Hello Qlik Community.

QlikView Expressor 3.8 is now available on http://download.qlik.com/.

Great job by the products team!

A highlight of this release is its new parameter and configuration manager. This will allow a QlikView Expressor developer to configure parameters that can use substitutable values individually or saved as a set for configuring operator properties at run-time, simplifying the reuse of QlikView Expressor Dataflows in different environments. In addition - support for the QlikView licensing model, improvements to the schema wizards and enhancements to data source connectivity  have been added. Read on to learn more.

This release includes the following new features and enhancements:

New - Parameterization & Configuration

This is a must have core capability that simplifies the reuse of QlikView Expressor applications in different environments. It is now possible to manage and use sets of configuration values as needed to support the movement of a QlikView Expressor application through development, test, and production.

 

Click to enlarge

 

parms.png

Figure 1. QlikView Expressor Parameter Manager and Parameter setting dialogs (example shown: database connection)

 

For example, in an IT environment that has a different project lifecycle stage for DEV, TEST, and PROD, it’s now easy to create and use three sets of database connection properties (one each for DEV, TEST, and PROD). When the QlikView Expressor application is deployed in the TEST environment, it can easily be configured to run with the TEST configuration values. Configurations are managed, shared, and reused between users and projects just like all other QlikView Expressor metadata artifacts. Resolved parameters are also available through Datascript at runtime.

New - Licensing model

The old Expressor licensing implementation has been replaced with the familiar QlikView licensing model.

 

license_newPNG.PNG

Figure 2. New Licensing model dialog in QlikView Expressor Desktop


Enhanced - QlikView Expressor Connector

Stability and quality of the QlikView Expressor Connector has been improved, licensing restrictions are now enforced, and changes to support the 1.0 Beta release of the Governance Dashboard have been implemented. The QlikView Expressor Connector also supports the above method parameterization. When using the QlikView Expressor Connector as a data source in QlikView you can override the parameters that were defined in the Dataflow. Allowing the QlikView developer to substitute values for named parameters. This eliminates the need to change the Dataflow in regard to any parameter supported by the Named Parameters feature:

 

Click to enlarge

 

parm1.png

Figure 3. Override QlikView Expressor Dataflow property parameters in the QlikView Expressor Connector

 

Enhanced - QlikView and Excel extensions

  • The QlikView and Excel schema editors now allow users to add, edit, delete, and reorder fields.
  • The QlikView and Excel schema editors now allow the user to refresh/update the schema metadata from the QlikView or Excel source.
  • The QlikView and Excel New schema wizards now provide standardized file browser and object selection ability.
  • The Excel New schema wizard now provides a preview capability for the Excel sheets.

 

schema1.png

Figure 4. QlikView schema metadata data type update


excel.PNG

Figure 5. Excel Schema Wizard data preview

Enhanced - Database connectivity

 

  • QlikView Expressor 3.8 now officially supports Microsoft SQL Server 2012
  • QlikView Expressor 3.8 has upgraded to version 7 of the DataDirect database drivers

 

Regards,
Michael Tarallo
Senior Product Marketing Manager
QlikView Expressor

Filter Blog

By date:
By tag: