Settings for Sage Intacct

This section helps you configure the integration of Sage Intacct with DataSync so that they can communicate with each other. Before you begin these steps, you should already have created an account and imported the Process and Delete application in Sage Intacct. Refer to Configuration in Sage Intacct for more information.

Configuring the Source Connections

You need to create two source connections in DataSync:

• A source connection that will be used for refreshing the data (for tables that can be loaded incrementally);

• A source connection that will not incrementally refresh the data (for tables that cannot be loaded incrementally).

To create the Refresh source connection:

1. In DataSync, create a new source connection.
2. In the list, select Sage Intacct.
3. In the Connection Properties panel:
   1. In the Description field, enter Refresh as the name for this connection. For a consolidation, you may want to add the company name.
   2. In the URL field, paste this address: https://api.intacct.com/ia/xml/xmlgw.phtml
      
   3. For the User ID, Password and Company ID fields, enter the credentials you received in the email from Sage Intacct.

   

4. If you need to add Sage Intacct custom fields: 19090

   1. Add the DocParid property in the Additional Connection Properties panel.

   2. Set the value to the document type that the custom field uses. In our example, the document type is Vendor Invoice.

   

   Once the custom field is added to the source table, you can synchronize it with the destination table.

   

   Note

   DocParId can only have a single document type per connection. If you need custom fields that use a different document type, you must create a new Sage Intacct connection.

5. In the Additional Settings panel, set the Tracking Type to Date.

   Important

   The DataSync server time zone must match the time zone of the server where DataSync is installed.

6. Click Save.

7. For a consolidation, repeat these steps for each company. You can click the Duplicate Connection icon located on the upper right-hand corner and make the necessary updates.

To create the No Refresh source connection:

1. In DataSync, create a new source connection.
2. In the list, select Sage Intacct.
3. In the Connection Properties panel:
   1. In the Description field, enter No Refresh as the name for this connection. For a consolidation, you may want to add the company name.
   2. In the URL field, paste this address: https://api.intacct.com/ia/xml/xmlgw.phtml
      
   3. For the User ID, Password and Company ID fields, enter the credentials you received in the email from Sage Intacct.

4. In the Additional Settings panel, leave the Tracking Type set to None.

5. Click Save.

6. For a consolidation, repeat these steps for each company. You can click the Duplicate Connection icon located on the upper right-hand corner and make the necessary updates.

Configuring the Destination Connection

You need to create a destination connection for the Sage Intacct Data Warehouse. This connection will receive data from the Refresh and No Refresh source connections.

To create the Data Warehouse destination connection:

1. In DataSync, create a new destination connection.
2. Select SQL Server or Azure, depending on where the Nectari data warehouse is located.

3. In the Connection Properties panel:

   1. In the Description field, enter Data Warehouse as the name for this connection.

   2. Enter the name of the server on which the database is installed.

   3. Enter the name of the database to connect to.

   4. Enter the user name and password.

   

4. Click Save.

5. Create a Synchronization extraction type by following the procedures described in Adding an Extraction and Setting Up the Extraction.
6. Follow the procedures described in Validating and Building an Extraction and Running an Extraction to retrieve data from Sage Intacct.
7. Create a Schedule set to Incremental Load to automatically refresh the data by following the procedure described in Adding a Schedule.