I need to do Inner Join between Table 1 and Table 2. Table 1 is stored in DB2/GBQ and Table 2 is stored in SQL Server. I have the query ready but how do I use this query in UiPath to get the data.
Can I use 2 connection strings for different databases in Single Uipath activity?
My suggestion is if you know SQL then create stored procedure to join those tables You can connect another DB in SQL query so that you can avoid multiple connection string in UiPath
-Either we can run on a single script either with a Function or procedure within which you can call and connect the second dB and perform the Join table and normalisation with which we can use one Single EXECUTE QUERY activity
-or we need to use two different EXECUTE QUERY activity and get the table
And then perform Join datatable in UiPath