QlikView File - Import - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

Bridge Requirements

This bridge:
  • is only supported on Microsoft Windows.

  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor QlikTech
Tool Name QlikView
Tool Version 11.2 to 12.x
Tool Web Site http://www.qlik.com/us/products/qlikview
Supported Methodology [Business Intelligence] BI Report (Relational Source, Expression Parsing, Report Structure) via COM API on QVW or QVD File
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: QlikTech QlikView 11.2 to 12.x (http://www.qlik.com/us/products/qlikview)
Import interface: [Business Intelligence] BI Report (Relational Source, Expression Parsing, Report Structure) via COM API on QVW or QVD File from QlikView File Import bridge: 'QlikView' 10.1.0

This bridge imports reporting metadata from QlikView documents.
The bridge requires the QlikView software and its COM/OLE API to be installed on the machine that is executing this bridge.

Please ensure that the needed file is available, and consult the Miscellaneous parameter documentation for additional information.

As connectivity to the API is through COM based automation, please be sure to close all QlikView instances and check the Task Manager to confirm there are no QlikView processes running, as these may interfere with the startup of a new process.


FREQUENTLY ASKED QUESTIONS

Q: What do I do if the bridge appears to stop processing for a long time with no log messages after 'Connected to QlikView version xx.xx.xxxxx.x'?
A: Pop-up dialog issue: As connectivity to the API is through COM based automation, the import may be blocked because a dialog message may have been issued by QlikView and it is awaiting a response. In order to address this issue, you must look for windows in the background that would be the dialog requiring user attention. In some case, e.g., if the bridge is executed as a service rather than directly as an application, in order to ensure that you see this message, you will need to re-run the bridge as a full application rather than a service.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File File path of the QVW document or QVD file to import. When importing a QVW document its execution log should be located next to it. FILE
*.qvw
*.qvd
  Mandatory
Miscellaneous Specify the following miscellaneous options using a comma separated string:
- ODBC connection database type
- Replace DIRECTORY statement
- Require QVW execution log


ODBC connection database type
When QlikView connects to a database using ODBC the database type is unknown. It is necessary to understand lineage through database specific SQL syntax.
Specify default database type using DatabaseType string (e.g. 'DatabaseType=Oracle'). When the QlikView application connects to different database types, you may specify each type using the associated connection name (e.g. for 'ODBC CONNECT TO ConnectionName' use 'DatabaseType:ConnectionName=Oracle'). It is possible to mix the default database type with connection database types (e.g. 'DatabaseType=Oracle, DatabaseType:ConnectionName= TERADATA').

Here is a list of major supported database type:
ORACLE
SQL SERVER
DB2
TERADATA
SYBASE
GREENPLUM
NETEZZA
POSTGRESQL
MYSQL
HIVE
ACCESS


DIRECTORY statement
A QlikView DIRECTORY statement is used to set the Directory path for subsequent LOAD statements. When this directory is inaccessible use a DIRECTORY statement to redirect it to another directory.
To do so, copy the DIRECTORY statement from a QVW file log, add '=' and specify the path to another directory.
Example:
DIRECTORY [c:\folder1]=[d:\folder2]
In this case, folder 'c:\folder' is redirected to 'd:\folder2' folder.

When the path after the DIRECTORY statement is empty, all DIRECTORY statements are redirected to the specified directory.
Example:
DIRECTORY []=[d:\folder2]


QVW execution log
The QVW script execution logs are employed to understand what tables QVW files use and to determine the lineage to their sources (e.g. QVD or database). When the log is not available an error message is logged. If the QVW script execution log is not required, one may specify 'RequireLog=no'.
Note: when a log file is missing, its original script is used. In this case, some or all metadata details could be lost as scripts are dynamic because of loops, subroutines, variable definitions.

For example, the following will set the default database type to Oracle, asks to not require logs and redirects all DIRECTORY statements:
'DatabaseType=Oracle, RequireLog=no, DIRECTORY []=[d:\folder2]'

FILEPATH
QlikView's Include, Store, Load statements operate with file path. When the original file path is not accessible by the bridge it logs errors, like:
'Unable to open Include file: '\\inaccessible\scripts\include.txt''
'Could not process the dependency because the source document '\\inaccessible\QVDs\file.qvd' is not accessible'

You can resolve the errors by copying inaccessible files to accessible paths.
For example, when necessary files are located in \\inaccessible\folder you can copy them to c:\accessible\folder and instruct the bridge to read them from the new location with:
FILEPATH [\\inaccessible]=[c:\accessible]

The FILEPATH option allows you to replace a portion of the original file path with a new one.

You can specify multiple FILEPATH options, like:
FILEPATH [\\inaccessible]=[c:\accessible], FILEPATH [\\inaccessible2]=[c:\accessible2]

The bridge applies multiple FILEPATH options in order provided.
WRONG - FILEPATH [\\a]=[c:\a], FILEPATH [\\aa]=[c:\aa]
RIGHT - FILEPATH [\\aa]=[c:\aa], FILEPATH [\\a]=[c:\a]

Be sure not to specify the FILEPATH be outside of the Directory path where you have the QlikView documents you would like to import.
STRING      
Close after execution Close the QlikView application after importing the document. By default the tool will be closed.

'False' - The application is left open on the desktop after the bridge has run.
'True' - The application is closed after the bridge has run.

Note that the application is started on the same machine where this bridge is running.

If running this bridge remotely on a distant server, this parameter should be set to 'True', otherwise the application will be left running on the server.
BOOLEAN   True  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"QlikView File"
Metamodel
QlikView (QVW)
Mapping Comments
     
Attribute Source Column  
Comment Comment  
Description Definition  
DesignLevel Design Level  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Class Source Table  
Name Name  
ConnectionPackage Connection Schema  
Name Name  
DesignPackage Tables  
Name Name  
Dimension Table  
Description Description  
Name Name  
NativeId Native Id  
NativeType Native Type  
DimensionAttribute Column  
Comment Comment  
Description Definition  
DesignLevel Design Level  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Filter Condition  
Name Name  
Measure Measure  
Comment Comment  
Description Definition  
DesignLevel Design Level  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Report Document  
Name Name  
ReportAttribute Field, Group, System Variable, Variable, Expression, System Field  
Name Name  
ReportAxis Axis  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportChart Slider, Chart  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportDataSet Variables, Fields, Groups, System Variables, Expressions, System Fields  
Name Name  
ReportField Text Field, Button Field  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportList List Box  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportMatrix Pivot Table  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportPage Sheet  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportTable Straight Table, Statistics Box, Table Box, Search Object, Input Box, Multi Box  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
ReportText Text Box, Button Text  
Description Definition  
Name Name  
NativeId Native Id  
Position Position  
Value Value  
StoreConnection Connection  
Name Name  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
StoreModel QVW Model  
Name Name  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type