Using the Profiles population wizard
Use the Profiles population wizard to populate the HCL Connections Profiles database with data from the LDAP directory.
You can populate the Profiles database with the help of the population wizard, as described here, or manually as described in the Manually populating the Profiles database topic. You might choose to use the population wizard to simplify the properties mapping process from your source to the target Profiles database.
Ensure that you have created a Profiles database, and installed and configured Tivoli® Directory Integrator and an LDAP directory.
- Run the population wizard on the system where IBM® Tivoli Directory Integrator is installed.
- On Linux, the user account that will run the wizard to populate the database must be a member of the group that owns the database instance (db2inst1 for DB2).
- If you need to configure multiple systems with Profiles data, you can run the wizard in silent mode. For more information, see Using the Profiles population wizard in silent mode.
- The population wizard populates only those entries where the value for surname is not null.
- You can run the population wizard before, during, or after installing HCL Connections.
For additional and related information about configuration and mapping properties see Manually populating the Profiles database.
To populate the Profiles database, complete the following steps:
Log into the system where Tivoli Directory Integrator is installed as the root user or system administrator.
(Linux™): Grant display authority to all users by running the following commands under the root user or system administrator:
Note: If granting display authority to all users is a security concern for you, change the command to grant display authority to a specific user or users. For more information about this command, consult with your Linux administrator guide.
Add the user account that will run the wizard to the group that owns the database instance (for example, to the db2inst1 group for DB2).
(RHEL 7.4 only) Update the swt gtk jar file as explained in the KB Article, The populationWizard does not start on RHEL 7.4 using TDI 126.96.36.199.
Copy the Wizards directory from the HCL Connections installation media to the system where Tivoli Directory Integrator is installed.
Important: Microsoft™ Windows™: If you are installing from disk or ISO, change the permissions for the Wizards folder from Read Only to Write or the population wizard will fail.
Run the following script from the Wizards directory:
Note: If the wizard does not run correctly, you might need to edit the populationWizard.sh file and enter the correct JRE/JVM path for your system The populationWizard.sh file expects the path to be jvm/linux/jre/bin.
Microsoft Windows: populationWizard.bat
- On the Welcome page of the wizard, click Launch Information Center to open the HCL Connections Information Center in a browser window. Click Next to continue.
Select Default settingsor, if you are resuming an earlier session, click Last successful default settings and click Next.
Note: This page is shown only if you have already used the wizard to populate the Profiles database.
Enter the location of Tivoli Directory Integrator and then click Next.
Note: This page is shown only if the wizard cannot automatically detect your Tivoli Directory Integrator directory.
Select a database type and click Next.
Enter the following information about the database, and then click Next:
Host name : The name of the system that hosts the database.
Port : The communications port for connecting to the database. Add a new port number or choose one of the following default port numbers:
DB2® : 50000 Oracle : 1521 SQL Server : 1433
Database name : The default name of the database is PEOPLEDB.
**Note:** There is no default name for the Oracle database, Instead, enter the name of the database instance.
JDBC driver library path : Enter the path to the JDBC driver on the host machine. For example: IBM/sqllib/java.
DB2 : You can find the db2jcc.jar and db2jcc\_license\_cu.jar files in the ibm/db2/v11.1/java directory. Oracle : Download the [Oracle JDBC driver ojdbc7.jar from the Oracle web site](https://www.oracle.com/database/technologies/jdbc-drivers-12c-downloads.html). SQL Server : Download the [SQL Server JDBC 4.2 driver](https://www.microsoft.com/en-us/download/details.aspx?id=54671) from the Microsoft web site and follow the instructions to extract the driver files. HCL Connections uses the sqljdbc41.jar file.
User ID : Enter your user ID. This must be a database user who has write access to the Profiles database. For DB2, the default value is LCUSER. For Oracle and SQL Server, default value is PROFUSER. These user names are automatically created when you create the database.
Password : Enter your password.
Enter the following properties for the LDAP server, and then click Next:
LDAP server name : The host name or IP address of the LDAP server.
LDAP server port : The default port is 389. If SSL is selected, the default port is 636.
Use SSL communication : Select the check box to enable SSL.
(Optional) Create an empty truststore file where you can store trusted LDAP server certificates. (Complete this step if you want to use SSL. If you already have a truststore file that contains your LDAP server certificates, you can skip this step.) The Profiles population wizard downloads the LDAP server certificates from your LDAP directory for you.
Start the iKeyman utility by running the following file:
- Windows: TDI_Install_directory\jvm\jre\bin\ikeyman.exe where TDI_Install_directory is the directory where Tivoli Directory Integrator is installed.
Note: On the Windows 2008 and Windows 2012 operating systems, right-click ikeyman.exe and select Run as administrator.
Click Key Database File from the menu bar and then click New.
Select JKS or PKCS12 as the key database type.
Save the new file to an appropriate location and click OK.
Enter a password in the Password Prompt dialog box and then confirm the password. Click OK.
Note: You need this password when you use the Profiles population wizard.
Exit the iKeyman utility.
The Profiles population wizard can use the new truststore file to communicate with your LDAP server in SSL handshaking mode. It can also use the file when fetching data from your LDAP.
If you selected SSL when you entered the LDAP properties, you are asked to enter the following keystore properties:
Truststore file : File where trusted server certificates are stored. Used when SSL handshaking is performed.
Keystore password : Password to access the keystore.
Keystore type : Format of the trusted server certificate. Currently only JKS and PKCS12 are supported in Java™.
If the LDAP server certificate is not in the truststore, a message appears that asks you to permanently accept the certificate in the truststore file. If you do not accept it, the wizard cannot connect to the LDAP server with SSL and will not continue with the population task.
Note: Ensure that the global.properties file in Security Directory Integrator is configured with the file trust store name, password and type you just created. For further instructions, see Client SSL configuration of IBM Security Directory Integrator components in the IBM documentation.
Enter the authentication details for the Bind distinguished name (DN) and Bind password, and then click Next.
Note: The Profiles population wizard does not support anonymous binding for LDAP. To populate the Profiles database using anonymous binding, you must populate the database manually.
Enter the details of the Base distinguished name (LDAP user search base)and LDAP user search filter, and then click Next.
Map LDAP attributes or JS Functions to the Profiles database fields.
- The uid, guid, distinguishedName, surname, and displayName values in the Database Fields column must have mapped attributes in the LDAP Attributes or JS Functions column.
- If you are prompted to supply a profile type value, see the Profile-types topic for available options.
You can choose to run the following additional tasks:
Countries : Add country data to each profile.
Departments : Add department data to each profile.
Organizations : Add organization data to each profile.
Employee types : Add employee-type data to each profile.
Work locations : Add location data to each profile.
Select Yes if you want to mark the profiles of each manager.
- For all the entries in this list (except Mark managers), you need to prepare corresponding CSV files with the required information. An Employee Types CSV file might include regular=HCL Employee and manager=HCL Manager. You can edit the profiles-config.xml file to specify whether you want to display the code or the value, where regular or manager are the employee type codes stored in LDAP and HCL Employee or HCL Manager are the values.
Examine the CSV files in the Wizards/TDIPopulation/TDISOL/OS/samples directory, where OS is your operating system, to see the input file format of the optional tasks:
Countries task : isocc_sample.csv
Departments task : deptinfo_sample.csv
Organizations task : orginfo_sample.csv
Employee types task : emptype_sample.csv
Work locations task : workloc_sample.csv
Review the Summary page to ensure that the information you entered in the previous panels is correct. Click Configure to begin populating the database.
Review the message on the Result page. If necessary, click View log to examine the log in detail. Click Finish to exit the wizard.
The Profiles population wizard has populated the Profiles database with data from your LDAP directory.
Parent topic:Adding source data to the Profiles database