Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview 

The DBSync's Sage 100 connector is a highly customizable connector that . It has the ability to connect your Sage 100 application (which is formerly known as MAS 90) with the additional applications - like CRMs, E-Commerce platforms, Order management systems and much more. As a Sage 100 user, you can also use this connector to integrate Sage 100 with another other On-demand, On-premise or SaaS-based application applications - such as MSCRM, Salesforce, SkuVault, and databases. The connector uses Visual Integrator to move data in, and out of, Sage 100 application. 

Prerequisites

To establish a connection to Sage 100 via DBSync Sage connector, user has to do the followingmust:

  • Have a valid license to DBSync Sage 100 connector, username and password to connect to DBSync iPaaS platform.
  • Should have Have a valid username, password to connect to Sage 100.
  • Have ODBC bridge configured on the server where Sage 100 sits ( DBSync support team will configure the ODBC bridge for you ).
  • Be sure that you have user has enough privileges to (1) connect to Sage 100 remotely on which it is hosted so as ; (2) to create export and import Jobs for ; and (3) enable Sage 100 connector to communicate with DBSync.

Connector Configurations

A Sage 100 connector instance represents a single Sage 100 account, including login credentials. If a user wishes to connect to multiple instances of the either sandbox/production then, s/he must create a separate connection for each and configure the ODBC bridge accordingly.

The table below table represent represents parameters required for opening the connection to Sage 100 user instance.

Property

Description

Required

Username

The username of staging Sage database.

yesYes

Password

The password of staging Sage database.

yesYes

Base URL

The URL where the Sage staging database is hosted.

yesYes


After a connector is created within a project, set up the connector within the process, DBSync can then map to, and from, virtually any system using the Sage 100 connector to retrieve data from, or send data to, Sage 100 Accounting application. Click on the following link to know which all connectors we support Connectors List link Connectors List to learn all about connectors DBSync supports.

Uses Of Sage 100 Connector

The following are the few uses you reap while using our Sage 100 connector.

  1. Eliminate manual data entry by connecting Sage 100 to other CRM or , Accounting or Order management systems which that are supported by usDBSync.
  2. Automate business process to increase efficiency across departments by reducing data reconciliation reconciliation.
  3. Make your customer, item, vendor, sales rep, invoice, invoice history, sales order records as zero error prone as possible while moving in, and out, of Sage 100.


Supported Versions

The following versions of Sage 100 are supported by DBSync's Sage connector:

  • 5,19,4.5, 2014,2015,2016.
  • Single and multi-user installations installations.


Frequently Asked Questions

Q: Does DBSync need to be installed on the same machine as that of Sage 100?

A: DBSync Sage 100 connector can be either configured on the same instance where Sage 100 is installed or, on a remote machine which that can access Sage 100 database.

Q: What are the limitations of DBSync integration with Sage 100?

A: There is no real-time integration of data directly from Sage 100 to target systems/application due to the rule imposed by Sage 100 itself, whenever . Whenever there is import or export of data from Sage 100 then it should happen through visual integrator as Sage 100 do does not expose Apis / web-service for consumption by other applications.

Q: How does DBSync connect to Sage 100?
A: DBSync connects to Sage 100 through Visual Integrator provided by Sage 100 to read data from, and write data out of, the Sage 100.