About Collaboration SAML SSO Login Configuration
This manual is designed to assist administrators in configuring SAML SSO login for FOIAXpress Collaboration. It covers the following information:
Updating the Assertion URL (new for v11.7.0 and up)
FOIAXpress Collaboration SAML SSO Configuration
Retrieving the Service Provider Metadata File
Update Assertion URL
Follow the steps in this section to update Assertion URL. This is required when upgrading to from any version below 11.7.2.
NOTE: If the application is already on 11.7.2 or up, an assertion URL update is not required.
The customer must first obtain and provide their Identity Provider Metadata from their identity provider. This just be provided as either an XML file or URL
Next, we’ll confirm or update the Identity Provider Certificate in SAML Configuration. This must be confirmed otherwise SAML authentication will fail. Open the provided metadata file and locate for the signing cert in x.509 format, as highlighted below:

You’ll use this value to create a certificate. Follow these steps:
System Data Services
Copy the full text following <X509Certificate> (highlighted in yellow below):

Open Notepad, then paste the copied Certificate text into a new Notepad document.
Paste the following at the beginning then hit Enter to add a line break:
-----BEGIN CERTIFICATE-----
Add another line break at the end, then paste the following on the new line:
-----END CERTIFICATE-----
It should look like the example below. Save the file with a .cer file extension

Save the .cer file in a location that is accessible by the FX application
Open the FOIAXpress Database Configuration tool, select the Sign-On Mode tab, then paste the file name (if placed within the application folder) or full path in the Partner Certificate File field:

Update the Assertion Service URL. If you are upgrading from version 11.5.4 or under, you need to update the assertion URL after upgrade. See Section 1.2.1 in the v11.7.0 Release Notes for details
You must request that the customer’s SAML ID provider update the assertion URL on their end. The ID provider team can update the assertion URL on their end during or after an upgrade
NOTE: If you see the following error message, it is likely due to an incorrect identity provider’s certificate.


Collaboration SAML SSO Configuration
To complete the FOIAXpress Collaboration configuration for SAML SSO:
Login to the Collaboration application server
Run the Collaboration Database Configuration tool as an Administrator
Configure the database connection. If you have already configured the database connection, then save the existing database setting
Click the Sign-On Mode tab at the top menu bar and select SAML SSO

Enter the Service Provider details for the relying party identifier. These are shown below and described in the following table:
.jpg?sv=2022-11-02&spr=https&st=2026-03-10T03%3A46%3A21Z&se=2026-03-10T04%3A01%3A21Z&sr=c&sp=r&sig=lcu0Xmr%2F43btKEX1UZqiHIOopK3Oy8OjlVNOUhpwPgg%3D)
Field | Description |
Entity ID | Enter the Service Provider Entity ID. This can be defined by an FOIAXpress team lead using one of two approaches:
casepointCollaborationProd, casepointCollaborationTest |
Assertion Service URL | Enter the URL below, replacing <<DNS>> with your organization’s Collaboration URL: https://<<DNS>>/FOIAXpressCollab/AssertionConsumerService.aspx For example, if your Collaboration application URL is: https://myDns/FOIAXpressCollab Then the assertion URL value for this field would be: https://myDns/FOIAXpressCollab/AssertionConsumerService.aspx Note: The Assertion Service URL was updated for v11.7.0. If you are upgrading from a version below v11.7.0, you must update the value for Service Provider Assertion URL in SAML Configuration through a database configuration tool. You must also inform your Identity Provider about this change so they can record the updated assertion URL. See Section 2 for steps to update the URL |
Certificate File | Full file path for Service provider certificate (pfx) file |
Field | Description |
Certificate Password | Password of the Service provider certificate (if you enter path in the Certificate File field) |
Certificate Serial Number | Serial Number of the service provider |
NOTE: You need to provide either certificate file or certificate’s serial number. Make sure the application has permission to read private key from the certificate file.
Enter the Identity Provider values (SAML SSO Identity Provider) in the corresponding fields. These are shown below and described in the following table:

Field | Description |
Partner Identity Provider | Partner Identity Provider’s name/entityId (Required) |
Single Sign On Service URL | Single Sign On Service URL (Required) |
Single Logout Service URL | This is an optional field. If you configure the URL, the application will redirect to this configured URL once user signs out or user’s session times out. |
Partner Certificate File | Full path for Identity Provider provided certificate (Required) |
Select the remaining checkboxes as needed depending on your configuration requirements

Click Save.
Copy and paste the .CER file into the configured location Follow steps 3-5 in the Update Assertion URL section to configure the a partner certificate file.
Service Provider Metadata File
Generate Service Provider Metadata File
Follow the steps below to generate the Service Provider Metadata file:
First, have the pfx file ready (as used in the previous section)
Get the public key (.cer file) from pfx in base64 format (you can use OpenSSL, or do it from Certificate Management Console using the steps in the next section)
If you are preparing metadata for existing configuration then you will need to collect the following details from your current configuration:
Assertion URL (if you upgrading from v11.5.4 or earlier, then the assertion URL has changed)
Service Provider Name (first text field)
Want Authentication Request Signed (checkbox)
Want Assertion Signed (checkbox)
Go to the SAML Service Provider (SP) Metadata XML Builder and provide your information to generate an XML file
Provide the generated XML file to your Identity Provider
Retrieve .cer via Certificate Management Console
Follow these steps to retrieve a .cer file from pfx through the Certificate Management Console:
Note: This requires that the pfx is installed in the system.
Go to Certificate Management Console
Select the cert (pfx) then right click and select All Tasks > Export
Select Public key only (no private key)
Select Base 64 format