The OutSystems platform makes available automatic integration capabilities with external SQL Server and ORACLE databases. With this integration method, you are able to expose your external database entities as visual objects that you can use to develop applications in Service Studio (the OutSystems Agile Platform IDE).
In the OutSystems Platform Tour you can see the video Reuse existing databases that gives you a very good idea of how this process is done.
The goal of this how-to is to give you a step by step description of how to integrate with in an external database in OutSystems and use this integration in your OutSystems application. The how-to instructions are designed to someone that is running an OutSystems Community Edition platform server on his local computer, but you can easily adapt to a situation where you have a standalone server on another machine.
This how-to will explain how to do an external database integration by assuming an example scenario where we want to create an OutSystems application that will give us the functionality to manage the list of Employees stored in an external SQL Server (or ORACLE) databas ewith HR information.
The main steps in the integration process are:
The first step to be able to establish a connection to an external database is to define the database connection settings in Service Center (the OutSystems platform central management console). To do that, execute the following steps:
Once we have the connection to our server configured in Service Center, we can now create the integration component to our HR Database using the OutSystems Integration Studio. To do that, execute the following steps:
As the HRConnector extension is now available and configured to be used, we can use it to create OutSystems applications with the tables in the external HR Database (query data, change data, delete data). For example, we can easily create an HRBrowser eSpace that lists the content of the Employees table doing the following:
I'm trying to Refresh Entities on an existing database conection as mentioned in comment #1 and 2. That goes OK, I can see the added attributes in my entity list in integration studio. When i try to PUBBLISH the updated extention i'm getting the error:
"The property 'ssJW_test_2_int' does not exist or is not public in the 'OutSystems.NssExtension.ENJW_TradingPartnerAgreementEntityRecord' struct."
Tht error is on the newly added attribute. Creating a new extention i working just fine. Am I missing a step?