Data Virtualization Managers can determine the virtualization mode of the service.

Before you begin

Required role: To complete this task, you must have the Data Virtualization Manager role. For more information, see Data Virtualization roles.

About this task

The virtualization mode determines whether to enforce use of business terms in virtual table and column names. Use the strict virtualization mode if you want virtual objects to map to existing business terms only.

In this virtualization mode, the following conditions apply:

• Users can virtualize an asset from data sources that are supported by Data Virtualization. This asset must be added to the catalog as a connected asset. For more information, see Adding a data asset from a connection.
• Users can virtualize a connected asset from a data source, which is supported by Data Virtualization. The asset must have business terms assigned to itself and its columns.

When you disable the strict virtualization mode, you set Data Virtualization to the default virtualization mode.

To enable the strict virtualization mode:

1. Run the following command in the SQL editor.

   CALL DVSYS.TOGGLESTRICTFLAG(TRUE);

To disable the strict virtualization mode:

2. Run the following command in the SQL editor.

   CALL DVSYS.TOGGLESTRICTFLAG(FALSE);

To check the status of strict mode:

3. Run the following command in the SQL editor.

   SELECT VALUE FROM DVSYS.INSTANCE_INFO WHERE KEY='STRICT_FLAG';

   The value is true if strict mode is enabled and false if it is not enabled.

What to do next

Before virtualizing data in strict virtualization mode, delete objects that you virtualized before you enabled strict virtualization mode.