Easy System Connector - Installation

Easy System Connector - Installation

Prerequisites

Supported Visual versions are 7.0 – 11.x

Database Platform: SQL Server & Oracle

Microsoft .Net Framework 4.8

Installation

Use the this link to download the setup file. Once downloaded follow these steps to install. 

QA Testing Download (For internal Synergy use only)    

  1. Run EasySystemConnectorSetup.exe
  2. Set the path to 

  3. Press 'Finish', you are now ready to run the program.

SQL Connection

If your client is having issues with connection to an sql server, it may be due to the clients sql server permissions.  In the app.config file please find the following:
  1.   <appSettings>
  2.     <add "ConnectionStringAppend" key="Trusted_Connection=False;Encrypt=False;"/>
  3.   </appSettings>
The above is a default setting for either sql server or oracle.

When connecting to SQL Server, the Trusted_Connection (or Integrated Security) setting in the connection string determines whether Windows Authentication is used instead of SQL Server username/password authentication.

When connecting to SQL Server while ignoring (not validating) the server's SSL/TLS certificate, you can set the following TrustServerCertificate=true  (This is often used in development or testing environments with self-signed certificates or without a proper CA chain.
  • Trusted_Connection=True or Integrated Security=True means:
    • The connection uses the Windows credentials of the process running the application.
    • Any User ID and Password in the connection string are ignored.
  • This is useful in Active Directory or domain environments where you want to avoid storing credentials in code.
  • If set to False, you must provide User ID and Password.

    3. Equivalent Keywords

    • Trusted_Connection=True
    • Integrated Security=True
    • Integrated Security=SSPI (Windows only)

    All three mean the same thing in .NET for SQL Server.

    Security Notes

    • Windows Authentication is generally more secure because credentials are not stored in the connection string.
    • If using SQL Authentication, never hardcode passwords — use secure storage like Azure Key Vault, Windows Credential Manager, or environment variables.

    • Related Articles

    • Easy System Connector - Release Notes

      Easy System Connector Release Notes to Import data from QBS Voucher system v1100.1000 (Pending) Upgrade for Visual Erp 11 Upgrade SynergyBusinessObjects to support Visual ERP 11 (v1100.1009) Upgrade nuget packages Upgrade to use .NET Framework 4.8 ...

    • RAM Connector - User Guide

      Prerequisites Supported Visual version are 7.0.0 – 11 Database Platform: SQL Server & Oracle .Net Framework 4.6.2 Installation Use the following Production Link to download the setup file. Once downloaded follow these steps to install QA Release, ...

    • Synergy uniPoint Connector - Installation

      Prerequisites Visual 9.0 or later Database platform: SQL Server 2012 or later .NET Framework 4.6.2 or later IIS 8 or later Synergy Macro Server Installer Use the following link to download the setup file Run SynergyUniPointConnectorSetup.exe Click ...

    • Avalara Tax Connector - Troubleshooting - Error - Maximum Message Size Quota For Incoming Messages Has Been Exceeded

      Issue You may receive the following message after running the Tax macro on an order with a lot of lines: "'The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property ...

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