The Exasol database connector for OutSystems component allows the OutSystems low-code application development platform to natively connect to the Exasol high-performance analytical database.
Using Exasol with OutSystems enables companies to speed up their digital automation strategy and quickly implement low-code data driven business applications using Analytics, Artificial Intelligence, Predictive Modelling and Machine Learning techniques.
The connector component exists of two parts: an ExasolDatabaseProvider.dll you can download at https://dev.azure.com/NovioQPublic/OutSystemsExasolConnector and an Execute function component you can download from the OutSystems Forge at https://www.outsystems.com/forge/component-overview/8697/exasol-connector.
After the .dll has been installed, you can add a database connection to Exasol the ‘standard’ way, so by creating a Database Connection in Service Center and then importing tables using Integration Studio. All typical OutSystems Entity actions and Aggregates will be available.
All Exasol queries and commands not supported by OutSystems’ Aggregates and Advanced queries can be executed using the Execute function provided in the module.
A Demo Application is available in the OutSystems Forge that describes how to use this Execute function, please see the documentation for more information on how to install the .dll.