BI SDK XMLA Connector SSO

[Former Member]

Hello Colleagues,

i would use the SAP BW XMLA Connector from the BI SDK for retrieving data from an BW System. In the moment i must use Usermapping for Logon to the BW. But i would use SSO via SAP Logon Tickets.

In the properties from the BW_XMLA Connector i cant choose SAPLogontickets for logon.

Usermapping for evry user is to complicate for evry user. How can i logon the users to the BW system with the SAP Logon Tickets?

Best Regards,

Patrick

[Former Member]

I also tried to upload the whole wip files, but I get following dependencies error message:

Unresolved dependencies found for the following SDAs:

1.: development component 'com.sap.ip.bi.sdk'/'sap.com'/'SAP AG'/'350.20041117103035.0000'

dependency:

name: 'bi/mmr/core'

vendor: 'sap.com'

dependency:

name: 'bi/mmr/db'

vendor: 'sap.com'

dependency:

name: 'bi/mmr/cwm_1.0_library'

vendor: 'sap.com'

dependency:

name: 'bi/mmr/jmi'

vendor: 'sap.com'

Deployment will be aborted.

Any suggestion?

Thank you!

[Former Member]

Hello all,

i have now the connector successfully running.

We deploy the complete udi and mmr package to use the xmla connector on the portal WAS. After this great success i run in the next problem. I cant get an SSO connection from webdynpro.

As start i use the BI SDK for Webdynpro Tutorial.

My program stops at this line:

connection =
(IBIConnection) connectionFactory.getConnectionEx(null);

The Exception only contains the helpful information "Cannot open the connection" and nothing else. When i take a look in the connection factory with the debugger object i see the parameters that we entered in the web application server visual administrator.

In the how to guide of the XMLA Connector was a reference to "make SSO for the J2EE engine". We make already SSO for the SAP Portal that runs on this server. Is this enough? I think the certificates of the Portal and the J2EE engine are the same.

Best regards,

Patrick

[former_member183850]

Hi,

to configure the BI XMLA connector for SSO, please check the following settings:

1, setup SSO between BW and J2EE (do it both ways: export certificate from J2EE, imported into BW; and vice versa)

2, your web dynpro application (or other J2EE application) should be configured to issue a ticket: check in the security provider service of J2EE.

3, BI XMLA connection property 'LOGONMETHOD' should have value 'SAPLOGONTICKET'.

If there is still problem, check the defaulttrace log file, maybe there are some useful information.

best regards,

Shan

[Former Member]

Hi,

yeah, it works now :-).

The reason was a problem with the connected system. This system had a broken system pse.

An other problem was -i think- that the example code in the bi SDK does not call the connection.close() method. So there where to many connections open and sometimes the connection pool gets overflowed.

Best regards,

Patrick

[Former Member]

Hi All, Seems like you guys have tried exporting XML data out of BW. I have a scenario where I wanted to get a subset of data from a cube and export that data out of BW in XML format and use that xml data to feed gauges in portal. Kindly provide steps as to how can I achieve this.

I learnt that you can use XMLA and do this, but nowhere I can find detailed steps to follow, I am unable to link the relation between setting up SOAP web service, creating MDX query and generating XML data and passing that data to portal.

Does anyone have detailed step by step for implementing XMLA to export xml data. Kindly help!

PK

[Former Member]

Hello!

I have the same kind of requirements for the application I'm working on. It's a webdynpro displayed inside the portal and displaying some BW query results. I found the zip file and downloaded it. I assume I have to deploy some archive using SDM but I don't know which of them and how exactly I should do it in the SDM. Did you get it deployed? Was you able to do SSO to BW? I tried to deploy some sda files (sap.com_bimmr_{bi_4.0.sda, sap.com}bi_mmrbrowser_ea.sda and sap.com_bimmr~cwm_1.0_source.sda) but I get an error durring deployment. Did I deploy the right files ?

Thank you...

[Former Member]

Hello Patrick,

with SP11 will be a new connector delivered bi_sdk_xmla_proxy.rar with JNDI name SDK_XMLA_PROXY. This can you configure for SSO. With SP12 the two existing XMLA connectors will merge to one. After that the LOGONMETHOD Connector Property will be available.

reg.

michael

[Former Member]

Hello Michael,

thanks for your answer. But now i have an other question.

Where can i get the new connector SDK_XMLA_PROXY? It is already installed when i patch to sp11? Must i download it and install manually?

Best regards,

Patrick

[Former Member]

Hi Michael,

please give me an answer. I didnt found it.

Best regards,

Patrick

[Former Member]

Patrick,

all of the development components are compressed available in SCA

(Software Component Archive).

This is available for each Support Package on the Service Marketplace Marktplatz.

Fpr SP12 it is BIUDI12_0-20000143.sca

reg.

Michael

[Former Member]

Hi Michael,

thank you very much. I found it.

Best regards,

Patrick