Viewpoint Spectrum Connector Configuration

Real-time Action Processing

• This feature should always be enabled for optimal performance. Only disable it if you are advised to do so by support.

Run Services on Connector App

• This feature should be enabled if you installed the XChangeAgent as part of your ERP connection setup, such as for an on-prem environment. Otherwise, it should be disabled.

Api Root Url

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

Company Configurations

Select + and enter values in the following fields for each Spectrum company you want App Xchange to connect to. These are the only companies that App Xchange will cache.

Company Code

• Enter the three-digit code for the Spectrum company. This code can be 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.

Starting Cache Write Job Id

• This field is optional and only necessary for Spectrum databases too large to be cached normally. Leave this blank unless advised by a Spectrum administrator.

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=[the Info-Link username created during your initial ERP setup]

• Password=[the password created for the above Info-Link user]

• MultipleActiveResultSets=true (this must be added to the end of every database connection string)

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

Data Exchange Authorization Id

• This field is optional and only necessary for certain connector types.

• Enter the appropriate Authorization ID. This can be found in Spectrum by navigating to System Administration > Installation > Data Exchange. 

Data Exchange Client Id

• This field is optional and only necessary if Enhanced Authentication is enabled in Spectrum.

• Enter the appropriate Data Exchange Client ID. This can be found in Spectrum by navigating to System Administration > Installation > Data Exchange, then opening the appropriate Authorization ID, then selecting Secret Status.

Data Exchange Client Secret

• This field is optional and only necessary if Enhanced Authentication is enabled in Spectrum.

• Enter the appropriate Data Exchange Client ID. This can be found in Spectrum by navigating to System Administration > Installation > Data Exchange, then opening the appropriate Authorization ID, then selecting Secret Status.

Use Spectrum Enhanced Security

• This field is optional and only necessary if Enhanced Authentication is enabled in Spectrum. 

• Toggle this feature if you have enabled Enhanced Authentication in Spectrum. Otherwise, leave it disabled.

Data Exchange Client Secret Expiration Date

• This field is optional and only necessary if Enhanced Authentication is enabled in Spectrum.

• Enter the expiration date of the Data Exchange Client Secret. This can be found in Spectrum by navigating to System Administration > Installation > Data Exchange, then opening the appropriate Authorization ID, then selecting Secret Status. 

Number of days to rotate the secret before expires

• This field is optional and only necessary if Enhanced Authentication is enabled in Spectrum.

• Enter the number of days required to rotate the secret. This can be found in Spectrum by navigating to System Administration > Installation > Data Exchange, then selecting the Settings tab.