Skip to main content

Integration

OutSystems

Use OutSystems Platform with existing databases

OutSystems Platform integrates natively with several of the major database systems: SQL Server, Oracle, MySQL, and DB2 iSeries.

It also has a database integration SDK, so that organizations can integrate with a database of choice. Developers can combine local and external data sources without spending much time on complex integration projects. 

Query and aggregate data, visually

The OutSystems Platform IDE 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. 

fetch-example.gif

Use SQL

OutSystems Platform doesn't limit developers to manipulating data visually. They can write queries and stored procedures using standard SQL.

Integrate with external databases

If an external database is natively supported by OutSystems Platform, a developer can create a connector to integrate with it. Connectors enable teams to manipulate data visually on the IDE.

When a database is not natively supported, it's still possible to access it using standard C# or Java code, with ODBC/JDBC drivers, or native APIs. For big data repositories, like CouchDB, MongoDB, or Hadoop, developers access them using their REST APIs

There is also an OutSystems Platform database integration SDK for extending the platform, and it can be used to add native support for databases. However, any developer considering developing a customer connector should browse OutSystems Forge, which also has connectors before starting. It is possible someone has already built and shared the connector needed. 

Learn more

Check out the following links for more information:

  • Was this article helpful?