What Data Does SmartViews Store?

What Data Does SmartViews Store?

SmartViews is a tool that allows you to view data from your various databases in an aesthetically pleasing way, but SmartViews requires its own database in order to run. By default, we host a SmartViews DB for all of our customers, but your company does have the option to host and manage their own on-prem SmartViews database. If you want to know what data is stored in the SmartViews DB, this is the article for you.


What is stored in the SmartViews DB?

Company

  1. Company key and cloud/validation key (these are GUIDs)
  2. Company name, company address, and company website
  3. Create date, last-edit date, and delete date
  4. Company's SmartViews license
  5. Revision number

Users (Application Login)

  1. Username, password, email address, and user key (also a GUID)
  2. Create date, last-edit date, and delete date
  3. User role and user permissions
SmartViews user accounts have their own unique credentials and are completely independent from user accounts in any other apps or programs.

Connections

  1. Encrypted connection strings for DataSources
  2. Connection names (custom-defined in SmartViews for user convenience)
  3. Connection type (e.g. SqlClient, Oracle, Access, Excel)
  4. Create date, last-edit date, and delete date

Views, Reports, and Dashboards

  1. View/Report/Dashboard name and type
  2. Directory
  3. The underlying SQL behind the View/Report/Dashboard
  4. List of available connections, filter parameters, formatting, and various other options
  5. Default connection
  6. Create date, last-edit date, and delete date

Directories

  1. Directory name and parent directory
  2. Create date, last-edit date, and delete date

Layouts

  1. Layout name, type, and image
  2. What View/Report that the layout is for
  3. What user the layout belongs to
  4. Create date, last-edit date, and delete date
  5. Is this the default layout?

Performance (Latest Execution of a Query)

  1. When it happened and how long it took to execute
  2. Machine name and SmartViews user
  3. Connection the query was run against

User Security

  1. What users have access to specific Views/Reports/Dashboards
  2. Does the user have any special options in that View/Report/Dashboard? (e.g. Designer access, user-specific connection options)
  3. Create date, last-edit date, and delete date of the association

SmartViews Scripts

  1. Script name and VB code
  2. What View the script is attached to
  3. Create date, last-edit date, and delete date

What is NOT stored in the SmartViews DB?

Whether you use our cloud DB or your own, the SmartViews database does NOT store or cache any of the data that resides in the databases that you're viewing with SmartViews. Any data in your databases is NEVER stored in the SmartViews database.

Let's say you have an ERP database that SmartViews connects to. This ERP database contains customer and vendor data, order data, part data, etc. NONE of this data is stored in the SmartViews database.

Let's say you also have sensitive employee information stored in that database, like SSNs or bank account numbers. NONE of this data is stored in the SmartViews database.

What if that ERP database is a SQL Server DB with various employee and admin accounts on it? As mentioned before, SmartViews requires a connection string to access the ERP database, so that connection string may need to specify an existing user's credentials, but this connection string is securely encrypted. Aside from that, NONE of this data is stored in the SmartViews database.

    • Related Articles

    • SmartViews Network Requirements

      In addition to connecting to other databases to view their data, SmartViews also needs to be able to connect to a designated SmartViews database in order to run. This SmartViews database stores the data in SmartViews, such as user accounts, Views, ...

    • Blank / no data showing when loading SmartViews Report

      SmartViews Reports differ from SmartViews Views in that Reports do not display data unless a layout is created. If the above screen is encountered when launching a View, ensure that a layout is selected by clicking the "Layout" button next to the ...

    • How to turn on Roaming Profile for SmartViews

      How to turn on Roaming Profile for SmartViews  (Note: user must be running version 4.3.1.0 or later)    Purpose: SmartViews uses local cache files to store its info. It always saved to the root directory where SmartViews is installed. Each user will ...

    • SmartViews - Release Notes

      v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic syncing upon opening/closing SmartViews when the DisableSync flag is true v462.2000 (7/22/2024) Fixed tracking of versions used ...

    • SmartViews - User Guide

      Prerequisites: Windows Server 2016-2022 Windows 10-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x-10 .NET 4.6.2 if outgoing ports are blocked at the organization’s firewall, the following ...