Skip to main content

OAuth 2.0 for Exact Online

This section describes the steps to configure the Trifacta Application to integrate with your Exact Online deployment using OAuth 2.0 to authenticate.

Create OAuth 2.0 Client App in Exact Online

In Exact Online, you must create the client app that the Trifacta Application uses OAuth 2.0 to access and connect to your Exact Online data.

Steps:

  1. Log in to the Exact Online account in which you want the client app to be created.

  2. Navigate to Manage my apps and click the + icon.

  3. In the App registration field, provide the app name and the REDIRECT URI.

  4. In the Authorization Details page, complete the listed fields with the appropriate information.

    Field

    Description

    Name of the APP

    Display name of the app. Suggested: Alteryx application

    Redirect URI

    Enter a valid URI. Example:

    https://clouddataprep.com/oauth2/callback

    Client ID

    Internal identifier of the client app

    Webhook secret

    Secret used for webhook messages

    Client secret

    Secret used by the client app to connect

  5. To save the changes, click Save. The OAuth 2.0app is generated.

  6. To make the app public, review and edit the changes accordingly.

Create OAuth 2.0 Client for Exact Online

After the Exact Online client app is created, you must create an OAuth 2.0 client in the Trifacta Application, which is used to integrate with the client app that you created above.

Note

You must create one OAuth 2.0 client in the Trifacta Application for each Exact Online client app that you wish to use.

Steps:

  1. Login to the Trifacta Application as a workspace administrator.

  2. In the left nav bar, select User menu > Admin console > OAuth2.0 Clients.

  3. In the OAuth2.0 Clients page, click Register OAuth2.0 Client.

  4. Specify the new client. Apply the following values:

    Setting

    Description

    Type

    Set to Exact Online.

    Name

    Display name for the OAuth 2.0 client in the Trifacta Application.

    Client ID

    The client identifier for the Exact Online client app that you created.

    Client Secret

    The client identifier for the Exact Online client app that you created.

    Authorization URL

    Set this value to the following:

    https://start.exactonline.nl/api/oauth2/auth

    Token URL

    Set this value to the following:

    https://start.exactonline.nl/api/oauth2/token

    Access Token Expires In

    Set this value to the corresponding value in your Exact Online client app. Example: 3599999

    Refresh Token Expires In

    Set this value to the number of milliseconds after which the refresh token expires. Example: 7775999999

  5. To save your OAuth 2.0 client, clickSave.

For more information, see Create OAuth2 Client.

Create Exact Online Connection

After you have created the OAuth 2.0 client app and client, you can create a connection in the Trifacta Application to access your Exact Online data.

Note

You must create a separate connection for each OAuth 2.0 client that is available in the Trifacta Application.

For more information, see Exact Online Connections.

In this section: