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 app, you can import that file into the QlikView application.

Connector Specifications

	Supported
Agent Types
Connect on-premise	X
Connect cloud
Data Replication Apps
Source
Target
On Schedule Apps
Source
Target	X
On Event Apps
Source	X
Target	X
Flows
Integration	X
Request-Reply	X
Message

Note: This Connector is available from the TIBCO Cloud™ Integration Marketplace. See Marketplace 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 Cloud™ Integration - Connect Agents for information on available agent types and how to select the best agent for your app.

Connecting To QlikView

Select Connections from the menu.
From the Connections page select Create to open the Create a connection dialog.
Select the Connector from the list to open the Connection dialog, 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 Cloud™ Integration - Connect 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 QlikView Connection.
  Note: The QlikView Connector 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 QlikView Connector 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 Cloud™ Integration - Connect agent is installed: ..\Scribe Software\TIBCO Scribe^® Online Agent n\, where n is the agent number, if you have multiple Connect 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 Cloud™ Integration - Connect app 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 flow 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 app.
The QVX file name includes the name of the associated Connection for that QlikView Connection and the entity defined in the flow. The file naming convention is:
```
 [associated_connection_name]_[entity_name].qvx.
```

Note: Before running an app using the same QlikView Connection configuration and creating a QVX file, back up the QVX file from the prior run of that app. Every time an app 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 Cloud™ Integration - Connect API Considerations

To create Connections with the TIBCO Cloud™ Integration - Connect API, the QlikView Connector requires the following information:

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

TIBCO Cloud™ Integration - Connect 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 Cloud™ Integration - Connect 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.