How to join two tables present in two different extensions.

Hi,

I have a table present in a particular db Server, I  have used integration studio to connect this table.

There is one more table in another DB server, using the same i made the connection.

Now I have two extensions, I want to perform a join with these two tables in service studio and I am not able to . Is there any alternate way to achieve it ?

Thanks,

Sai

Hi Yeniganti, it's not possible make in outsystems. The concern about that is in fact you have two differents databases, and do not perform a join if you don't have a Linked Server(SQL) configured or allow. I do not know how it call in oracle. But it's not recommend by outsystems.

If you don't create a linked server you have to create your "JOIN" fetch the results from table 1 and search in table 2.

You have take care about that, because it can ruin your performance. Try to fetch with some filters and never all results.

https://success.outsystems.com/Documentation/10/Extensibility_and_Integration/Integrate_with_an_External_Database

https://www.outsystems.com/forums/discussion/36083/linked-server-vs-database-connection-from-service-center/


Best Regards,
Paulo Fagundes

Paulo Fagundes Jr. wrote:

Hi Yeniganti, it's not possible make in outsystems. The concern about that is in fact you have two differents databases, and do not perform a join if you don't have a Linked Server(SQL) configured or allow. I do not know how it call in oracle. But it's not recommend by outsystems.

If you don't create a linked server you have to create your "JOIN" fetch the results from table 1 and search in table 2.

You have take care about that, because it can ruin your performance. Try to fetch with some filters and never all results.

https://success.outsystems.com/Documentation/10/Extensibility_and_Integration/Integrate_with_an_External_Database

https://www.outsystems.com/forums/discussion/36083/linked-server-vs-database-connection-from-service-center/


Best Regards,
Paulo Fagundes


Hi Paulo, 

Thanks for replying,

I am going through the links you provided. 

BTW, is fetching records from one table and searching in other table is the only option ?

Thanks,

Sai

Hello sai,

Dependant on how much information you need from these tables, how large these tables are and how fresh your information has to be, it might be an option to create your own tables on OS server, holding only the attributes and records you need, and set up some synchronisation with the external tables.

All your logic can then query your copy of the data, using joins if needed.

This approach becomes more appealing if

* you are only interested in a small subset of table columns

* you are only interested in a small subset of available rows

* you can accept some age on your data, don't need to be real time

* it is easy to detect changed rows in the tables, allowing to only synchronise the rows changed since last synchronisation

Dorine