Search

Sage Intacct

Sage Intacct

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.

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.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.

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.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.

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.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.

More Information

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