UserImage.jpg
Pedro Pinela
16Views
3Comments
Solved
External databases
Question
Reactive
External Database
Application Type
Reactive

Hi,

Is it possible to join a external database (integrated with Integration Builder) with a local database in an aggregate or in a SQL advanced query? In the documentation it says this:

0
0
21 Sep
Solution

Hi Pedro,

To my knowledge you cannot join OutSystems managed entities with external database tables, regardless if the integration is created via Integration Studio or Integration builder.

Regards,

Daniel

See solution in context
1
0
21 Sep

Pedro, 

Take a look in this documentation link:

https://success.outsystems.com/documentation/11/extensibility_and_integration/integrate_with_an_external_database/integrate_with_an_external_database_using_integration_builder/

Almost at the bottom of the page:

"... You can now use the entities of the integration to manipulate data on the external databases just like you do with the standard OutSystems entities.  ..."

0
0
21 Sep
Solution

Hi Pedro,

To my knowledge you cannot join OutSystems managed entities with external database tables, regardless if the integration is created via Integration Studio or Integration builder.

Regards,

Daniel

1
0
21 Sep

Pedro, I cannot check it for you in our OutSystems factory right now, but why not just give it a try, and let Daniel and me know what you have found out :)

0
0
21 Sep
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.