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

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

    • Synergy uniPoint Connector - User Guide

      Installation You can find the installation document for Synergy uniPoint Connector here. How to Use Overview Synergy uniPoint Connector can be used in the following Visual windows: Customer Maintenance Customer Order Entry Part Maintenance Vendor ...

    • Sql Server LocalDB Installation for New SmartViews

      Installation Instructions As of version 462.1000, SmartViews uses LocalDB 2017 in place of the previous local cache. As such, LocalDB 2017 or later needs to be installed on the machine, and an important patch needs to be applied. LOCALDB 2019 ...