Hi,
I new to outsystems. Is it possible to build an outsystems app on the cloud environment that connects to an on-premises database (e.g, MS SQL or Oracle). Any on-premises gateway (for creating a dedicated connection between my on-premises environment and the outsystems cloud environment) that I can install to build such connection instead to making my on-premises database publicly available?
If not, it is possible to export/migrate all my data to the outsystems cloud environment?
There are two options 1) OutSystems does support connecting to a VPN ( more on this here ) 2) You expose your database but IP restricted for OutSystems servers.
Thanks @Siya
If I have a MS Access database, can outsystems import the tables and relationships and create the corresponding tables and relationships in the outsystems environment?
As @carl ruhle mentioned, you can export as Excel and use it in Service Studio, but you have to create relationships between imported entities explicitly.
Yes, thanks a lot @Siya
Hi Bassanio,
export from MS Access into XLS and then after that use ServiceStudio to import and create the relationship between the tables.
Hope it helps you, regards.
Hi @carl ruhle Thanks a lot!
Hi @carl ruhle ,
One more thing, for databases like Oracle or MS SQL, either I have to export the tables/data into Excel files and import them back to outsystems or connect to those databases directly (maybe through VPN). There is no tools for importing data from Oracle or MS SQL database to outsystems, right?
Hi @Siya, wonder if you have any insights?
For databases such as MSSQL, MySQL, and Oracle, you can establish a direct connection to the database over a VPN. Additionally, third-party tools like DMM are available for importing data into OutSystems.
Thanks a lot!
Hi @Bassanio Fung ,
good question that I don't have the answer, sorry.
But my guess is that is possible to connect to those databases thru extensions of the platform.
No worries, thanks!