Talk:DSA BI Components

From DataSelf Knowledge Base
Jump to navigation Jump to search

Main components of the DataSelf Analytics solution.

DataSelf Analytics / DSA
A complete and integrated package that provides self-service reporting and analytics.
The solution integrates analytic and reporting software, back-end data services and computing platforms.

Analytics & Reporting

DataSelf Analytics Server / “DSA Server”
Web-based, end-user, graphical reporting software. DataSelf’s OEM version of Tableau Server.
DataSelf Analytics Desktop / "DSA Desktop"
DataSelf’s OEM version of Tableau Desktop.
DSA Reporting Packages
One reporting unit set'; a DSA Connector and its Out-of-the-Box reports and dashboards.
See www.dataself.com/wiki/DSA_Reporting_Packages
DSA Server “Project”
Groupings on DataSelf Analytics Server that function like Windows folders to hold and organize data sources and reports, and are usually used to help define security settings.
DSA Template
Complete definitions for the data components and Out-of-the-Box reports. Each template is specific to an ERP, accounting or other business solution.
These definitions are stored in folder ..\Program Files (x86)\DataSelf\DataSelf ETL\Project\ProjectName on the DSA Data Computer Platform. The DSBI_Client subfolder contains the templates for the tds and twb components of the Reporting Packages.
DSA Connector
Organized, labeled, and user-ready data source used by DSA Server and DSA Desktop reports.
A combination of the data warehouse’s SQL views (supplying the data) and a DSA Desktop “tds” file (that organizes the data fields into hierarchies and usually supplies additional formulas and other reporting objects.)

Back-end Data Services

DataSelf ETL
The ETL engine that maintains the DSA Data Warehouse.
SQL Server
Microsoft SQL Server software that hosts the DSA Data Warehouse.
DSA Data Warehouse
A SQL Server database that is created, refreshed, and controlled by DataSelf ETL. Data analyzed and reported by DSA solutions flow through this data warehouse.
DSN
Connection instructions that are used by DataSelf ETL in order to import data from a data source.

Computer Platforms

A computer platform / platform consists of an operating system and related computer hardware. The computer hardware can be a local or network server, a cloud server, a desktop or laptop computer or a virtual machine.
For DataSelf BI the operating system is Microsoft Windows.
DataSelf Data Server / DS Data Services Platform / DataSelf Back-end Platform / DS Data Warehouse Platform
A computer platform that hosts DataSelf ETL, SQL Server and DSA Data Warehouse.

? DSA Server Platform / DataSelf Analytics Platform / DataSelf Analytics Platform ?

A computer platform that hosts DataSelf Analytics Server.
The DSA server computer platform can also serve as the DSA Data Computer Platform

 


under construction