Improve how you connect to, govern, and run queries on your data with new and enhanced features in Data Virtualization on Cloud Pak for Data as a Service. Connect to your data more securely and efficiently, govern your data more consistently, and run queries on your data faster and with more insights. 

Connect to your data efficiently and securely

• Connect to your on-premises data sources securely with Satellite connectors. Your data remains encrypted.

• Enable Kerberos authentication for Hive, Impala, and Spark data sources by using Satellite connectors and remote agents.

• Leverage new data sources including REST API, Apache Spark, Presto, and SAP HANA.

• Define personal credentials when you connect to data sources, and manage who can access shared connections by assigning users, groups, and roles as collaborators. 

Govern your data consistently

• Use data source definitions (DSDs) to enforce IBM Knowledge Catalog data protection rules across services, regardless of whether you are querying using Data Virtualization or exploring data in a catalog or project. 

• See which data protection rules apply to a user for a virtual object by running the EXT_AUTHORIZER_EXPLAIN stored procedure.

Run queries with speed and gain useful insights

• Enable Autocaching to automatically cache your most queried data and evict unused caches, boosting query performance while optimizing memory usage.

• Push more processing to the underlying data sources with pushdown query performance enhancements including OLAP support for Oracle, common subexpression pushdown, and improved handling of large queries.

• Leverage fetch phase errors and warnings to debug and troubleshoot issues that might occur during complex queries.

• Find enhanced error reporting details for SQL5105N errors that are linked to the enforcement of data protection rules.

To start using these new features, upgrade your Data Virtualization instance on Cloud Pak for Data as a Service to version 3.0.3 today. 

Learn more

• For more details on What's new in Data Virtualization, see New and enhanced features in Data Virtualization in the Cloud Pak for Data as a Service documentation.