Skip to Content (Press Enter)
UserImage.jpg
Tomas Jirman
144Views
5Comments
Solved
Application server in cloud, Database on premise (or different cloud)
Question
External Database
Installation

Hello,
according to our client's requirements they would like to use Hybrid setup which means Application running on AppServer in Outsystems cloud, Data stored on local DB server on-premise (or using local virtual datacenter/server) - if I understand correctly infrastructure setups, above described hybrid setup is supported, isn't it?
If so, are there any other requirements for DB server except the below mentioned?

Regards,
Tomas

SQL Server Database

  • Microsoft SQL Server 2016, since Platform Server 10.0.502.0
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2005

Azure SQL Database

  • Azure SQL available in the cloud

Oracle Database

  • Oracle 19c (Standard Edition or Enterprise Edition), since Platform Server 10.0.1100.0
  • Oracle 18c (Standard Edition or Enterprise Edition), since Platform Server 10.0.1100.0
  • Oracle 12c (12.1 and 12.2, Standard Edition or Enterprise Edition)
  • Oracle 11g R2 (Standard Edition or Enterprise Edition)
  • Oracle 10g R2 (Standard Edition or Enterprise Edition)

The NLS_CHARACTERSET must be set to WE8MSWIN1252 or AL32UTF8.

MySQL Database

  • MySQL 5.6 (5.6.5 or later within the 5.6 version, all editions)
  • MySQL 5.7 (5.7.22 or later within the 5.7 version, all editions), since Platform Server 10.0.912.0

The JSON data type in MySQL 5.7 is not supported.

IBM Database

  • DB2 for iSeries V6R1 or higher

The installation of the IBM iAccess software is required in all Front-End and Deployment Controller server machines.

The use of double-byte characters with DB2 databases is not supported.

0
0
18 Aug 2022
Copy Link
2021-01-04 08-13-48
Toto
 
MVP
Solution

Replying to Somesh Renganathan's comment on 19 Aug 2022 03:06:34

Hi Somesh,


Is there a possible setup to have OutSystems platform on cloud, and the platform's database in OnPremise? ==> Yes, this is called hybrid setup, but need confirmation with sales team, as this need VPN access from/to cloud platform and on-premises database.

The entities and OutSystems related table data can reside in an OnPremise database and the compiler, debugger and other OS services can consume cloud resources for their operation. ==> Yes


At what step do we define connection details of platform database configuration during installation? ==> Need to setup VPN access from/to cloud platform and on-premises database.


But like I says, this need confirmation with Outsystems Sales, because VPN is needed for this kind of setup.  


See solution in context
1
0
19 Aug 2022
Copy Link
2021-01-04 08-13-48
Toto
 
MVP

Hi Tomas,

For hybrid setup, you can check with Outsystems sales for this.

For the database platform, the supported one is : Oracle and SQL Server (https://success.outsystems.com/Documentation/11/Setup_and_maintain_your_OutSystems_infrastructure/Setting_Up_OutSystems/OutSystems_system_requirements), but you can use any database to connect as external databases. The one that already have database connection is :

Other databases, you can find the database connection in the Forge.


Also I want to give some insight that some of our client had done.

So the platform is still on cloud using default Outsystems environment, and using the external database that is on premise in the client's data center.

0
0
19 Aug 2022
Copy Link
2025-05-11 04-57-37
Somesh Renganathan

Hi Toto,

could you please provide insights on below as well?

Is there a possible setup to have OutSystems platform on cloud, and the platform's database in OnPremise? The entities and OutSystems related table data can reside in an OnPremise database and the compiler, debugger and other OS services can consume cloud resources for their operation.

At what step do we define connection details of platform database configuration during installation?

0
0
19 Aug 2022
Copy Link
2021-01-04 08-13-48
Toto
 
MVP
Solution

Replying to Somesh Renganathan's comment on 19 Aug 2022 03:06:34

Hi Somesh,


Is there a possible setup to have OutSystems platform on cloud, and the platform's database in OnPremise? ==> Yes, this is called hybrid setup, but need confirmation with sales team, as this need VPN access from/to cloud platform and on-premises database.

The entities and OutSystems related table data can reside in an OnPremise database and the compiler, debugger and other OS services can consume cloud resources for their operation. ==> Yes


At what step do we define connection details of platform database configuration during installation? ==> Need to setup VPN access from/to cloud platform and on-premises database.


But like I says, this need confirmation with Outsystems Sales, because VPN is needed for this kind of setup.  


1
0
19 Aug 2022
Copy Link
2025-05-11 04-57-37
Somesh Renganathan

Replying to Toto's comment on 19 Aug 2022 03:14:43

Thanks for sharing the details Toto!

0
0
19 Aug 2022
Copy Link
UserImage.jpg
Tomas Jirman

Thanks Toto for your replies!

0
0
19 Aug 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.