Description:


When you use LDAP with TIBCO BusinessWorks™ ProcessMonitor(BWPM) server then there is need of manually configuring LDAP setting in BWPM server.  If you have more BWPM setups and willing to use same LDAP setting for each of them then in order to use it you have to manually configure LDAP settings in BWPM server, However as same settings needs to be done manually for each BWPM setup  so you can automate LDAP config from one setup to another by running SQL queries in BWPM database..

How to automate LDAP settings and users sync in TIBCO BusinessWorks ProcessMonitor(BWPM) from one system to other system.

Steps for automating LDAP configuration from one setup to another on classic TIBCO BusinessWorks ProcessMonitor(BWPM) setup.

1). Create BWPM setup with database user BWPM3 and do all LDAP settings.

2). Execute the following query to ensure LDAP configuration is saved successfully. Here, the database user was BWPM3.

select * from BWPM3.NJAMS_T_CONFIGURATION where name like 'ldap%';

You will get the result (rows with LDAP config).

3). Create another setup and do database settings.

4).  For adding LDAPconfiguration old/existing setup to a new set up with database user (BWPM3K), run the following query* where BWPM3 is the database user of the old/other setup.

INSERT INTO BWPM3K.NJAMS_T_CONFIGURATION (DOMAINNAME, COMPONENT, NAME, VALUE, DESCRIPTION, EXPIRY_DATE,USERNAME) select DOMAINNAME, COMPONENT, NAME, VALUE, DESCRIPTION, EXPIRY_DATE,USERNAME from BWPM3.NJAMS_T_CONFIGURATION where name like 'ldap%';

*Provided Instance name and user used as admin is same. if not use below query after modifying it as per your new setup.
INSERT INTO BWPM3K.NJAMS_T_CONFIGURATION (DOMAINNAME, COMPONENT, NAME, VALUE, DESCRIPTION, EXPIRY_DATE,USERNAME) select NEW_InstanceNAME, COMPONENT, NAME, VALUE, DESCRIPTION, EXPIRY_DATE,NEWUSERNAME from BWPM3.NJAMS_T_CONFIGURATION where name like 'ldap%';

5). Log into the new setup and navigate to LDAP settings. You will see the configuration as that of old/other setup.

6). Select the test button. It will fetch user roles. Do synchronization and it will add user and roles to BWPM.