Skip to main content
BuyLog In
Report and Dashboard Server
Search in…
Docs > Administrative Panel > Manage Data Models
All docs
V24.2
Report and Dashboard Server
Differences from BI Dashboard and Reporting
License and Distribution
Installation
Administrative Panel
Manage Server Settings
Manage User Accounts and Grant Security Permissions
Manage Data Models
Connect to a SQL Database
Connect to a JSON Endpoint
Connect to an OLAP Cube
Manage Documents and their Categories
Schedule Documents
Create Reports
Create Dashboards
Configuration and API
User-Specific Functions
Localization

Manage Data Models

The Report and Dashboard Server separates the document presentation and data layer. You should first define a data model that provides access to your data provider (in read-only mode) and obtains the specified tables and/or views from it. Once you created a data model, you can use its data in any number of documents (reports and dashboards).

Provide Data

The following topics provide information on how to connect data models to different types of data sources.

Data Model Security

Use the following best practices when you create data models in the Report and Dashboard Server:

  • Use Windows Authentication to connect to Microsoft SQL Server.
  • Restrict access to the Report and Dashboard Server databases and backups because the Server does not encrypt data models. All information (including connection credentials) is stored as clear text.
See Also