Search

Sage Intacct

Version 26.1.9516

Sage Intacct

You can use the Sage Intacct connector from the CData Sync application to capture data from Sage Intacct and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Prerequisites

In addition to creating a Sage Intacct account, you also need to perform these prerequisites:

  • Enable a Web Services subscription by navigating to Company > Admin > Subscriptions.

  • Create a Web-Services user account without UI access. Sage Intacct recommends that you create a Web-Services-only user, which you can do by navigating to Company > Admin and clicking the plus sign (+) next to Web Services users.

    Note: Web Services users are programmatic users and never log into the UI. Therefore, both single sign-on and multifactor authentication are disabled automatically for them.

You can establish a connection to Sage Intacct using either the embedded credentials or with your own credentials.

Before you connect from CData Sync, you must also authorize CData as a valid sender identifier (Id) in Sage Intacct.

To authorize the sender Id:

  1. Log in to Sage Intacct as an administrator.

  2. Navigate to Company > Setup > Company.

  3. Locate the Web Services authorizations list in the Security section.

  4. Add CData to the list of authorized sender Ids. (This value is case sensitive.)

Add the Sage Intacct Connector

To enable Sync to use data from Sage Intacct, you first must add the connector, as follows:

  1. Open the Connections page of the Sync dashboard.

  2. Click Add Connection to open the Select Connectors page.

  3. Click the Sources tab and locate the Sage Intacct row.

  4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the Sage Intacct connector. For more information about installing new connectors, see Connections.

Authenticate to Sage Intacct

After you add the connector, you need to set the required properties.

  • Connection Name: Enter a connection name of your choice.

  • Company ID - Enter the company Id of the user who is authenticating to the Sage Intacct server.

CData Sync supports authenticating to Sage Intacct in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

Basic Read Only

CData Sync provides embedded Web Services credentials (SenderID and SenderPassword) that you can use to read data from Sage Intacct. To allow authentication with the embedded credentials, specify the following settings:

  • Auth Scheme - Select BasicReadOnly

  • User - Enter the username that you use to authenticate to Sage Intacct.

  • Password - Enter the password that you use to authenticate to Sage Intacct.

Basic

CData Sync provides embedded Web Services credentials (SenderID and SenderPassword) that you can use to read data from Sage Intacct. To connect with your user credentials, set the following properties:

  • Auth Scheme: Select Basic.

  • User: Enter the username that you use to authenticate to Sage Intacct.

  • Password: Enter the password that you use to authenticate to Sage Intacct.

Okta

To connect with single sign-on (SSO) via Okta, specify the following properties:

  • Auth Scheme: Select OKTA.

  • User: Enter the username that you use to authenticate to your Okta account.

  • Password: Enter the password that you use to authenticate to your Okta account.

  • SSO Login URL: Enter the login URL that is used by your SSO provider.

  • SSO Properties: Enter a semicolon-separated list of the single sign-on (SSO) properties that you want to use (for example, SSOProperty1=Value1;SSOProperty2=Value2;…).

Azure Active Directory

To connect with single sign-on via Azure Active Directory, specify the following settings:

  • Auth Scheme: Select AzureAD.

  • SSO Properties – Enter the single sign-on (SSO) properties that you want to use (for example, SSOProperty1=Value1;SSOProperty2=Value2;…).

Complete Your Connection

To complete your connection:

  1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

  2. If you authenticate with AzureAD, click Connect to Sage Intacct to connect to your Sage Intacct account.

  3. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and Sage Intacct, see Sage Intacct Connector for CData Sync.