2022
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:
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. |
The URL where the Sage staging database is hosted
yes
Yes | |
Password | The password of staging Sage database. |
yes
Yes |
After a connector is created within a project, set up the connector within the process, . DBSync can then map to, and from, many systems using the Sageone SageOne connector to retrieve data from, or send data to Sageone , SageOne Accounting application. Click on the following link to know which all connectors we support Connectors List .
Sageonelink Connectors List to learn about all connectors DBSync supports.
Note: {Key} specifies
IdID of the respective record in
SageoneOperation | 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 |
The following are the few uses of our Sageone connector.
We only support US version.
Supported Versions
Frequently Asked Questions
Q: Does DBSync need to be installed on the same machine as that of Sage 100SageOne?
A: DBSync Sageone connector can be either configured on the same instance where Sageone 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 SageoneSageOne?
A: There is no real-time integration of data directly from Sageone to target systems/ application due to the rule imposed by Sageone itself, whenever there is import or export of data from Sageone then it should happen through visual integrator as Sageone 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 SageoneSageOne?
A: DBSync connects to Sageone SageOne through Visual Integrator provided by Sageone SageOne to read data from, and write data out of, the Sageone SageOne application.