Dataviews
Logi Data Services technology uses Dataviews to define datasource connections, queries, and data enrichment. This topic discusses Dataviews and the tools for creating and managing them.
The following sections are covered in this topic:
- About Logi Platform Services Technology
- Related Logi Info Elements
To use this technology, you must install the Discovery Module 3.0+ add-on.
About Logi Services Technology
The elements discussed here are available in Logi Info v12.5 but have been deprecated in later Info versions; consult the Release Notes for specific details.
Logi Services technology has been introduced into Logi Info, through the Discovery add-on module. It's Logi Data Service provides you with an
additional, advanced means of data retrieval based on the "Dataview", a
definition that specifies data connection information, query details,
and data enrichment details.
That definition is stored in a system database, is called using special DataLayer elements, and can be altered at runtime using special Data Service ("Ds") elements (see the next section). When executed at the server, the Dataview retrieves the data, enriches and paginates it, and makes it available. Some of the benefits of this include:
- Decoupling of developer and data architect duties
- Reusable Dataviews, available across multiple applications
- Shared access to stored Dataviews by multiple users
- Application of security at the data level
- Better support for Self-Service analytics
- Excellent performance for very large datasets (250M+ rows)
When used with Logi Info's DataLayer.Data Services element, after the Dataview runs, the data is converted into the standard Logi XML format and made available to other elements for visualizations, tables, etc. When used with the DataLayer.Data Services element, the data is made directly available to the Thinkspace.
Dataviews can be created using the Dataview Authoring tool accessible from Logi Studio and they can also be created using the Logi Platform Services REST API. Detailed instructions for these activities are presented in Dataview Authoring.
The Dataviews used with Logi Info can retrieve data from a variety of databases:
- AWS Redshift
- Infobright
- JDBC database providers
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL
- Snowflake
- Vertica
If our DataHub 3.0+ product is installed, then Dataviews can also retrieve and join file-, cloud-, and application-based data, and cache it in a separate data store. Data sources include:
- Amazon Dynamo DB
- Eloqua
- Financial Accounts (OFX)
- Google Analytics
- Marketo
- Microsoft Dynamics CRM On Premise
- Microsoft Dynamics CRM Online
- Microsoft Dynamics GP
- Microsoft Excel and CSV files
- Netsuite
- OData
- Quickbooks On Premise
- Quickbooks Online
- Quickbooks POS
- Salesforce
- SAP Netweaver
Related Logi Info Elements
The elements discussed here are available in Logi Info v12.5 but have been deprecated in later Info versions; consult the Release Notes for specific details.
The following Logi Info elements can be used with Logi Data Services:
| Element | Description |
|---|---|
| Connection.Logi Application Services | The Connection element that connects to the Logi Application Services web service installed with the Discovery Module. For more information, see Datasource Connections. |
| DataLayer.Data Services | The DataLayer element that works with the Connection.Logi Application Services element to retrieve data using Dataviews. |
| The DsAggregate Column | This element is used with DataLayer.Data Services to add a new column to the data containing an aggregated value of the data in one of the other columns. |
| The DsCalculated Column | This element is used with DataLayer.Data Services to add a new column to a data containing a value that's the result of a expression. The syntax for creating calculated values is available in the Dsexpression Reference. |
| The DsCondition Filter | This element is used with DataLayer.Data Services to filter out data rows. It's analogous to using a WHERE clause in a SQL query and adds a filtering operation to a Dataview. The syntax for filtering values is available in the Dsexpression Reference. |
| DsGroup | This element is used with DataLayer.Data Services to add a grouping operation to Dataview processing. It also gives you the ability to create aggregate values from the grouped rows. |
| DsSort | This element is used with DataLayer.Data Services to add a sortingoperation to Dataview processing. |
SuperWidget | This element allows you to add widgets, created using the Dataview Authoring and SuperWidget Authoring tools, into Logi Info applications. For more information, see SuperWidgets. |