Integrating Qlikview App with Java Application

[kiranb13]

I have a Custom portal where MicroStrategy and Cognos reports are launched from. I want to integrate Qlikview reports into the Custom Portal.

For MicroStrategy and Cognos i have the metadata of the  report id, report path, report type, report roles and specification of the of users based on the category. This MetaData is pulled into the portal database so that if a user clicks on the report the report should run with credentials as Single Sign on with the intranet ID.

Coming to the portal, Portal consists of an Admin Page to allocate the reports and categorise them, this has filters and one of them will be Qlik Reports. The Admin Portal is where the user pulls all the data about the user roles and allocates them specific reports.

As I have done with Cognos (Cognos SDK) and Microstrategy ( MicroStrategy SDK), I have to do a similar integration with Qlikview. Could you recommend the best way to do this integration, taking into consideration performance aspects as well.

Appreciate and thank you in advance for your recommendations.

[rwunderlich · Accepted solution]

You'll want to use the QMS API. It's SOAP.

https://help.qlik.com/en-US/qlikview-developer/12.1/Content/APIsAndSDKs.htm

-Rob

[kiranb13]

Hi Rob,

Please let me know how to solve the below issue as i am getting the below error. We are calling QMS API using Java API.

>>wsimport -keep -p com.measureit http://<server>:4799/QMS/Service

parsing WSDL...

[WARNING] src-resolve.4.2: Error resolving component 'xs:schema'. It was detecte

d that 'xs:schema' is in namespace 'http://www.w3.org/2001/XMLSchema', but compo

nents from this namespace are not referenceable from schema document 'http://<server>:4799/QMS/Service?xsd=xsd11'. If this is the incorrect namespace, pe

rhaps the prefix of 'xs:schema' needs to be changed. If this is the correct name

space, then an appropriate 'import' tag should be added to 'http://<server>:4799/QMS/Service?xsd=xsd11'.

  line 1 of http://<server>:4799/QMS/Service?xsd=xsd11

[WARNING] src-resolve: Cannot resolve the name 'xs:schema' to a(n) 'element decl

aration' component.

  line 1 of http://<server>:4799/QMS/Service?xsd=xsd11

[ERROR] undefined element declaration 'xs:schema'

  line 1 of http://<server>:4799/QMS/Service?xsd=xsd11

[kiranb13]

Hi Anil,

Is there any way to get QMSAPI package for Java ?

[rwunderlich]

There is no package to install. You interact with the QMSAPI via HTTP/SOAP just as you would any webservice.

-Rob

[kiranb13]

Hi Rob,

Please let me know whether QMS API is compatible with Java. As we seeing schema errors while accessing QMS API Our main goal is to call QVW file into Java Application.

We are using QMS API for pulling metadata for the QVW and opendoc.htm for pulling the QVW. When the user logs into the Java application he will be able to navigate to the qlikview report within an iframe

[rwunderlich]

Hi Kiran,

If you search the forums you'll find that other users have had trouble using the supplied WDSL with java. I believe someone posted a workaround but I'm not sure.

-Rob