Connecting with external databases
The scenario of connecting to external databases is somewhat common in the enterprise context. We often need to fetch, create, or edit data on other systems, and they may not have another standardized way of doing it.
With that in mind, OutSystems allows you to make these connections simply.
These connections are made in two steps: the creation of the database connection, and the mapping of tables to entities in an extension. Note that we can also map to existing views in these databases.
At this time, out-of-the-box connections with databases from the following systems are natively possible:
- Microsoft SQL Server
- Microsoft Azure SQL
- Oracle
- MySQL
- IBM DB2
Tip
You can see more system requirements for external database connections here: https://success.outsystems.com/Documentation/11/Setting_Up_OutSystems/OutSystems_system_requirements#integration-with-external-systems.
Creating an integration with an external database...