Changing the Global Branding String

You can change the branding string that is used throughout EmpowerID by replacing the global {ProductName} variable from EmpowerID to that of your own product. doing so involves replacing the variable in the dbo.ReplaceLocalizationWildcard scalar function in the EmpowerID Identity Warehouse and then executing that function. This topic describes how to do so.

To change the global branding string

  1. Open Microsoft SQL Server Management Studio and navigate to the EmpowerID database.
  2. Under Programmability, expand Functions.
  3. Right-click Scalar-valued Functions and select Filter > Filter Settings from the context menu.
  4. In the Filter Settings dialog that appears, add the following Name filter to reduce the amount of functions that display to those related to localization and then click OK to close the Filter Settings dialog.
  5. Expand Scalar-valued Functions, right-click dbo.ReplaceLocalizationWildcard and select Modify from the context menu to open the function in a query window.
  6. Alter the query, replacing "EmpowerID" with the desired product name. In the below example, we replaced "EmpowerID" with "Andys Beans."
  7. 
        USE EmpowerID
        GO
        /****** Object:  UserDefinedFunction [dbo].[ReplaceLocalizationWildcard] ******/   
        SET ANSI_NULLS ON
        GO
        
        SET QUOTED_IDENTIFIER ON
        GO 
        
        ALTER FUNCTION [dbo].[ReplaceLocalizationWildcard]
        (
            @TextToParse nvarchar(max),
            @PersonID INT
        )
        RETURNS nvarchar(max)    
        AS
        BEGIN
            
            RETURN REPLACE(@TextToParse, '{ProductName}',  'Andys Beans')
            
        END
  8. Execute the query.
  9. You should see that the default global branding string has been replaced with the value you specified in the function.