Cognos on SAP HANA?

[Former Member]

Hello

Any information about a possibility to operate Cognos on top of HANA?

Is it possible to use Cognos as front-end for HANA?

A.

[Vitaliy-R · Accepted solution]

Please have a look at OSS Note 1577128 - Supported clients for SAP HANA 1.0. Only SBO BI 4.0, BO 3.1 WebI, and MS Excel are supported clients for HANA 1.0.

[Former Member · Accepted solution]

We have sucessfully tested a cognos to HANA connection and we will do further tests in the next 3 weeks

[joseph_gonzales · Accepted solution]

Hello Brave Tester:

Please comment on your continues testing of COGNOS with SAP HANA.

Please comments on the version of both COGNOS and SAP HANA.

Is this connection using MDX or SQL?

Thank you,

Joe G.

856 912 1136

[Former Member · Accepted solution]

Joe ,

We can use jdbc connectivity to connect to Cognos ( or any other reporting tool which uses jdbc) . However, this is not supported by SAP . copy the Njdbc.jar file ( you can find in hdb client) to the reporting tool destination. but you are on your own if you run into any issues as these are not certified clients . we were able to test this connectivity using spot fire but we havent implemented this to production

Thanks,

Kiran .

[joseph_gonzales · Accepted solution]

Kiran:

Thank you for your update, I truely appreciate it.

Regards,

Joe G.

856 912 1136

[Former Member · Accepted solution]

Has anyone got Cognos to connect to HANA One using a custom defined data source on Linux?

[Former Member · Accepted solution]

Do you have more details. We are attempting this as well using 10.2. Are you using Hana to for the content store? Or as a datasource? If as a data source, how did you do the initial setup?

[deepanwitadesarkar]

This message was moderated.

[Former Member]

Further to Pierre's reply, the latest release of Cognos BI 10.2.1 includes SAP HANA support.

See here for a full list of supported data sources

http://pic.dhe.ibm.com/infocenter/prodguid/v1r0/clarity-reports/report/html/prereqsForProduct?delive...

[rama_shankar3]

Thanks Tina!

Is Cognos going to get SAP certification for HANA or is it as past where usage is at customer's own risk?

Rama

[Former Member]

Hi Rama,

IBM Cognos is investing in obtaining HANA Certification. The certification itself does not encompass simply access,  other areas of integration are required such as security providers, etc...  which takes some time. It should be understood that connectivity through JDBC leverages straight SQL and IBM Cognos follows SAP's own syntax documentation. As with any other access and challenges, SQL can be isolated and parsed through HANA Studio should issues arise to present cases to SAP.

[former_member419478]

Hi Pierre,

do you have any updates on the certification prozess of HANA as a database below Cognos?

Thanks for your help

Olly

[Former Member]

Hi Oliver,

No ETA at this time. I will update as soon as I have some news. Thanks for you patience.

Pierre

[Former Member]

Hi,

If you caught Hasso Plattner's onstage presentation at SAP Sapphire 2013, you may have seen Cognos linked to SAP HANA on one of the slides. While not yet SAP certified, IBM Cognos has recently released support for HANA JDBC, see the following link:

http://www.ibm.com/support/docview.wss?uid=swg21636924

Pierre

[Former Member]

Thanks for the update. But do note that this update is only for Windows. Linux update is not yet available...

[Former Member]

Correct Keith. Other platforms coming very soon.

[Former Member]

Hi Kiran,

Can you please share where(folder path) did you paste the ngdbc.jar file in Cognos server?

Normally for BO Explorer this file need to be placed in

BI4_INSTALL_PATH\SAP BusinessObjects Enterprise XI4.0\dataAccess\connectionServer\jdbc\drivers\newdb

and then in

BI4_INSTALL_PATH\Explorer14.0\plugins\com.sap.ngdbc_1.0.0\lib

Regards,

Balaji S