Watson Query on Cloud Pak for Data

Version: 2.0.4    Included   IBM

Description

Watson™ Query connects multiple data sources across locations and turns all of this data into one virtual data view. This read-only data view makes it easier to get value out of your data.

Benefits

After you create connections to your data sources, you can quickly view all of your organization's data. This virtual data view enables real-time analytics without moving data, duplication, ETLs, or additional storage requirements, so processing times are greatly accelerated. You can bring real-time insightful results to decision-making applications or analysts more quickly and dependably than methods that don't use virtualization.

Security

Centralized authentication and authorization are enforced for platform users to access data sources in a trusted environment. The Watson Query Admin, Watson Query Engineer, Watson Query Steward, and Watson Query User roles provide granular access management to the virtualized assets. Cloud Pak for Data users that need to use Watson Query functions must be assigned specific Watson Query roles based on their job description.

All communication between the environment and the application is securely encrypted with robust IBM technology, and SSL/TLS encryption by using standard protocols.

Platform support

Watson Query supports queries by using standard SQL through common interfaces such as R, Spark, Python, and Jupyter Notebooks. In addition, queries are also supported by the most common analytics application tools, including IBM Watson Studio and Cognos Analytics.

Quick links

Required services

Table 1. Required services. The following services are required for this service.
Service Capability
IBM® Db2 Data Management Console Administer, monitor, manage, and optimize the performance of your IBM Db2 databases.

Integrated services

Table 2. Related services. The following related services are often used with this service and provide complementary features, but they are not required.
Service Capability
Watson Knowledge Catalog Create catalogs of curated assets with this secure enterprise catalog management platform that is supported by a data governance framework.

Compatible data sources

See Supported data sources in Watson Query for a list of data sources that are compatible.