Connecting in App Xchange

Before you can use this connector, you must complete these steps.

  1. Connect a Spectrum environment.
    If you are integrating a cloud environment, see Connect a Spectrum Cloud Environment. If you are integrating an on-prem environment, see Connect a Spectrum On-Prem Environment.
  2. Create a Spectrum Data Exchange.
    For instructions, see Create a Spectrum Data Exchange.
  3. Enter the connector details in App Xchange. If you are using the general configuration method, check Configuration for additional connector details.
    Note: Depending on the workspace type, this connector uses either a connection or fields built into the general configuration to manage credentials. Either method works. Eventually, connections will be used in all workspaces to allow for more data protection enhancements.

    • Api Root Url: Enter the root URL for the Spectrum Site with the port included. For example, https://trimble.dexterchaney.com:8482.

    • OAuth Client: If you are using an Enhanced Auth connection, create a new OAuth Client using the OAuth 2.0 Client Credentials connection definition. To find the values for your OAuth Client in Spectrum, navigate to System Administration > Installation > Data Exchange and open the appropriate Authorization ID. In the Token URL field, enter the API root URL followed by connect/token (for example, https://ryvit-dev.dexterchaney.com:8482/connect/token). For instructions on creating a new OAuth Client, see Create an OAuth Client.

    • Data Exchange Authorization Id: If your workspace contains a flow that brings data into Spectrum, enter the appropriate Authorization ID. This is found in Spectrum by navigating to System Administration > Installation > Data Exchange.

    • Company Code: Enter the three-digit code for the Spectrum company. It is found in Spectrum by navigating to System Administration > Installation > Enterprise > Company then selecting the Company tab. This code can be alphabetical, numeric, or both. For example, ABC, 101, or TS2.

    • Database Connection String: Create the Database Connection String using info from your initial ERP setup. Insert the appropriate values into each field below, then enter these fields separated by semicolons:

      • Data Source=[the Spectrum server URL]

      • Initial Catalog=[the database name provided by Spectrum]

      • User ID=XChangeServiceUser (this must match the Info-Link username created during step 1)

      • Password=[the password created for the Info-Link user you created during step 1]

      • MultipleActiveResultSets=true

      For example, Data Source=trimble.dexterchaney.com; Initial Catalog=Spectrum; User ID=XChangeServiceUser; Password=Password2; MultipleActiveResultSets=true;.