Configure the Connections

On this page:

• Configuring the source connections

  • Create the Refresh source connection

  • Create the No Refresh source connection

• Configuring the destination connection

  • Create the Data Warehouse destination connection

Sage Intacct's data is only accessible from the Sage Intacct connector, so you must synchronize the data from Sage Intacct with the data in the Nectari data warehouse using DataSync. The Web Server and Excel Add-in will read the data from this data warehouse.

Prior to configuring the source and destinations connections in DataSync, you need the following:

• A Sage Intacct environment
• A Nectari data warehouse (Cloud or On Premise)
• A valid version of DataSync (refer to Installing DataSync for more information)
• A Sage Intacct account (optional)
• Import Process & Delete Application in Sage Intacct

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

The destination connection for the Sage Intacct Data Warehouse will already be created for a Cloud provisioning. 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.