Table of Contents

• Overview
• Install psaCollate
  • Download the Application & License
  • Install the License
  • Install the Application
• User Guide
  • Quick Checklist to Collate Change Activate
  • Quick Checklist to Collate Change Remove
  • Collate Activate
  • Collate Change - Change SQL
  • Collate Change - Change SQL
  • Wave Collate
  • Wave Database Collate

NOTE: Syniti’s Professional Service Accelerators (psa) have been developed and are supported by

a team of senior consultants. The psas are designed to supplement the Stewardship Tier delivered features with content and automation that accelerate the progress of the project. If there are any questions or the user encounters issues while using a psa, please submit a support ticket and be sure to select the psa on the form.

NOTE: Do not install psaCollate on versions of the Stewardship Tier 7.4.5 and later, as the collation

functionality is included in the product. If upgrading to 7.4.5 and later, uninstall psaCollate. Refer to the Knowledge Base Article Uninstalling psaCollate Prior to Upgrade.

The attached PDF file contains the contents of this article.

Professional Service Accelerators (PSAs) are licensed separately from the SST. For more information, please email NASMT@syniti.com. To download or install a PSA, submit a request to Syniti support.

Overview

psaCollate will automatically change dspMigrate process to be a case sensitive migration.

• Ability to turn on Case Collation on several key applications.
• Ability to turn on databases used within a wave to be case sensitive.
• Changes allows value mapping for migration in upper and lower case.
• Changes allows construction page case in upper and lower case.
• No manual overrides required for auto-generated objects.

Install psaCollate

The application may be installed on Syniti Solutions DSP versions 7.0.6 and above.

Download the Application & License

The psaCollate application and/or license are obtained by opening a support ticket at support.syniti.com

Perform the following steps to retrieve the necessary information for a license request:

1. On the SST application server, locate the Hardware Identifier program (called "HardwareIdentifier.exe") included in a zip file along with the SST installation software and documentation previously downloaded from Syniti.
2. Open the program.
3. Click Generate.
4. Copy the automatically generated ID and collect the following additional information. All information below pertains to the application server running SST; no information is needed regarding the database server:

• Hardware ID (as mentioned above)
• Windows computer name
• Number of processor cores (as shown in the Task Manager CPU tab)
• Usage of the SST instance, as in, DEV, TEST (or QA) or PROD

Install the License

Perform the following steps to install the license:

1. Log in to the SST site as an Administrator.
2. Select Admin > Configuration > Product Licenses in the Navigation pane.
3. Click the Upload a file icon in the FILE NAME column next to the Upload a New Product License link.
4. Locate the license file that was provided by Syniti Licensing.
5. Click Open
6. Verify the license is uploaded.

NOTE: If the Navigation pane does not display all the licensed components as expected, use the browser

refresh button or the F5 key to refresh the screen. At this point the full vertical menu will appear.

Install the Application

Perform the following steps to install the application:

1. Right click on psaCollates.zip and go to Properties. Ensure to unblock the file if it is blocked.
2. Unzip the file.
3. Navigate to the SST Installation folder. (e.g., D:\BOA\DSP or C:\Program Files (x86)\BOA\DSP)
4. Back up the SST Install\BOA\DSP folder to a compressed zip file.
5. Back up all Syniti-supplied SQL Server databases or verify that a complete recent backup already exists.

   NOTE: Supplied databases: AutoGen, cMap, cMap_Data, cMass, cMass_Data, Console,

   CranPort, CranSoft, DataConstructionServer, DataDialysis, DataGarage, DBMoto_Client, DGE, DGE_Data, dgReports, dgSAP, dspAddOn, DSPCommon, dspMonitor_AccPak, dspMonitorConfig, DSW, IGC, Integrate, IntegrateStaging, InterfaceServer, MC, & RADToolkit

6. Stop IIS.

   This process disconnects all active DSP users, so it is highly recommended to perform the install when no users are on the system. This process stops IIS on the web server.

   1. Open WindowsStart Menu.
   2. Open the Command Prompt (run as an administrator).
   3. Type: IISReset –stop
   4. Press the Enter key.
   5. Leave the Command Prompt window open for later use.
7. Stop all services that start with “Cransoft Service …”

   This process stops all SST background jobs, so it is highly recommended to perform the install when no scheduled operations are running on the system.

   1. Open Windows Start Menu.
   2. Select Administrative Tools.
   3. Run Services.
   4. Right-click the SST service.
   5. Select Stop.
   6. Repeat the previous two steps for any additional SST services.
8. Copy the Web folder from the zip file to the existing SST install\Web folder. If prompted, replace the files in the destination.
9. Copy the Databases folder from the zip file to existing SST install\Databases folder. If prompted, replace the files in the destination.
10. Navigate to SST install\Databases and execute file psaCollate_Install.bat (run as an administrator).
11. Start all services that start with “Cransoft Service …”
    1. Open Windows Start Menu.
    2. Select Administrative Tools .
    3. Run Services.
    4. Locate the DSP service(s).
    5. Right-click the SST service.
    6. Select Start.
    7. Repeat the previous two steps for any additional SST services.
12. Start IIS.
    1. Open Windows Start Menu.
    2. Open the Command Prompt (run as an administrator).
    3. Type: IISReset –start
    4. Press the Enter key.

If the Navigation pane in SST doesn’t show psaCollate, then try these steps:

1. Log in to the SST site as an Administrator.
2. Select Admin > Configuration > Product License in the Navigation pane.

   NOTE: Ensure that psaCollate displays.

3. Select Admin > Configuration > Site Menu in the Navigation pane.
   • Ensure that psaCollate displays.
   • If psaCollate does not display:
     1. Click Add.
     2. Enter a priority in the PRIORITY field.
     3. Enter psaCollate as the label for the site menu option in the LABEL field.
     4. Select the psaCollate : psaCollate page from the LINK TO PAGE ID list box.
4. Select Admin > Configuration > Parameters in the Navigation pane.
   1. Click Clear Cache.
   2. Reload the browser tab.

If the psaCollate application still will not display, then review the Define Security Roles article in the SST Online Help to ensure that the user has access to psaCollate. The SST Online Help is accessible from the question mark icon in the top-right corner of all SST pages. Also, open a ticket at support.syniti.com for assistance.

User Guide

Quick Checklist to Collate Change Activate

1. Open Page Collate Activate.
2. Click Activate Collate Update.
3. Click Get Wave DB Toolbar.
4. Open Page Wave Collate.
5. Click Apply to set all databases in the wave to case sensitive.
6. Go to Collect and rebuild all sources for each Target selected.
7. Go to AutoGen.
8. Create all Targets, Sources and Rules to rebuild the SQL Objects.
9. Reset Construction mappings and re-submit if mappings have been completed.

Quick Checklist to Collate Change Remove

1. Open Page Wave Collate.
2. Click Remove to set all databases in the wave to case insensitive.
3. Repeat set for all active waves.
4. Open Page Collate Activate.
5. Click Remove Collate Update.
6. Go to Collect and rebuild all sources for each Target selected.
7. Go to AutoGen.
8. Create all Targets, Sources and Rules to rebuild the SQL Objects.
9. Reset Construction mappings and re-submit if mappings have been completed.

Collate Activate

Collate Update page will enable or remove collate changes to the SST product.

Click the check mark to enable the Collate process.

Click the X to remove the collate changes to the applications.

This PROCESS DOES NOT AUTOGEN any objects already created in the dsw*, dg* or sdb* databases.

Users must re-create all objects via Collect or AutoGen objects.

The load wave process will read the current waves in console and display to the users whether a wave is case sensitive or not on the Wave Collate Page.

Image	Description of the Process
	Enable Collate process to the dspMigrate process
	Remove Collate process to the dspMigrate process
	Load all the waves to turn on Collate per wave

Collate Change – Change SQL

Collate change settings are listed for each database on this page.

This page displays the SQL Add and the SQL Removed options for the application.

The SQL must be executed in the order of the page for the process to be successful.

The logs page shows the history of the execute for each statement.

Collate Change – Change SQL

Process display the objects backed up before the SQL change was applied.

The process will display the change being made to the SQL SERVER for view and procedures.

Wave Collate

Wave databases can be altered in a single click on this page.

The Process changes the Collate Type in dspCommon and the Target Collation in Collect.

NOTE: Database objects must be regenerated for the collate change process to be complete.

Image	Description of the Process
	Enable Collate settings for the database in this wave.
	Remove Collate settings for the database in this wave.

Wave Database Collate

Display every database used in all waves in the current case sensitive setting. The process compares to the setting in dspCommon ttDataSourceRegistry table.

Updated on September 1st, 2021