Logi Data Services technology, found in recent Discovery Module versions, uses Dataviews to define datasource connections, queries, and data enrichment.
The following topics discuss Dataviews and the tools for creating and managing them:
- Launching the Dataview Authoring Tool
- Dataview Authoring Tool Menu
- Managing Your Profile
- Connecting to Databases
- Connecting to Data Files and Applications
- Managing Data Sources
- Creating a Dataview
- Dataview Loading
- Filtering Data
- Data Enrichment
- Creating Data Relationships
- Managing Dataviews
Advanced features discussed here work with Logi Info v12.5 and later. Earlier and later Info versions may not support them; consult the Release Notes for specific details.
Logi Data Services technology provides you with an advanced means of data retrieval based on the "Dataview", a definition that specifies the connection information, query details, and data enrichment details.
Dataviews are stored in a system database and can be used with the SuperWidget Authoring too. For more information, see SuperWidgets. Dataviews can also be used in Logi Info reports using a special DataLayer element, and the data can be altered at runtime using special Data Service ("Ds") elements. When executed at the server, the Dataview retrieves the data and makes it available in the standard datalayer format to other elements for analyses and visualizations. Some of the benefits of this include:
- Decoupling of developer and data architect duties
- Shared access to stored Dataviews by multiple users
- Better support for Self-Service analytics
- Excellent performance for very large datasets (250M+ rows)
Prior to working with Dataviews, a connection to Logi services must be configured. See Get Started with the Discovery Module 3.2 for more information. Dataviews are created using tools like the Dataview Authoring tool accessible from Logi Studio. The Dataviews used with Logi Info can retrieve data from a number of databases.
If our DataHub 3.0+ product is installed, then Dataviews can also retrieve and join file-, cloud-, and application-based data, such as Facebook, Google Analytics, and Marketo, and cache it in a separate data store.
The following sections describe how you can create and manage Dataviews using the browser-based tool in Logi Studio.