You can configure TRIRIGA to use Tivoli Directory Integrator as its ETL runtime engine to run ETLJobItems from within TRIRIGA.
Before you begin
Install Tivoli Directory Integrator, if not already installed, on all the TRIRIGA systems that could run a TDI ETL Job Item. During the TDI install:
- Make note of the installation directory you enter on the Destination panel. You will enter this value later in TRIRIGAWEB.properties.
- Select either installation type. TRIRIGA requires only the TDI Server component.
- When prompted for the location of the Solution Directory, you can select any option. TRIRIGA specifies its own solution directory at runtime. However selecting the option “Use Install Directory” may simplify troubleshooting.
- Make note of the value you enter in the Server Port field on the Server Port Values Panel. You will enter this value later in TRIRIGAWEB.properties.
- Clear the “Start the Configuration Editor” check box on the Install Complete panel.
- Note: This step is very important for TDI/TRIRIGA integration to work. After you have installed Tivoli Directory Integrator, update it with the recommended fix packs (per TRIRIGA support matrix). TDI must be at least at FP04 (18.104.22.168) or it will not automatically start the TririgiaETLDispatch.xml assembly line which will result in ETL job items failing to run successfully.
- Edit TRIRIGAWEB.properties file to enable TRIRIGA to manage TDI server. Set the following properties…
- Install a JDBC driver library so that Tivoli Directory Integrator can use it to access TRIRIGA database…
- Edit TDI global.properties file to allow TRIRIGA to check and stop the TDI server from localhost without requiring authentication and authorization certificates. Set the api.remote.ssl.on property to false to tell TDI to trust requests from localhost…
- Start Tivoli Directory Integrator Agent from TRIRIGA Admin Console and verify that it starts successfully…
[Admin: This post is related to the 08.03.16 post about installing, upgrading, or uninstalling TRIRIGA TDI, and the 05.01.16 post about documentation on developing TDI with TRIRIGA. To see other related posts, use the TDI tag.]
What is the best way to implement a mobile app that will record the time spent in maintenance? Is the OSLC integration the best way to do this connection?
[Admin: To see other related posts, use the Mobile tag or OSLC tag.]
Watson Analytics is an intuitive, cloud-based analytics tool that will help TRIRIGA users explore their data for insights and display findings as dashboards and infographics for easy sharing. All without having to become a data scientist.
Watson Analytics guides data discovery and predictive analytics by using automatic visualizations and enables dashboard creation so that you can get insights and make informed decisions. Pairing Watson Analytics with data from TRIRIGA enables you to explore your integrated workplace management processes and obtain new insights on your day to day operations. The IBM Watson Analytics service will allow you to discover patterns and meanings in your data.
The TRIRIGA Connector for Watson Analytics gives you the ability to export your TRIRIGA data into Watson Analytics. With Watson Analytics, you can tune data, discover insights to help solve your business problems, and display your findings…
[Admin: To see other related posts, use the Watson tag or Analytics tag.]
Sometimes when using TRIRIGA CAD Integrator “Smart Attach”, some of the spaces are not being uploaded. There were 3D shapes around some spaces. There were values greater than 0 on z= dimension.
TRIRIGA does not support 3D polylines. You may have shapes with a value greater than zero on the z= dimension. You can find these using the AutoCAD PLIST command. To resolve this issue, it is necessary to use the AutoCAD “Flatten” command to force all polylines to be 2-dimensional. Other things to check: (1) The polylines are closed, (2) The shape and labels are on the layer you are selecting during the Smart Attach process, (3) The label is within the polyline boundary.
[Admin: To see other related posts, use the Smart Attach tag.]
I would like to see an example of running an ETL job item, because simply running the process fails. When users see the activated record, they assume they can click “Run Process” and get results. But you need to enter a set of restraining data to get results.
Every ETL job item is different. You must fill in the record information to get the results necessary for the transformation or processing. More information can be found at the following link: IBM TRIRIGA – Running ETL transforms. This blog entry will describe a sample run of a Survey Fact ETL job item.
- First, from the menu, click on Tools > Job Scheduling > ETL Job Item.
- Then search for “Survey Fact” and open the record. It’s recommended that you click on More > Copy to create a copy that you can modify, test, and play with.
- After that, change the name to an friendly name and enter at least these mandatory fields: Date, Start Date, Fiscal Period, and End Date.
- For the Date field, take notice of the “Quarter” and “Month” to enter the other subsequent Start Date, Fiscal Period, and End Date.
- See the example for “Q2/2017 – June”. After all of the fields are entered, click Save. Then you can click Run Process.
- The record window will close. Then you can see “Processing” for the status of the record.
- After that, you can open it again and it should show “Completed” as the status. You can also click on the Workflow Instance tab to see the completed workflows.
[Admin: To see other related posts, use the ETL tag.]
There has been a running debate on how to define a “real” mobility solution for IBM TRIRIGA – do we depend on a UI/UX framework or on commercially available solutions?
A UI/UX solution is a good platform solution that serves as an extension of the desktop TRIRIGA solution, but definitely has its limitations particularly for offline capabilities and keeping development costs in check. Mobility solutions need to operate offline and to leverage the native capabilities of the mobile device and platform. Based on our interaction with a variety of customers, we found some key challenges in evaluating the IBM mobility technology options…
How can we help?
Having executed multiple IBM TRIRIGA implementations, ValuD knows and anticipated the issues faced by customers. Given our in-depth expertise, ValuD designed a mobility solution solely for IBM TRIRIGA.
ValuD’s IBM TRIRIGA mobility solution – MobilD – was developed on true MADP (Mobile Application Development Platform) called Xamarin, an open source platform for developing MobilD. Microsoft acquired Xamarin recently and they made the entire development toolkit free to increase the market penetration. Xamarin, a widely known MADP, has thousands of application developer networks that can help organizations acquire the necessary skills for future development or management.
Another key factor is the choice of middleware solution; most current vendors use a “proprietary” middleware solution that needs a footprint on one of the TRIRIGA servers. MobilD’s middleware choice is Microsoft Azure which is a hosted solution and does not need any footprint on TRIRIGA servers and can also work with your SaaS solution or on-premise solutions…
[Admin: To see other related posts, use the ValuD tag or UX Framework tag.]
I have an issue where it is not possible for non-Admin users to trigger the Create state transition through our OSLC interface. Instead, we get the following error:
2017-06-27 13:08:10.301 UTC ERROR [com.tririga.platform.integration.oslc.OslcRequestDispatcherImpl](Default Executor-thread-34280) Failed to read message: null
2017-06-27 13:08:10.301 UTC ERROR [com.tririga.platform.integration.oslc.OslcRequestDispatcherImpl](Default Executor-thread-34280) Exception in OSLC call: com.tririga.platform.integration.oslc.OslcException. message=java.lang.ClassCastException: com.tririga.platform.metadata.domain.BoStateTransitionId incompatible with com.tririga.platform.metadata.domain.gui.GuiStateTransitionMetadata
The fact that I am able to create and associate the record using an Admin user says to me that this is related to permissions, but I’ve made sure that the user has full security access for both the BO/form it is trying to create, the BO/form that it is attaching it to, and all other BOs/forms that are associated to it, and it still gives me the error above.
When I open the created record that my Admin user created, it looks to be correct. But when I open the one that the non-Admin user tried to create, it shows an empty record. None of the fields are saved in a null state, which of course is because it didn’t get created, the Create state transition was not triggered. Any idea of what is causing this issue? And how to resolve it?
[Admin: To see other related posts, use the OSLC tag.]