SmartViews - How To - Add Data Connections

SmartViews - How To - Add Data Connections

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 - Troubleshooting - Blank / No Data Showing When Loading 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 Scheduler - User Guide

      PREREQUISITES Supported Visual version are 7.0 – 11.x Database Platform: SQL Server & Oracle Microsoft .Net Framework 4.8 ADMINISTRATION LICENSING Request for a license key can be made via email. Send your request to CustomerCare@wm-synergy.com and ...

    • SmartViews - How To - Disable Syncing for a User

      A user may want to disable their ability to sync if they're working on changes that they don't want to go out to everyone just yet. To do this, open up regedit and go to the following path: ...

    • 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 - How To - Output Installation Log

      If there is an unexpected issue when running the SmartViews installer, run it via the command line using the command below to output a log file. This can be helpful either to you or to a Synergy employee to help diagnose the reason why the install ...