Connecting through Qlik Sense
Data stored in a WebI report can easily be pulled in to Qlik Sense using UniverseBridge.
Navigate to UniverseBridge
In most environments, UniverseBridge will be at the same location as your SAP BusinessObjects BOE. For example, if you go to this URL in order to access the CMC:
You will go to this URL to access UniverseBridge
Log in to SAP BusinessObjects
Select a Document
After logging in you will be taken to the 'Select a Document' tab. Select the document containing the data to be pulled in to Qlik Sense.
Choose a data provider
If there is more than one data provider available, select one.
If the "Allow Users to Selectively Refresh" is enabled on the Admin page, a check box will also be available to allow the user to refresh the document. See Custom Configuration for more information.
Selet 'Get CSV Data'
After clicking the 'Get CSV Data' button, UniverseBridge will open a new browser window that will retrieve results from SAP BusinessObjects. Copy the URL for this new window to be used in Qlik Sense.
Load CSV Data into Qlik Sense
Create a data connection to UniverseBridge using the 'Web File' dialog.
Past the URL generated by UniverseBridge to retrieve CSV data into the 'Web Files' wizard.
Select the table from the source.
Check the load script and select 'Insert Script' and 'Load data'.
NOTE: Use "MSQ" Quoting whenever possible. This is especially important when there are special characters in the data.