Skip to main content

 

Managing the Applications Lifecycle

 

OutSystems

Early Access - Configure Entities From External Databases During Deployment

Read how early access to OutSystems features works. We encourage you to try these features out and to send us your feedback.

This early access feature adds a new step during the deployment plan to define application settings in the target environment. With this feature disabled, when you deploy an application with a setting that must be different in the target environment, you need to use the Service Center console to update it in the target environment after deployment.

To use this feature, make sure that:

  • Your infrastructure uses LifeTime Release Jul.2019 or later.
  • The Configure entities from external database during deployment feature is enabled in LifeTime.
  • Both the source and target environments use Platform Server 11 Release Jul.2019 CP1 or later.
  • You have Change & Deploy Applications permission for the applications that you want to deploy.
  • You created the Extension that integrates with an external database while connected to an environment running Platform Server 11 Release Jul.2019 CP1 or later.
    Otherwise, republish the Extension in Integration Studio while connected to an environment running Platform Server 11 Release Jul.2019 CP1 or later.

After activating the early access feature Configure entities from external database during deployment, a new deployment plan wizard will be used when deploying applications in LifeTime. This wizard has four steps:

  1. Add the applications to deploy
  2. Configure application settings
  3. Review deployment plan
  4. Execute deployment plan

While you are already familiar with the other steps, during the step Configure application settings you can now configure the settings in the target environment of the applications being deployed.The deployment plan wizard includes this step when there are new settings to configure

There are some situations when the step Configure application settings is skipped or disabled:

  • The step will be skipped when there are no new settings to configure. However, if you need to change any existing setting, you can manually go back to Configure application settings by clicking the step in the wizard.

  • The step will be disabled when there aren't any settings to configure or the user executing the deployment does not have the required permissions.

Deploy an Integration With an External Database

Follow the steps in this guide to deploy an application with a connection to an external database from an OutSystems environment (in this case, the Development environment) to the next environment (in this case, the Quality environment).

Use this guide after you created the integration with the external database in your Development environment and if your application needs to connect to a different external database in each environment.

Before you begin following this step by step guide, make sure that you fulfill all Requirements.

Otherwise, check the step by step guide on how to deploy an integration with an external SQL Server database.

Define a Database Connection in the Quality environment

In the Quality environment, define a Database Connection:

  1. Open the Service Center management console of your Quality environment.

  2. On the Administration tab, select Database Connections.

  3. Click New Database Connection and fill in the fields to set up the connection to the external database.

  4. Click Test to check if the connection is working correctly.

    The database user must have permissions to:

    • List the necessary tables and views in the external database.
    • Perform the operations Create, Read, Update, and Delete on those tables and views.
  5. Click Create to create the Database Connection.

Deploy the application to the Quality environment

To deploy the application to the Quality environment follow these steps:

  1. Open LifeTime for your Infrastructure.

    Tip: Open LifeTime directly from Service Center by clicking Manage all environments.

  2. Select the Applications tab and select the DEPLOY... button between the Development environment and the Quality environment.

  3. Select Add Applications and, in the Choose one or more Applications dialog, select your application and select Add to Deployment Plan.

  4. Select the VALIDATE NOW button between the Development environment and the Quality environment.

  5. Select the CONTINUE button between the Development environment and the Quality environment.

  6. Verify the deployment plan, select Deploy Now and then in the Deploy applications as planned dialog select Deploy Now to start the deployment.

  7. In the Configure applications settings step, enter the three-part Physical Table Name of each external database Entity. Make sure you enter the correct Physical Table Name for the target environment.

    If your application connects to the same external database/schema for both your environments, select Copy from Source to copy the Physical Table Name from the source environment.

  8. After the deployment stops, click the configuration or confirmation link in the warning banner to open Service Center and map the database name of the extension to the database connection.

  9. Associate the logical database name of the extension to the Database Connection that you created previously.

After the Deployment finishes your Extension is ready to be used by other applications in the Quality environment.

  • Was this article helpful?