About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Last updated: Nov 26, 2024
If you have data assets in your catalogs that are connected directly to your data sources
and that have business terms assigned, you can name your virtual tables and their columns to match
the naming of the business terms when you virtualize those data assets in Data Virtualization.
Before you begin
The creator of the Data Virtualization instance must complete the following tasks.
- Enable personal credentials. Navigate to Personal credentials. and enable
- Create an instance of the Cloud Object Storage service and configure IBM Knowledge Catalog to use it. For more information, see Configuring Cloud Object Storage for project and catalog creation.
- Authorize the Watson
Knowledge Catalog service to access data in your Data Virtualization instance.
- Log in to your IBM® Cloud account where IBM Knowledge Catalog and Data Virtualization instances are provisioned.
- From the menu, select .
- Select Create + to create a new service-to-service authorization.
- Select IBM Knowledge Catalog service as the Source and Data Virtualization service as the Target.
- Select DataAccess role for service access.
- Click Authorize.
- Ensure that at least one data class exists in your account under .
- Ensure that the user who runs profiling runs it from the same IBM Cloud account that the Data Virtualization instance belongs to.
These instructions assume that you completed the
following prerequisites.
- Added the data source connection from which you want to virtualize to a governed catalog. For more information, see Adding a connection asset to a catalog.
- Added data from your data source connection to a governed catalog. For more information, see Adding a data asset from a connection to a catalog.
- Added the same data source connection that is used in the catalog to Data Virtualization. For more information, see Adding data sources.
- Authored and assigned business terms to data assets that you want to virtualize in a catalog.
About this task
Publishing Data Virtualization objects to the catalog is an entry point to governing your data. One of the key benefits is that you can apply business context or meaning to technical data.
Data Virtualization uses terms in the business glossary in Watson Knowledge Catalog to govern your virtual data. You use business terms to standardize definitions of business concepts so that your data is described in a uniform and easily understood way across your organization. Data Virtualization can automatically use existing term assignments on data assets while it virtualizes that data.
Business terms can describe the contents of the data, the sensitivity of the data, or other aspects of the data.
Important: These instructions apply only if the service is set to the
default virtualization mode. To enforce the use of business terms for naming virtual
objects and their columns, see Enforcing business terms to virtualize.
Procedure
To govern your virtual data with business terms, follow these steps.
Results
On the Virtualized data page, you can publish your virtual object to the catalog. For more information, see Publishing virtual data to the catalog in Data Virtualization.
Limitation:
In the default virtualization mode (where you can see all tables,
irrespective of business term assignments), when you navigate to the Virtualize
page, the console appears to be loading the table list for a while when data sources added to Data Virtualization have tables with nonstandard types, such as NULL or OTHER. However, you can wait
for the loading to complete to see a list of all tables, and you can preview, add to cart, edit
columns, and virtualize any of the listed tables. Refresh is disabled, but you can refresh the page
to trigger the reload of the available tables cache.