The Intacct connector is designed to allow you to move data into and out of Intacct's on-demand financial application suite. As an Intacct user, you can use DBSync's Intacct connector to integrate any on-premise applications and legacy systems with Intacct. This connector may also be used for integrating Intacct with other on-demand or SaaS based applications like CRM, E-Commerce, and others. Integrating with Intacct consists of an XML request/response sent over an HTTPS connection. The technical details of this connection such as request headers, error handling, HTTPS connection, etc. are all abstracted from the user to make implementation quick and easy.
Prerequisites
In order to establish a connection to your Intacct account from DBSync's Intacct connector, you'll need the following
The Intacct connector instance represents a single Intacct account, including login credentials. If a user wishes to connect to multiple instances of the either sandbox/production, create a separate connection for each and configure the parameters accordingly. The below table represent parameters required for opening the connection to Intacct user instance.
Property | Description | Required |
---|---|---|
Company Id | company Id is the required field to login to Intacct To locate the company ID in Intacct, follow the below steps
| yes |
User Id | user ID to connect to Intacct acccount | yes |
Password | password of the Intacct account | yes |
Sender Id | Senderid is your api gateway credentials. Contact support or your account manager at Intacct for more details | yes |
Control password | Application Control / Sender Password is your API gateway credentials.Contact support or your account manager at Intacct for more details | yes |
DTD version | Intacct API DTD Version we default to 2.1 | yes |
Host Url | Intacct Gateway Url we default to 'api.intacct.com' | yes |
After a connector is created within a project, set up the connector within the project. DBSync can map to and from the systems which are supported by our standard connector list and use Intacct connector to retrieve data from or send data to Intacct Platform.
click on the following link to know which all connectors we support Connectors List
This section gives out Trigger properties of Intacct connector that need to be set from Trigger section of DBSync
Property | Description | Required |
---|---|---|
QueryType | Get or GetList | yes |
Batch size | Batch size of requests to process | yes |
Query | 'select' query to get records from Intacct | yes |
The Intacct Trigger allows dbsync core system to query entities from the Intacct Backend services. Intacct exposes a “get” and “get_list” interface which is masked using a “SELECT query syntax” exposed by the Intacct connector. The “SELECT query” syntax is given below:
select [ fld, fld2, fld3,…fldn / *] <fields> from <entity> where [<fld1> opr <fld2>] <single_condition> or/and[<fld1><opr> <fld2>,<fld3><opr><fld4>]|or/and[<fld5><opr><fld6] <multiple conditions> <where_clause> order_by <fld1> asc, <fld2> asc, <fld3> desc <order_by_clause> |
In the above-mentioned syntax:
Fields: The fields are actually the attributes or the elements within an entity which need to be fetched by the query. In case all the fields need to be fetched “*” could be used
Entity: The entity which needs to be fetched from the Intacct Backend
Where Clause: The “where” clause takes in a series of “or/and “ conditions which internally contain the logical expressions ( the operands) which need to be operated upon. Please note that only the 1st condition will have two expressions as operands and any other additional operand will be a single expression.
Please note that a “single_condition” is also supported which consists of a single expression in the where clause
Order By Clause: The “order_by” clause allows the sort order to be specified for the fields fetched
Note that where and order_by clauses are both optional and need not be specified. The “Query Type” property in Intacct Trigger specifies whether it is a list query or a single select query
Following are some examples
select * from customer select customerid,name,parentid,termname,custrepid,shippingmethod,custtype,taxid,creditlimit from customer select * from invoice WHERE [whenmodified < 10/22/2010 00:00:00\] select recordno,customerid,name from customer where [customerid = ZAB001] AND [recordno = 24] select * from customer [key=Key_Value] |
This section gives out Rule properties for Intacct connector that need to be set during the Rule setup in DBSync
Property | Description | Required |
---|---|---|
External id | External reference column to be used for upsert | required when 'write type' is 'upsert' |
Table | Name of table to write transaction | yes |
Max Batch Size | Batch size of requests to process | yes |
Write Type | Insert, Update or Delete. Limited support for upsert | yes |
Uses Of Intaact Connector
The Intacct connector makes it easy to work with Intacct web service by:
Frequently Asked Questions
Q: How does DBSync connect to Intacct?
A: DBSync connects to Intacct platform through connector called Intacct connector which has inbuilt API methods that open a connection to Intacct application for reading and writing data in and out of the platform.
Q: Does DBSync need to be installed on the same machine as that of Intacct?
A: The answer is No, As both of DBSync and Intacct platforms are available through the cloud and if required DBSync is available as on-premise version as well.
Q: How does Intacct connector handle errors?
A: The DBSync Intacct connector handles processing of errors in different ways depending on the error type and can be tracked via log section of the DBSync platform. If there is a connection error, authentication error, schema validation error then process level error is triggered.