Hello Team,
What is the outsystems recommended database for using with outsystems ? what all factors should client consider while choosing one?
any pointers will be really helpfulthanks.
In OutSystems 11, you can choose from several databases, including SQL Server, Azure SQL Database, Oracle, or DB2.Aurora PostgreSQL is used in OutSystems Developer Cloud (ODC).
Consider your specific requirements and constraints when selecting the database. The choice between Oracle and SQL Server largely depends on factors such as your organization's existing infrastructure, expertise, licensing costs, performance requirements, scalability needs, and data management preferences.Thank youSunil Botadara
Hi Anagha,
With OutSystems 11 Cloud offering you will automatically get provisioned Microsoft SQL Server Databases. For the cloud offering of O11 you don't have a choice. (edit: See Daniel's comment. Iam wrong on this one).
Running O11 on-premise you can go for Microsoft SQL Server or Oracle. In that case the DBMS is not part of the O11 license and you have to bring your own licensed instance. The choice typically depends on "What is already available". So in an environment where there is already an Oracle cluster available and know-how in PLSQL is available you may go for Oracle. My personal preference however is Microsoft SQL Server and not just because iam more familiar with T-SQL. SQL dialects differ from T-SQL to PLSQL and there are some really useful Forge components that use Advanced SQL that you would have to modify to make them work. But anyhow.
In ODC the database is PostgreSQL. No other choice available.
However in both platforms you are able to integrate with a variety of external SQL databases.
Best
Stefan
Stefan, that is not correct. You can have Oracle in cloud offering, you can request this when you start the license.
Oh. I did not know this. I may misunderstood one of our customers when he said they will have to migrate from Oracle to SQL Server when moving to the cloud offering.
@Anagha Chikate Sorry about that.