Is their any integration services available for multiple database connectivity?

Help Forum
1

Hi all!
Is their any integration services available for multiple database connectivity in UiPath ? This was one approach we are trying to fulfill the need

Forum Engagement Daily Reports
2

Hi @vhvinodsai

UiPath doesn’t have a single multi-database connector. You can connect to multiple databases by using separate Connect activities for each, then run queries with Execute Query/Scalar. ODBC or API integration can also help if needed.

2 Likes
Forum Engagement Daily Reports
3

Hi @vhvinodsai
Yes, UiPath supports multiple database connectivity using UiPath.Database.Activities and Integration Service connectors, allowing connections to different databases within the same automation.

For more:

If helpful, mark as solution. Happy automation with UiPath

1 Like
4

Hi @prashant1603765

I know this database connectivity my requirement was multiple database connectivity within same workflow ?

5

Hi @Monali_Vekariya

You mean to say that I have to make multiple sequence for different database and using conditions have to match the data ?

6

Yes- by creating separate database connection activities (one per database) using integration service connectors, storing each connection in its own variable, and then using those variables in different database activities within the same workflow.

1 Like
7

Yes, basically. You don’t need completely separate workflows, but for each database you need a separate Connect activity and queries. Then you can use conditions or logic in the same workflow to compare or match data from different databases.

For example:

  • Connect to DB1 → Execute Query → store result in dt1
  • Connect to DB2 → Execute Query → store result in dt2
  • Use If / For Each / LINQ to compare or match the data

So one workflow can handle multiple databases, just with multiple connections inside it.

1 Like
8

Hi @Monali_Vekariya

Can I try to use oracle db and postgresql these as a different data source or which area of database have to select weather I have to use Microsoft odbc connection or what ?

9

Yes, treat Oracle and PostgreSQL as separate data sources with their own Connect activities. Use Oracle Connection if the client is installed, or ODBC Connection for either via DSN. You don’t have to use Microsoft ODBC unless you want one standard driver.

1 Like
10

Hi @vhvinodsai

UiPath uses package called UiPath.Database.Activities, you can install and import required namespaces. I recommend writing a C# code to connect to Multiple database as you would need connect to more than database. Its the best and modular approach for long term solutions.

Thanks,
Kunal

11

Using integration service is a bit overkill for using a database. Just use UiPath.Database.Activities.

Or, you can just write a little bit of C# with a common database library like Dapper.

2 Likes
Forum Engagement Daily Reports
12

I don’t think there’s a one straight way to connect to all databases.
since the connection string differs from system to system, you would definitely need separate connections, queries and drivers.

you might wanna check if your database has any extenders like LinkedServer(SQL Server), FDWs(PostgreSQL) to talk to remote database servers and pull data to your target DB server so that your bot can talk to just one DB server and run queries etc.