Updating the database structure

To make your modifications to the data model effective and to be able to use them, the database structure needs to be updated.


Custom resources are automatically refreshed during automatic updates performed by Adobe.

Publishing a custom resource

To apply the changes carried out on the resources, you must perform a database update.


If a field of a custom resource used on an event is modified or deleted, the corresponding event will automatically be unpublished. See Configuring Transactional messaging.

  1. From the advanced menu, via the Adobe Campaign logo, select Administration > Development , then Publishing .

  2. By default, the option Determine modifications since the last publication is checked, which means that only the changes carried out since the last update will be applied.


    The Repair database structure reestablishes a correct configuration if the publication failed before completing. Any modification that was carried out directly in the database and not using custom resources will be deleted.

  3. Click the Prepare publication button to start the analysis.

  4. Once the publication has been carried out, click the Publish button to apply your new configurations.

  5. Once published, the Summary pane of each resource indicates that the status is now Published and specifies the date of the last publication.


    If you make new changes to a resource, you must repeat this operation for the changes to be applied.

    If resources have the Pending re-draft status before publishing, then an additional message will appear inviting you to check your actions because publishing will result in definitive changes (deleting columns, tables...). To help you carry out this last change, an SQL Script tab is available. It provides the SQL command that will be executed during the publication.



    You can stop the Re-draft process by clicking the Cancel re-draft button. This action will revert the resource's status back to its original one.

Publishing a resource with API extension

When you extend the custom resources Profiles or Services , you can perform an update of the Profiles and Services API to integrate the fields declared in the custom resources extension.

Before publishing your resource with API extension, refer to this document to understand the process of the Profiles & Services API update.

When you define a custom resource and you create a link between the resources Profiles or Services and the custom resource, you can perform an update to include the new resource in the API.

This option is available in the publication screen.


Note that by default, the custom resource is integrated, but, for a specific behavior, if you don't want to publish this resource, you can select the option Hide this resource from APIs available in the Resource Properties .


After the Prepare Publication step, Adobe Campaign displays the delta between the current version of the API and the future version after the publication in the tab Profiles & Services API Preview . If you extend the API for the first time, the delta compares the out-of-the-box custom resource definition with your extension.

The information displayed in the tab is divided into three sections: added, deleted and modified elements.


The analysis of the delta is a mandatory step as the publication step will modify the API behavior and will most likely affect the surrounding development in a domino effect.


This publication updates the profilesAndServicesExt API. The profilesAndSedrvices API is not updated.

For more information on the Adobe Campaign API, consult the dedicated Adobe Campaign documentation on Adobe IO.

Esta obra está autorizada con arreglo a la licencia de Reconocimiento-NoComercial-CompartirIgual 3.0 Unported de Creative Commons.  Los términos de Creative Commons no cubren las publicaciones en Twitter™ y Facebook.

Avisos legales   |   Política de privacidad en línea