How to configure NetIQ Analyzer for IDM to use external MySQL database

How to configure NetIQ Analyzer for IDM to use external MySQL database

A long time ago, Novell introduced Analyzer tool as part of the Novell Compliance Management Platform.

After a number of reincarnations, Analyzer was included in the IDM Standard and Advanced Edition packages and is now available to all IDM folks.

NetIQ Analyzer for Identity Manager is an Eclipse-based tool that can help to understand your environment, analyze data from different sources, and sometimes fix some data problems.

The Internal Analyzer database (HyperSQL Database, HSQLDB) can work pretty well for a small test environment, but has a huge performance degradation issue when the number of records grow, that almost don't allow you to use Analyzer in a real medium size or corporate environment.

NetIQ recommends using the external database (MySQL) for work with big data volume, but unfortunately didn't provide any “official” documentation on how to do it.


Ensure that you shift from the local database (HSQLDB) to the external database (MYSQL) if you are importing data more than 40,000 records.


https://www.netiq.com/documentation/idm45/analyzer_admin/data/configprefs.html#prefsdatabasesettings




We had a number of requests on our Support Forum about this topic and when once again I failed to recommend a link to “official” information, I decided to create a “How-to configure Analyzer to use external MySQL database” myself.

Most of the time I work in MS Windows and I will provide step by step instructions for Analyzer/MySQL for the Windows platform, but similar configuration steps can be used for Linux.

  1. Download MySQL

  2. Current MySQL version 5.7.16 available on http://dev.mysql.com/downloads/mysql/ site



MySQL download site MySQL download site


I recommend you download offline the (full) installation package (385M).

offline installer offline installer


The current direct link to the MySQL MSI installer is:

http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-5.7.16.0.msi

The order of the product installations doesn't matter.

We can install Analyzer first and MySQL second or vice versa. Any order will work for us.

I will start with the Analyzer installation.

Install Analyzer: run install.exe from <IDM Installation DVD>\products\Analyzer folder.

a3

a4

a5

a6

a7

a8

a10


First step to continue working with the product it is required to add a product license.

a11

a12


When the valid product license is applied, we will be able to continue to use Analyzer.

a13


The next step is the MySQL installation:

Run the MSI installation file (mysql-installer-community-5.7.16.0.msi)

m1

m2


For our purpose (external DB for IDM Analyzer) we can use the Developer (Default) installation.

m3

We can skip the Visual Studio/ Python dependencies page and continue with the MySQL installation, Next>

m4

Execute>

m5

m6

m7

m8

Click Next to finish the configuration steps.

m9

Select Server Configuration Type (default Developer Machine)

Port Number (default 3306)

On the next page you must specify your MySQL instance Root account (admin) password.

m10

On the next screen, the installation wizard will continue the configuration of Windows service.

m11

m12

m13

m14

m15

Test the connection to your MySQL service on the next screen. (Check button)

m16

Apply MySQL Server Configuration, Next>

m17

m18

Configuration of MySQL server is successfully finished. Click the Finish button to complete the installation.

m19

Installation Complete.

m20

When the installation program is finished, it will execute the MySQL Workbench application.

The Workbench GUI shows that we have MySQL57 instance running on our workstation and this instance is listening for port 3306.

m21

Next step: Reconfigure Analyzer to work with MySQL database.

Select on the menu bar: Window > Preferences…

m22

Analyzer > Database Settings

m23

We will create a new MySQL alias

After the MySQL installation, the MySQL JDBC driver is installed to C:\Program Files (x86)\MySQL\Connector.J 5.1

We will add the MySQL JDBC folder to JDBC Classpath.

m24

m25

The Test Connection button will allow you to validate connectivity to installed MySQL Database instance.

If everything is configured correctly, we will see a “Connection was successful” message.

m26

Now we can apply the MySQL alias to Analyzer.

m27

Test Connection

Apply

m28

Press OK to reinitialize the DB connection.

m29

Congratulations! Now we are ready to use Analyzer with the external MySQL database!

 

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Comments
Nice one! Would be cool if you could add some details about how/where to obtain an Analyzer license.
Hi Lothar,
Analyzer included to both IDM AE and SE packages.
You can find Analyzer license in your NetIQ Customer Center> Software > Entitled Software> Novell Analyzer
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2016-12-31 02:10
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.