Search

Sage Intacct

Sage Intacct

Prerequisites

Before you attempt to connect to Sage Intacct, make sure to add the Sender ID ‘CData’ into your list of authorized Sender IDs for Web Services authorizations.

To add the Sender ID, follow these steps:

  1. Log in to Sage Intacct as an administrator.

  2. Navigate to Company.

  3. Under Setup select Company.

  4. Go to the Security section and add the CData Sender ID.

  5. If this does not work, utilize our Sender ID and Sender Password to select another user with the right permissions from your Web Services authorizations list.

If necessary, contact support@cdata.com for additional assistance.

Setup Guide

Follow these steps to connect Sage Intacct to your CData Connect Cloud account:

  1. Open the Connections page of the CData Connect Cloud dashboard.

  2. Click + Add Connection in the upper-right corner.

  3. Type Sage Intacct into the search field, then click the data source name.

  4. On the Basic Settings tab of the new connection, enter a connection name or keep the default name.

  5. Enter your Company Id into the Company ID field. You can find this Id in Sage Intacct under Company > Company info.

  6. Select the Authentication method, then proceed to the relevant section and follow those instructions.

Authentication Methods

BasicReadOnly

  1. First make sure that you have not specified either a “SenderID” or “SenderPassword” in Sage Intacct.

  2. In the Sage Intacct Web Services dashboard, navigate to Company > Company Info > Security.

  3. Add CData to the Web Services authorizations by navigating to Security > Web Services Authorizations/ Edit. Remember that this is case sensitive.

  4. On the Cdata Connect Cloud connections page, add the embedded User and Password provided by Sage Intacct.

  5. At the top of the CData Connect Cloud Add Sage Intacct Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

    • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

Basic

  1. Enter the following information:

    • User—the Sage Intacct username for authentication.

    • Password—the user password.

    • Sender ID—The Web Services Sender Id assigned by Sage Intacct. Contact your Sage Intacct representative for more details.

    • Sender Password— Your registered Web Services password. Contact your Sage Intacct representative for more details.

  2. At the top of the CData Connect Cloud Add Sage Intacct Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

    • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

OKTA

  1. Enter the following information:

    • User—The Okta user account.

    • Password—The password associated with the Okta account.

    • SSO Login URL—Set to the URL used by the SSO provider.

    • SSO Properties—Add property IntacctUserID, set to the Okta user specified in the User connection property. Then add all desired properties. The following is an example of a valid connection string: AuthScheme=Okta; SSOLoginURL=’https://example.okta.com/home/appType/0bg4ivz6cJRZgCz5d6/46’; User=oktaUserName; Password=oktaPassword; SSOProperties=’IntacctUserID=intacct_user’; .

    • Note: If you add an APIToken property, it must be set to the API Token that the customer created from the Okta org. It should only be used when authenticating a user via a trusted application or proxy that overrides Okta client request context.

  2. At the top of the CData Connect Cloud Add Sage Intacct Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

    • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

More Information

For more information about interactions between CData Connect Cloud and Sage Intacct, see this information page.