Skip to main content

Reference

 

OutSystems

Database Tab in SQL Server

In the Database tab, once you set the 'Database Provider' property to 'SQL Server / Azure SQL', the following configurations become available.

Database Section

This section contains general configurations for the SQL Server / Azure SQL database.

Configuration Description Default value

Server

The hostname or IP address to the database server.

localhost

Catalog

The database catalog to be used by OutSystems.

outsystems

Authentication

Authentication protocol to be used.

Database Authentication

For advanced settings, click on the Advanced Settings link.

Configuration Description Default value

Advanced Connection Settings

Runtime Applications

Allows you to use a specific connection string for OutSystems applications.

 

OutSystems Services

Allows you to use a specific connection string for OutSystems services.

 

Default Query Timeout

Sets the default time for database queries to complete. The value can be overridden in the development environment, for each query.

30 seconds

1-Click Publish

Database Update Query Timeout

Sets the default time for database updates to run when 1-Click publishing an application.

600 seconds

Administrator Section

The 'Administrator' section allows you to configure the database user that manages the platform. This user owns the OutSystems metamodel tables, views, and indexes.

Configuration Description Default value

User

Name of the user that is the owner of OutSystems metamodel tables.

OSADMIN

Password

Password for the user.

 

Runtime Section

The 'Runtime' section allows you to configure the database user used by the applications at runtime. This user owns the tables created by developers in the development environment.

Configuration Description Default value

User

Name of the user that is the owner of tables created in the development environment.

OSRUNTIME

Password

Password for the user.

 

Log Section

In this section you specify the login of the user that owns logging tables, used by the OutSystems Log Service to write logs and rotate them whenever necessary.

Configuration Description Default value

User

Name of the user that is the owner of logging tables.

OSLOG

Password

Password for the user.

 

 

Create/Upgrade Database Button

To create all the database objects (tables, indexes, views, etc) the platform requires, click the 'Create/Upgrade Database'.

This button creates all necessary database objects (tables, indexes, views, stored procedures, etc) to run the OutSystems Platform Server version you are installing.

To install or upgrade OutSystems, you should follow the installation checklist.

  • Was this article helpful?