Use OutSystems with existing databases
Table of contents
OutSystems integrates with major database systems, supported through the use of Integration Builder: SQL Server, SQL Azure, Oracle, MySQL, DB2 iSeries, PostgreSQL, Aurora PostgreSQL and Azure PostgreSQL for relational databases, as well as MongoDB, when it comes to non-relational databases.
Developers can combine local and external data sources without spending much time on complex integration projects.
Query and aggregate data, visually
The OutSystems visual editor allows development teams to query and aggregate data visually so developers with any skill set can work with the complex data needed for any application.
Use SQL
OutSystems doesn't limit developers to manipulating data visually. They can write queries and stored procedures using standard SQL, and OutSystems will track all the dependencies to the underlying database. If something changes, your SQL code is automatically refactored, or you're warned if it is no longer compatible with the changes.
This accelerates the change process; meanwhile, the application itself is much more resilient to change.
Integrate with external databases
If an external database is supported by OutSystems, a developer can create a connector to integrate with it. Connectors enable teams to manipulate data visually in the visual editor.
You can also use Integration Builder to integrate your apps with the following external relational databases: DB2 iSeries, PostgreSQL, Aurora PostgreSQL and Azure PostgreSQL, MySQL, Oracle, Azure SQL and SQL Server; as well as MongoDB when it comes to non-relational databases.
When a database is not supported, it's still possible to access it using standard code, with ODBC/JDBC drivers, or with native APIs. For big data repositories, like CouchDB, MongoDB, or Hadoop, developers access them using their REST APIs.
If you are considering developing a custom connector, try browsing the OutSystems Forge, which also has connectors, before starting. Most likely someone has already built and shared the connector you need.
Learn more
Check out the following articles in the OutSystems documentation for more information: