Connection SAP HANA DB using uipath studio

Help Studio
1

Hi Team,

Can anyone please suggest me how to connect SAPHANA DB.
And later how to add this workflow in UiPath agentic platform as a tool.
So that directly we can ask any query related to DB using prompt to get the response from agentic platform.

Regards,

Vidhan Mistry

2

Hi @Bidhan_Mistry,

Yes, you can definitely connect to SAP HANA from UiPath and make it available on the Agentic Automation platform.

First, to connect with the SAP HANA database, you can use ODBC or OLEDB via the Connect activity in UiPath. Just make sure the SAP HANA client/driver is properly installed on your system. Once connected, you can run your queries using the Execute Query activity.

Next, to make this available as a tool in the Agentic platform:

  1. Build a UiPath workflow that takes a natural language input (your prompt) and converts it to a SQL query.
  2. Register this workflow as a tool using Agentic Tool Builder.
  3. Define the input (prompt) and output structure clearly.
  4. Add your tool to the Agent in the platform – now it can handle questions like “Show me the last 10 purchase orders.”

Let me know if you’d like help setting up the SQL prompt conversion or tool registration part.

3

Thanks, Mir, for the explanation.

As I am new to this platform it would be highly appreciated if you could provide me simple workflow (xaml file) of this and kindly help setting up the SQL prompt conversion or tool.

Thanks,
Bidhan Mistry

4

Hi @Bidhan_Mistry

Glad to help!

  1. SAP HANA Connection Workflow:
    Check this UiPath forum post for a full example using ODBC:
  1. Agentic Platform Tool Setup:
  • Build a workflow that takes a natural language prompt, converts it to SQL, runs it on SAP HANA, and returns results.
  • Register it via Agentic Tool Builder with input: prompt, output: result.

Let me know if you need anything else.

5

@Bidhan_Mistry

Welcome to the community

A better way would be to use integration services which can be easily integrated with agents and also retreival can be easier

You need the api creds for the same

Cheers

6

Hi Anil,
Thanks for your response.
I have host name, port number, username and password. But when I am checking in the integration service it is asking site URL, service name, what I should mention there if you could provide in detail with a screen shot example then it would be great.

Thanks
Vidhan

7

Thanks, Mir, for your response.

I am getting the error while trying to connect SAP hana db, which is attached here, kindly check and suggest for further steps.
Thanks,
Vidhan

image
image824×313 11.5 KB

8

Hey @Bidhan_Mistry,

To fix the “Data source name not found” error in UiPath, you need to first download and install the official SAP HANA client, which contains the necessary ODBC driver. After installation, you can connect using a DSN or by directly specifying the driver in your connection string. You can find more information on the official UiPath SAP automation page:

Let me know if you still facing any problems

9

@Bidhan_Mistry

In the above mentioned link itself you have the details of what those are

Detailed steps on how to get the url using host and port are also provided

Cheers