QlikSense & QlikView

This page shows how to set up and use the QlikSense & QlikView destination. The QlikSense & QlikView destination loads data to QlikSense or QlikView.

About

The QlikSense & QlikView destination generates a data load script, that needs to be inserted into the data load editor of your Qlik application. Depending on whether you run a QlikSense or QlikView application, Xtract Univeral creates a different data load script.

Running the Qlik application triggers the respective Xtract Universal extraction via the data load script. Xtract Universal sends the extracted SAP data through an HTTP-CSV stream directly to your Qlik application.

Create a new QlikSense & QlikView Destination

To add a new QlikSense & QlikView destination to Xtract Universal:

1. In the main window of the Designer, navigate to Server > Manage Destinations. The window “Manage Destinations” opens.
   
2. Click [Add] to create a new destination. The window "Destination Details" opens.
   
3. Enter a Name for the destination.
4. Select the destination type QlikSense & QlikView from the drop-down menu. A list of connection details opens.
5. Fill out the destination details to connect to the destination.
6. Click [OK] to confirm your input.

The destination is added to the list of available destinations.

Destination Details

The destination details define the connection to the destination. For information on how to restrict access to the connection settings, refer to Access Management.

To use the QlikSense & QlikView destination, no configuration is required.

Assign the QlikSense & QlikView Destination to an Extraction

Extractions write data to their assigned destination. To assign a destination to an extraction:

1. In the main window of the Designer, select an extraction.
2. Click [ Destination]. The window “Destination Settings” opens.
   
3. In the “Destination Settings” window, select your QlikSense & QlikView destination from the dropdown list.
   
4. Optional: edit the destination settings.
5. Click [OK] to confirm your input.

When running the extraction, the extracted SAP data is now written to the destination.

Destination Settings

The destination settings only affect the extraction that the destination is assigned to. To open the destination settings, select an extraction in the main window of the Designer and click [ Destination]. The window "Destination Settings" opens.

Column Name Style

Defines the format of the column name. The following options are available:

Convert dates

Converts the SAP date format (YYYYMMDD) to a regular date format (YYYY-MM-DD), e.g., 19900101 becomes 1990-01-01. Target data uses a real date data-type and not the string data-type to store dates.

Year 0

Converts the SAP date 00000000 to the entered value.

Year 9999

Converts the SAP date 9999XXXX to the entered value.

Invalid values

If an SAP date cannot be converted to a valid date format, the invalid date is converted to the entered value. NULL is supported as a value. When converting the SAP date the two special cases 00000000 and 9999XXXX are checked first.

Generate a Data Load Script

A data load script is required to run extractions in your Qlik application. To generate a data load script in Xtract Universal:

1. In the main window of the Designer, select an extraction from the list of extractions.
2. Make sure the extraction has the QlikSense & QlikView destination assigned to it.
3. Click [Run]. The window "Run Extraction" opens.
   
4. Optional (when using QlikSense): In the Parameters section, mark the check boxes for the parameters that you want to add as SET variables in the QlikSense script.
5. Click [Generate Qlik Script] to generate a data load script. The window "Script" opens.
6. Select the QlikView Script or QlikSense Script tab.
7. Click [Copy to Clipboard] to copy the script.
   

The data load script is generated and ready for use in Qlik applications.

Run Extractions from QlikSense

To configure QlikSense to use the Qlik script generated by Xtract Universal:

1. Create a new data connection of type REST.
   

   Note

   In QlikSense the default value for the Timeout is 30 seconds. Increase the timeout to a sufficiently high value if the time till the first data package arrives from SAP is higher than 30 seconds. The maximum input value is 10.000 seconds.

2. Enter the URL of the Xtract Universal Server and port into the URL text field. In the depicted example, the Xtract Universal server runs on http://localhost:8065/.
   

3. Enter Xtract_Universal into the name text field.
4. Activate the security option Allow response headers. This option ensures that error messages from Xtract Universal are passed to QlikSense.
   
5. Paste the QlikSense script from Xtract Universal into the QlikSense Data load editor.
   

The Xtract Universal REST connection in QlikSense is ready to use.

About the QlikSense Data Load Script

Xtract Universal creates a QlikSense script with the following properties:

• The script uses QlikSense interpretation functions Num#, Text, Date and Time. For fields, where an adequate data type can't be determined, no interpretation function is used.
• The field description and the SAP origin of the field are assigned as tags to all fields.
• All date fields with $date are explicitly tagged. This function assures that fields containing a date before January 1, 1980 are recognized as date fields in QlikSense.
• The usage of Xtract Universal Extraction Parameters is supported. To make parameters available in the QlikSense script, activate the parameters in the "Run Extraction" window of Xtract Universal.