topic RE: Blue Prism Connection to HANA Database in Product Forum

Blue Prism Connection to HANA Database

Vikash011 — Wed, 23 Mar 2022 17:30:00 GMT

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
------------------------------

RE: Blue Prism Connection to HANA Database

PabloSarabia — Wed, 23 Mar 2022 18:47:00 GMT

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
------------------------------

RE: Blue Prism Connection to HANA Database

Vikash011 — Thu, 24 Mar 2022 10:11:00 GMT

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

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

RE: Blue Prism Connection to HANA Database

BhanuChalla — Tue, 20 Sep 2022 19:52:00 GMT

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
------------------------------

RE: Blue Prism Connection to HANA Database

BohyonHwang — Wed, 21 Sep 2022 00:48:00 GMT

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
------------------------------

RE: Blue Prism Connection to HANA Database

Vikash011 — Thu, 22 Sep 2022 09:09:00 GMT

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
------------------------------

RE: Blue Prism Connection to HANA Database

BohyonHwang — Fri, 23 Sep 2022 00:32:00 GMT

Great!
Happy to hear that.

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

RE: Blue Prism Connection to HANA Database

DeeptiGupta1 — Wed, 14 Dec 2022 15:35:00 GMT

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
------------------------------

RE: Blue Prism Connection to HANA Database

BohyonHwang — Thu, 15 Dec 2022 00:36:00 GMT

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

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