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

    • 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.1001 (Beta) RSA Algorithm has been implemented Company GUID and User GUID added to the user information UI Support for Azure Database Connection v480.1000 2025.03.10 (Beta) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to ...

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