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.
I'm gathering information for our migration from 4.3.6 to 5.2.3. I'd be grateful for any information on setting up mulitple MRE's for establishing development and production environments. Currently we are supporting these using domains. I was hoping that multiple MRE's would allow us to access development tables in one domain and production tables in the other. As it is now we can only access the production tables.
Can anyone offer any advice on the pros and cons I need to consider when deciding Single MRE vs Multiple MRE ?
Thanks
Posts: 132 | Location: Kansas | Registered: November 12, 2003
The tables accessed through the MRE are not controlled by the MRE domain, but rather the pathing in the profile of the user that is logged into the Reporting server. It sounds like the pathing to your data sources all resides inside the edasprof (i'm assuming this, so if i'm wrong, i'm wrong) you may want to set up development and production userids - each with separate pathing to the data sources.
You are correct my Edasprof controls the ODBC which points to my production environment. The ACX members contain the tablename path. This doesn't allow me to point to anything other than production (otherwise I effect production). My thought was two machines, two catalog directories of master file definitions and ACX members. The ACX on one machine would point to test the ACX on the other machine would point to production.
Is there a better way ...... ?
Posts: 132 | Location: Kansas | Registered: November 12, 2003
If you used the user profiles (.prf) instead of the edasprof.prf to set up your pathing, then each user can have different pointers - to different tables, we do this now. The problem you are having is a result of having the global profile control everything. Try investigating the usage of user.prf instead. It makes things much more flexible. Anytime I want to use test data - instead of prod, i just change my path - obviously this is something only an administrator can control - but if you have access to the profiles, I suggest creating prod and test users.
In MRE 5.2, you can associated a specific WF server or APP PATH setting to individual domains or even individual reports. If both your production and test tables are configured in the same webfocus server, you could store each set of tables (MFD/AFD) in its own application diretory. You could then create 2 domains (PRODDOMAIN & TESTDOMAIN), each pointing to a separate application directory.