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:

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

  1. From the Connections page, click New to open the Manage Connections: Create dialog box.
  2. 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 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.

  3. 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.
  4. Select OK 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:

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.