TIBCO Scribe® Online Connector For QlikView

The TIBCO Scribe® Online Connector for QlikView™ allows you to create QlikView QVX Files from other data sources, such as Dynamics CRM, Salesforce, or HubSpot. After you create the QVX file using an Integration or Migration Solution, you can import that file into the QlikView application.

Connector Specifications

	Supported
Agent Types
On Premise	X
Cloud
Replication Services
Source
Target
Integration Services
Source
Target	X
Migration Services
Source
Target	X
Maps
Integration	X
Request-Reply	X
Message

Note: This Connector is available from the TIBCO Scribe® Online Marketplace. See Marketplace TIBCO Scribe® Certified Connectors for more information.

QlikView Requirements

To use the TIBCO Scribe® Online Connector for QlikView, you need:

A QlikView Professional or Enterprise account. For more information, see the QlikView website.
Read and write access to the target path to the QVX file. This can be a local or a network path.

Selecting An Agent Type For QlikView

Refer to TIBCO Scribe® Online Agents for information on available Agent types and how to select the best Agent for your Solution.

Connecting To QlikView

From the Connections page, click New to open the Manage Connections: Create dialog box.
Select QlikView from the Type drop-down, and then enter the following information:
- Name — This can be any meaningful name, up to 25 characters.
- Alias — An alias for this Connection name. The alias is generated from the Connection name, and can be up to 25 characters. The Connection alias can include letters, numbers, and underscores. Spaces and special characters are not accepted. You can change the alias. For more information, see Connection Alias.
- Associate With Connection — An existing TIBCO Scribe® Online Connection. The TIBCO Scribe® Online Connector for QlikView retrieves the metadata produced by the associated Connection for generating the QVX file.
  Note: If, at any time, there are schema changes in the associated Connection, reset the metadata for the associated Connection, then reset the TIBCO Scribe® Online QlikView Connection.
  Note: The TIBCO Scribe® Online Connector for QlikView comes with QlikView Sample Metadata that you can use as an associated Connection to create QVX files for the QlikView trial process. This is only a sample schema intended to illustrate how the TIBCO Scribe® Online Connector for QlikView can be used for a business use case. Entities in the sample metadata cannot be modified.
- QVX Target Path — Location where the generated QVX file is stored. By default, this location is: .\DataExchange.
  The default directory path, \DataExchange\, is located under the default directory on the computer where the TIBCO Scribe® Online Agent is installed: ..\Scribe Software\TIBCO Scribe® Online Agent n\, where n is the Agent number, if you have multiple On-Premise Agents installed.
  You can specify an absolute, relative, or UNC path name. The relative path is relative to the ..\TIBCO Scribe® Online Agent n\ folder.
  Note: You cannot specify a mapped drive letter in the path name.
Select Test Connection and verify that the Agent can connect to your QlikView Organization. Be sure to test the connection against all Agents that use this connection. See Testing Connections.
Select OK/Save to save the Connection and close the Manage Connections: Create (or edit) dialog box.

QVX Files

QVX files contain metadata that describes a table containing data, as well as the actual data in that table. These files, which are in a public format, are formatted for high-performance output to QlikView.

When you run a TIBCO Scribe® Online Solution that creates a QVX file:

Any source Connection can be used to create a QVX file.
The QlikView Connection displays only target operation Blocks on the Map workspace because it can only be used as a target Connection.
A QVX file is created in the directory specified as the target path for the QlikView Connection used in this Solution.
The QVX file name includes the name of the associated Connection for that QlikView Connection and the entity defined in the Map. The file naming convention is:
[associated_connection_name]_[entity_name].qvx.

Note: Before running a Solution using the same QlikView Connection configuration and creating a QVX file, back up the QVX file from the prior run of that Solution. Every time a Solution is executed using the same QlikView Connection configuration the file created by any prior execution using that configuration is overwritten.

Note: The QVX file can be opened or imported into either the Personal or Server Edition of QlikView.

TIBCO Scribe® Online API Considerations

To create Connections with the TIBCO Scribe® Online API, the QlikView Connector requires the following information:

Connector Name	QlikView
Connector ID	E84D9C4E-9771-47f8-88B1-CF475F5116D3

TIBCO Scribe® Online Connection Properties

In addition, this Connector uses the Connection properties shown in the following table.

Note: Connection property names are case-sensitive.

Name	Data Type	Required	Secured	Usage
Associate with Connection	Drop-down	Yes	No	Uses an existing TIBCO Scribe® Online Connection for QlikView retrieve the metadata
QVX target path	String	Yes	No	Location where the QVX file is stored.

More Information

For additional information on this Connector, refer to the Knowledge Base and Discussions in the TIBCO Community.