Explorer connecting with HANA using JDBC connection

[Former Member]

Hi

May be its repeat of below post.

but i did not see the answer for Explorer and HANA native connection. so i am posting again.

I am trying to connect Explorer4.0 with HANA SP3 Database using JDBC native connection.

I am not using IDT and connection wizard settings.

1)Under connection serverjdbc directory which SBO file should i have to change?I am not working on Maxdb, why should i change maxdb.sbo file? should i have to use JDBC.sbo(Generic datasource) file?

I changed as follows in maxdb.sbo file too but connection (SAP HANA) 1.0" is not shown in "manage Source" of Explorer.

</DataBase>
	<DataBase Active="Yes" Name="SAP HANA database 1.0">
	  <Aliases>
        <Alias>SAP High-Performance Analytic Appliance (SAP HANA) 1.0</Alias>
      </Aliases>
      <JDBCDriver>
        <ClassPath>
            <Path>C:Program FilesSAPhdbclient
gdbc.jar</Path>
        </ClassPath>
        <Parameter Name="JDBC Class">com.sap.db.jdbc.Driver</Parameter>
        <Parameter Name="URL Format">jdbc:sap://$DATASOURCE$</Parameter>

2)Also I did below changes at CMC

-Right-click "Explorer", and select "Properties".

-Within "Advanced Configuration", set the following parameters, and save them.

newdb.system.alias = DBHANA
newdb.url = jdbc:sap://XXXXXX:30015
newdb.authentication.mode = ConfiguredIdentity    
newdb.user = system <Hana System userid>
newdb.password = xxxxxxxxx <Hana System password>
newdb.connections.enabled = true

※Why all files starting with newdb.xxx i dont understand. does the above setting is correct?

3)Return to CMC's home screen, and click "Users and Groups".

4)Click "User List", right-click on "Administrator", and select "Properties".

5)Check "Enable Database Credentials", and enter HANA database user id and Password(not an administrator password), and save them.

6)but "SAP High-Performance Analytic Appliance (SAP HANA) 1.0" is not shown in "Sources".

Ofcourse finally, restarted Explorer service to see the HANA connection but no use.

Pls advice.

Regards

magalingam

[hai_murali_here · Accepted solution]

Hi,

Please follow the below procedure for the native HANA Connection in Explorer

1.Install HANA Client on BI 4.0 Server

2.Locate the JDBC driver

The default HANA client install folder locations (in Windows):

64-bit Client install: /program files/sap/hdbclient

32-bit Client install: /program files (x86)/sap/hdbclient

Locate the JDBC driver file: ngdbc.jar

3.Setting at BI4 connection server

Copy ngdbc.jar from previous step to:

BI4_INSTALL_PATH\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\newdb

(create newdb folder if required)

Restart the BI4 Adaptive Processing Server in CMC

4.Setting at BI4 Explorer server

Stop Tomcat server where BI4 Explorer is deployed.

Copy the same ngdbc.jar and replace the jar in: BI4_INSTALL_PATH\Explorer14.0\plugins\com.sap.ngdbc_1.0.0\lib

Restart Tomcat server

Rgds,

Murali

[Former Member · Accepted solution]

Great Murali

It works. Thanks

[Former Member]

Hi,

I am trying to connect BO Explorer with HANA using JDBC connection. I have created a relational connection in IDT and test connection is successful. I can even see the tables within the schemas available in HANA box.

When I login to BOExplorer I am unable to find the HANA connection/view as sources under Manage spaces in explorer. I have already followed the below steps and the client drivers are also the latest(does match with Hana DB version)

Stop Tomcat server where BI4 Explorer is deployed.

Copy the same ngdbc.jar and replace the jar in: BI4_INSTALL_PATH\Explorer14.0\plugins\com.sap.ngdbc_1.0.0\lib

Restart Tomcat server

Please advise. I have even tried logging in as administrator for BO explorer and using HanaDB user as SYSTEM itself. Still doesn't work.

[Former Member]

Also there was a new option while defining properties as shown below

[Former Member]

Hi All,

I have a quick question is it necessary to create a jdbc connection and place jar file? or is to add the parameters

newdb.system.alias = DBHANA

newdb.url = jdbc:sap://XXXXXX:30015

newdb.authentication.mode = ConfiguredIdentity   

newdb.user = system <Hana System userid> Should this be admin or any user id

newdb.password = xxxxxxxxx <Hana System password>

newdb.connections.enabled = true

directly to application explorer and make it work without the connection.

Any response is appreciated!

Thanks,

Pranay S

[Former Member]

You no longer have to struggle with those steps. Follow these it will work. You can use any user to connect.

1.Install HANA Client on BI 4.0 Server

2.Locate the JDBC driver

The default HANA client install folder locations (in Windows):

64-bit Client install: /program files/sap/hdbclient

32-bit Client install: /program files (x86)/sap/hdbclient

Locate the JDBC driver file: ngdbc.jar

3.Setting at BI4 connection server

Copy ngdbc.jar from previous step to:

BI4_INSTALL_PATH\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\newdb

(create newdb folder if required)

Restart the BI4 Adaptive Processing Server in CMC

4.Setting at BI4 Explorer server

Stop Tomcat server where BI4 Explorer is deployed.

Copy the same ngdbc.jar and replace the jar in: BI4_INSTALL_PATH\Explorer14.0\plugins\com.sap.ngdbc_1.0.0\lib

Restart Tomcat server

Regards,

Balaji

[Former Member]

hi,

while configuring HANA via explorer, i have done following steps. But still not able to see in explorer

newdb.system.alias = DBHANA

newdb.url = jdbc:sap://XXXXXX:30015

newdb.authentication.mode = ConfiguredIdentity   

newdb.user = system <Hana System userid> Should this be admin or any user id

newdb.password = xxxxxxxxx <Hana System password>

newdb.connections.enabled = true

also, procedure for the native HANA Connection in Explorer as stated by Muralikrishnan has been followed but no luck. Any suggestions?

[former_member182277]

Hi,

1. Have you installed the SAP HANA Client on your system.

2. If yes, goto C:\Program Files\SAP\hdbclient and copy the ngdbc.jar file

3. Now, goto C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers, create a new folder naming with newdb and paste the ngdbc.jar file in the newdb folder.

Please find the below link for the same

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_exp_admin_en.pdf

Hope it is helpful.

Regards,

Neha