As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
What I've done in the past is use MRE Web Services to do this. If you have the user's id's and names in a database (or file), you can run a series of 4 TABLE requests (1 per web service) that will set up the users account, set the password, assign the user a role, and finally add the user to a specific group. It would take a couple of hours to set it up, then you can reuse the same code anytime you have to add a new user.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
The last company I was with did this in Oracle. We used a clerical person to set up the user ids in MRE giving the users access to all but a few financial domains. We set up multiple Oracle tables with user id, region, country, station and access level. If an individual had station access then all they could see was information for their station, if they had country level then they could see all the stations in that country, etc. Global level allowed users to see everything. We had a subroutine that hit the Oracle tables and all that would come up in the drop down lists were the level that the users was allowed to see. This was time consuming to set up, but by doing it this way when we added a new tab or dashboard the security was already set up.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes
Posts: 755 | Location: TX | Registered: September 25, 2007
As the above reply yes there are way to accomplish this. Just a few notes: the Web Services described above requires that you have purchase the WebFOCUS Web Enablement that allows you to use the WebFOCUS Web Services. that is really only way to automate the process if you are using the default repository (file based). If you are using an RDBMS as the repository then you could write your own scripts to insert/update the tables. If you are usign AD then you could write a VBS programto do this. and last if you are using LDAP then you would need to utilize an LDAP script supported by the LDAP provider. Hope these all help
It is actually called the WebFOCUS Web Services Enablement Option. It allows WebFOCUS content including Report Caster content (if you have Report Caster) to be published as a Web Service, so that other applications that want to talk via Web Service can call WebFOCUS/Report Caster.