on 03-11-2015 8:18 AM
Hi
We already installed HANA database on the db server as MDC (multi-tenant database container) and want to connect BO 4.1 SP5 to HANA DB using OLAP connection but it is giving error (BO_CONN_ERROR) like failed to get connection.
We have followe SAP note 1779252
We dont have any firwall blocking this port as I am able to connect from HANA studio installed.
Also able to connect through IDT using JDBC driver to SAP HANA Database 1.0 .
BO server OS: Windows server 2012
HANA Database OS : Linux
HANA DB Version: HANA 1.0 Revision 93 (MDC)
Hello S. Das
It seems we have recently become aware of this limitation. The AOLAP connection to HANA asks for an instance number and it then connects to the HANA server on port "3<instance_number>15".
But in multi-tenant scenarios the port number changes.
However, I've just seen a related post on another thread from a colleague and it looks like there is a solution.
In the CMC edit the HANA connection and post fix the server name with the tenant port.
For example, in the "Server" textbox instead of "myhanaserver" you have "myhanaserver:30099;" where "30099" is your tenant port.
***Important... note the semicolon at the end***
Please feedback if that works for you.
Kind Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Has anyone been able to get this to work with HANA/BIP SAML SSO?
Using the technique above (<server>:tenant_port;), we can successfully create a BIP OLAP connection using a hardcoded ID and password. However, using the same trick does not work using SSO as the connection authentication type. Note that SAML SSO to the primary HANA tenant works fine (port 30015), but it does not work to a secondary tenant. Any suggestions would be appreciated!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.