Page History

Overview

The DBSync's Sageoneconnector SageOne connector is a highly customizable connector that helps you connect your Sageone . It helps a user to connect SageOne application with many othe other applications , - such as MSCRM, Salesforce, SkuVault, and databases. Integration can be done with applications available on the cloud only.

Prerequisites

In order to be able to use the DBSync Sageone SageOne connector, the user needs:

A A license for the DBSync Sageone SageOne connector. That is, a username and password to connect to DBSync iPaaS platform, and the Sageone . And s/he also needs SageOne connector added to his/her account.
A valid username and password to connect to Sageone.
ODBC bridge configured on the server where Sageone sits ( DBSync support team will configure the ODBC bridge for you ).
Be sure that you have enough privileges in your Sageone account, including the right to create export and import jobs.

Connector Configurations

A Sageone

SageOne.

Connector Configurations

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

The parameters required to opening open the connection to a Sageone SageOne user instance are:

Property	Description	Required
Username	The username of staging Sage database.

yes

Yes
Password	The password of staging Sage database.

yes

Yes

Base URL

The URL where the Sage staging database is hosted

yes

Image Added

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 , many systems using the Sage 100 SageOne connector to retrieve data from, or send data to Sage 100 , SageOne Accounting application. Click on the following link to know which all connectors we support Connectors List .

Uses Of Sage 100 Connector

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

link Connectors List to learn about all connectors DBSync supports.

SageOne Supported Operations

Note: {Key} specifies ID of the respective record in SageOne.

Operation	Use
Ledger_accounts	Get ledger account IDs
Tax_rates	Get tax rate Ids
Contact_persons	Add new Contact Persons
Contact_persons/{key}	Update Contact Persons
Contacts	Add new Contacts
Contacts/{key}	Update Contacts
Products	Add new products
Products/{key}	Update Products
Sales_invoices	Add new Invoices
Sales_invoices/{key}	Update invoices
Purchase_invoices	Add new purchase invoice
Sales_quotes	Add new Quotes
Sales_estimate	Add new estimates
Stock_movements	Inventory adjustment
Services	Insert Services

SageOne Supported Versions

We only support US version.

Uses of SageOne Connector

Eliminate manual data entry by connecting Sage 100 SageOne to other CRM or , Accounting or Order management systems system, which are is supported by usDBSync.
Automate business process to increase efficiency across departments by reducing data reconciliation reconciliation.
Make your customerCustomer, itemItem, vendorVendor, sales Sales rep, invoiceInvoice, invoice Invoice history, sales 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

, SageOne.

Frequently Asked Questions

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

A: DBSync Sage 100 connector can be either configured on the same instance where Sage 100 is installed or on a remote machine which can access Sage 100 databaseSageOne connector is available on Cloud only.

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

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 there is import or export of data from Sage 100 then it should happen through visual integrator as Sage 100 do not expose Apis / web-service for consumption by other applicationsThe main limitation is that it applies to US version only.

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