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 of 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

Follow the steps below 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 can now be assigned to extractions.

Destination Details

The destination details define the connection to the destination. To use the QlikSense & QlikView destination, no further settings are necessary.

Assign the QlikSense & QlikView Destination to an Extraction

Extractions write data to their assigned destination. Follow the steps below 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 a destination from the drop down menu.
   
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 type 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 style of the column name. Following options are available:

Convert dates

Converts the character-type SAP date (YYYYMMDD, e.g., 19900101) to a special date format (YYYY-MM-DD, e.g., 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

Follow the steps below to generate a data load script in Xtract Universal. The data load script is required to run extractions in your Qlik application.

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.
   

When using QlikView, paste the copied script into the QlikView data load editor. For QlikSense, see Run Extractions from QlikSense.

Run Extractions from QlikSense

Before copying the Qlik script generated by Xtract Universal to QlikSense, perform the following steps in QlikSense:

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.
   

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.