cancel
Showing results for 
Search instead for 
Did you mean: 

Blue Prism Connection to HANA Database

Vikash011
Staff
Staff
Hi All,

In my current project we have a requirement to connect the HANA DB and run the select query and capture the result. Can you please guide me how to complete this connection setup.

------------------------------
Vikash Anand
Application Development Team Lead
Accenture
------------------------------
8 REPLIES 8

PabloSarabia
Level 11
Hi,

I look for an Asset in the Digital Exchange platform and I didn't found the connector.

If you are familiarized with C#, here you have a full guide of to connect directly with SAP HANA Data Base

https://www.kodyaz.com/visual-studio/connect-to-sap-hana-database-using-odbc-sample-code.aspx

Unfortunately I don't have an instance of this kind of data base to test this in detail, sorry 😞


Hope this helps you!

See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------

@PabloSarabia Thanks for the link provided. Will explore this above option.​

------------------------------
Vikash Anand
Application Development Team Lead
Accenture
------------------------------

hi Vikash,

Can you please share the steps to connect Bluerprism with HANA DB.
Also please help with additional driver we need to install.
This would be of a great help.

Thanks

------------------------------
Bhanu Challa
------------------------------

That's a good information.
The SAP HANA database also supports ODBC connections.
Consequently, Blue Prism seems to be able to connect using the Connector for ODBC Utility.
The imported VBO name is Data - ODBC.
However, the system setup process may be complicated because the proprietary HDBODBC driver needs to be installed first.

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------

Hi Bhanu,

We were able to set the connection between HANA and BP by following below steps.

First step was to install the HANA Application. This package usually will include the HANA ODBC drivers as well.
Read : https://www.kodyaz.com/visual-studio/connect-to-sap-hana-database-using-odbc-sample-code.aspx

Once the Studio, Client and the HANA ODBC Drivers are installed we can go ahead and try to establish the connection to the HANA DB.

We were able to establish connection to the HANA DB using Powershell Script.

This below code will establish a connection and a query is passed where we are getting the data from a sample DB and the output is saved as a txt file.


$conn = new-object System.Data.Odbc.OdbcConnection

$conn.connectionstring = "DSN=HDBODBC;UID=USERNAME;PWD=PASSWORD;SERVERNODE=abcxxxxx.xx.xx.xxxxx.com:xxxxx;DATABASENAME=DataBaseNAME"

$conn.Open()

$result =(new-Object Data.Odbc.OdbcCommand("select * from DATA_TYPES",$conn)).ExecuteReader()

$table = new-object "System.Data.DataTable"

$table.Load($result)

$table | Out-File C:\RPA\output.txt

$conn.close()

Hope this help you!

Thanks,
Vikash

------------------------------
Vikash Anand
Application Development Team Lead
Accenture
------------------------------

Great!
Happy to hear that.

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------

Hi Bohyon, 
While calling it from Blueprism getting exception - Something threw an exception
Exception calling "Open" with "0" argument(s): "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".   Eventually Bluepirsm is 32 BIT, wheres the driver and the HANA DB is 64 BIT. Any idea how to resolve this.  
Thanks in advance.

------------------------------
Deepti Gupta
Application Developer
IBM
UTC
------------------------------

There might be a driver named as HDBODBC32, which should support 32-bit mode.


------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------