Smartviews Data Connection

Smartviews Data Connection

How to Add a data connection?

Step 1 : Login to SmartViews and select Designer tab and Click on "Add" a data connection

Info
Currently, Smartviews support the following data connection:
  1. Microsoft SQL server
  2. MS Access
  3. MS Excel
  4. Oracle
  5. ODBC
  6. Lillyworks
  7. PostgreSQL
Step 2:  After selecting a data type, provide the connection details


TroubleShooting

If a data connection is successful in Test Connection but doesn't show up as an accessible connection in the drop-down list for a report, the issue may be with user security permissions. In the designer, go to the Security tab and see if the connection is checked in the Connection Options drop-down for the user.

    • Related Articles

    • SmartViews Scheduler User Guide

      PREREQUISITES Supported Visual version are 7.0 – 10.x Database Platform: SQL Server & Oracle Microsoft .Net Framework 4.8 ADMINISTRATION INSTALLING Use the following link to download the setup file. Once downloaded follow these steps to install. Run ...

    • SmartViews - User Guide

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

    • 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 ...

    • 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, ...

    • SmartViews - Release Notes

      v480.1000 (2025.01.09) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to v23.2Change to framework 4.8 v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic ...