Egress data

Within CONNECT data services, egress is the concept of data stored within CONNECT data services leaving or exiting the system. You can egress data from CONNECT data services for use in other applications.

Data Views

Data views allow you to access subsets of data items from CONNECT data services in data-driven applications, where the items can be used for data science enablement. With data views, you can prepare your raw CONNECT data services data for third-party applications like Microsoft Power BI, where it can be used for analytics, machine learning, reporting, and visualization. Users can programmatically retrieve data view content using the CONNECT data services API. Data views deliver shaped data that is ready for consumption because it is normalized, aligned, and contextualized.

First, you must create and configure a data view. The CONNECT data services resources included in the data view are based on the result of one or more queries, which you must configure. Streams, assets, and other CONNECT data services resources that can be included in a data view are known as data items. Streams shared to communities can also be included. Properties from data objects and information about the data items (such as Id and Metadata) can be included in the data view as fields.

Refer to the following topic for a workflow of how to get started creating and configuring a data view: Create and configure a data view.

API Console and REST API

CONNECT data services includes an API console that you can use to create and refine requests to the CONNECT data services REST API. After building and refining your requests using the console GUI—including edits to the URI, query parameters, request headers, and request body—you can implement the request in your own application. For more information about the console, see API console.

For a list of service endpoints available within the API console, refer to the CONNECT data services API Reference. This reference lists each service available within CONNECT data services, their available endpoints, and their available parameters. Enter these endpoints and parameters into the API console to create and refine API requests.

Microsoft Power BI

The CONNECT data services Power BI Connector retrieves data views from CONNECT data services and makes them available in Microsoft Power BI where it can be used for analytics, machine learning, reporting, and visualization. You can also use Microsoft Power BI to edit the query generated from the connector to modify the dates, edit the interpolation interval, and enable an incremental refresh of data.

Refer to the following topics for more information on how to setup Microsoft Power BI for CONNECT data services and retrieve existing data views:

1. Power BI Connector setup

2. Retrieve data views with Power BI Connector