Dynamic source overrides

Data modules can be dynamically redirected to different data server connections, schemas, or catalogs at run time.

This feature is available only for data modules that are created from data server sources. Data modules that are created from packages, data sets, and uploaded files are not affected.

The overrides perform the same function as relinking, but without the need for user action.

To define source overrides, use the Override properties on data server connections, schemas, and catalogs.

Override source property

You can define the override values as strings or macros. However, only when using macros, and including session parameters, such as tenantID, machine, or account.personalInfo.userName, you can implement dynamic source overrides.

Dynamic source overrides are useful when the development, test, and production environments use different data server connections, schemas, or catalogs, or in a multi-tenant application where each tenant uses a different instance of the same database schema or catalog.

For more information, see Defining source overrides.