2022
The DBSync's Sageoneconnector is a highly customizable connector that helps you connect your Sageone application with many othe 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 connector, the user needs:
A Sageone connector instance represents a single Sageone account, including login credentials. If a user wishes to connect to multiple instances of the either sandbox/production, he/she needs to create a separate connection for each of the instances, and configure the ODBC bridge accordingly.
The parameters required to opening the connection to a Sageone user instance are:
Property | Description | Required |
---|---|---|
Username | The username of staging Sage database | yes |
Password | The password of staging Sage database | yes |
Base URL | The URL where the Sage staging database is hosted | yes |
After a connector is created within a project, set up the connector within the process, DBSync can 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 100Note : {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 |
The following are the few uses you reap while using our Sage 100 of our Sageone connector.
Supported Versions
The following versions of Sage 100 are supported by DBSync's Sage connector
Frequently Asked Questions
Q: Does DBSync need to be installed on the same machine as that of Sage 100?
A: DBSync Sage 100 Sageone connector can be either configured on the same instance where Sage 100 Sageone is installed or on a remote machine which can access Sage 100 database.
Q: What are the limitations of DBSync integration with Sage 100Sageone?
A: There is no real-time integration of data directly from Sage 100 Sageone 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 Sageone do not expose Apis / web-service for consumption by other applications.
Q: How does DBSync connect to Sage 100Sageone?
A: DBSync connects to Sage 100 through Visual Integrator provided by Sage 100 Sageone to read data from and write data out of the Sage 100Sageone application.
Info | ||
---|---|---|
| ||