Skip to main content

 

Access the database of your PaaS

 

OutSystems

Access the database of your PaaS

To accommodate the need of altering application data directly in the database, you may request direct access to your infrastructures' PaaS databases.

Request access to your PaaS databases

This option is available depending on your subscription, check more details at Cloud service delivery requiring direct assistance from OutSystems Support

How to make the request

You’ll need to open a support case and:

  • Be a 'company administrator' or an 'infrastructure administrator' for your company's account;
  • Identify the environments to which you require database access (by providing either their name or their address);
  • Specify whether you require read & write or read-only access
  • Let us know how you wish to connect to the database;
  • Be sure to provide a contact number that can receive SMS to retrieve the password.

What will OutSystems deliver

  • OutSystems will ensure to establish connectivity according to your chosen preference
  • We will provide a file with the database address and the username. The password will be communicated via SMS.

You can then tools like SQL server management studio or Oracle SQL Developer. Any tool that is compatible with the database management system can be used.

Connecting to the database

To ensure the high-availability and security of your PaaS, the databases are not publicly accessible. Therefore, we provide two connectivity options:

  • Connect via VPN from your internal network to the database server. You can request one or use any VPN connection may have enabled;

  • Allow connections to the database server from your company public IP. Let us know what public static IPs should be allowed to connect;

What permissions are granted

To ensure the high-availability and security of your PaaS, we'll be able to provide you with one set of the following credentials per environment:

  • Read-only

    • Read-only permissions to data generated by your applications;

    • Read-only permissions to the platform meta-model;

  • Read and write

    • Read and write permissions to data generated by your applications;

    • Read-only permissions to the platform meta-model;

Note that you won't have DDL permissions on the databases. Please use the OutSystems Platform IDEs to create new database objects.