Upgrading the Active Directory (AD) Connector Utility as part of an upgrade to 6.5.4

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

If in use, the Active Directory Connector Utility (also known as the AD Import Utility) must be upgraded to version 1.6.0.4 prior to upgrading Information Centric Analytics (ICA) to version 6.5.4. If upgrading from importer version 1.5.4.0 or earlier, changes must first be made to the stored procedure dbo.spUpdateStg_AD in the RiskFabric database.

Environment

Release : 6.5.4

Component : Active Directory Connector Utility

Resolution

To update the Active Directory Connector Utility from version 1.5.4.0 to version 1.6.0.4, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric database
3. From the File menu, select Open > File...
4. Locate and open the file spUpdateStg_AD.sql (attached to this article)
   
5. Confirm the Risk Fabric database is selected in the dropdown menu to the left of the Execute button on the SQL Editor toolbar (note that the database name may differ in your environment)
6. Execute the script by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Query > Execute from the menu bar

Follow this procedure to upgrade the importer (as documented in the file readme.txt bundled in the file archive ActiveDirectoryImporter_1.6.0.4.zip) :

1. 1. Open the file archive ActiveDirectoryImporter_1.6.0.4.zip
   2. Copy the contents of the archive to the current location of the AD importer and overwrite the existing files, with the following exceptions:
      ADConnectorSetup.exe.config
      ImportADUsersAndComputers.exe.config
   3. Open SSMS
   4. In Object Explorer, navigate to SQL Server Agent > Jobs
   5. Right-click the job Bay Dynamics AD Connector Job and select Start Job at Step...