How do you get high-availability with a database-as-a-service?


The most critical aspect of all production systems is being able to ensure high-availability in case of critical failures. The traditional approach was to operate a disaster recovery site and fail-over clusters. This requires 24×7 maintenance and monitoring activities and adds the significant costs for hardware, software, and human resources engaged. Due to this, many companies opt-out of having the high-availability for their EAM system.

Thankfully, there is a new option with database-as-a-service (DBaaS) offerings being provided by all major database vendors. Providing a high-availability system for 10,000 users can now be achieved by filling the single web form. You will then be provided with a database service that is available 24×7 and all maintenance, monitoring, and backup activities are automated in the background.

We tested DBaaS offerings from several vendors such as Amazon, Microsoft, and Oracle and found all of them being able to deliver on their promise. Although some products like IBM Maximo and IBM TRIRIGA are not officially certified for these platforms, we managed to successfully migrate several clients to a DBaaS database on Oracle and MS SQL Server…

[Admin: To see other related posts, use the High Availability tag or SaaS tag.]

Continue reading

Advertisements

Why does running the ETL job for energy logs fail?


I know that TRIRIGA SaaS comes with predefined ETL jobs, and one of them is energy log fact. I have some energy logs on some buildings. However, all of my attempts to run the ETL job for energy logs have failed. Is there any missing parameter for me to add to make this work? I did try adding triEnvEnergyItem as a BO name, but no luck.

The ETLs each require different inputs depending on the ETL. Since, in general, ETL processing is a background process and runs through the scheduler, you would need to look in the server.log to see what the ETL needs if you are running it directly from the ETL Job form. You would also need to make sure that you have a license that allows you to run the ETLs, which would be a license that grants privileges to “Technology Metrics”.

Maybe this link will help: ETL and Metric Query Troubleshooting.

[Admin: To see other related posts, use the ETL tag.]

Continue reading

ValuD: How do you attain freedom with a TRIRIGA mobility solution?


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.]

Continue reading

Are file attachments in Outlook also attached in SMTP messages?


In the context of TRIRIGA Reservation Management (Reserve), if a user attaches a file in a meeting invitation (in Outlook) while booking a room, is that file going to be attached in the SMTP message that is sent to TRIRIGA? Has anyone tested this or have the ability to test this?

The concern is around confidentiality. If someone attaches a company confidential document and the message is sent over SMTP (non-secure) to IBM Cloud (TRIRIGA SaaS) with the attachment, the document was now exposed to the public internet.

In your scenario, the Send connector configured in Exchange is responsible for sending the message to TRIRIGA. I believe that, by default, the Send connector will also send attachments. There may be some configuration on the Exchange side that prevents or limits a particular Send connector from forwarding attachments.

[Admin: This post is related to the 05.23.17 post about setting up the Reserve SMTP Agent for Secure SMTP (SMTPS). To see other related posts, use the SMTP tag or Attachment tag.]

Continue reading

What are the differences between TRIRIGA on SaaS and on premise?


I have a TRIRIGA SaaS client, and administrators of my client have several questions about TRIRIGA SaaS services:

  • 1. What are the differences of the functions between TRIRIGA on SaaS and TRIRIGA on premise? Please provide a list of the differences.
  • 2. Can we use mail notifications to other users from TRIRIGA on SaaS?
  • 3. Can we make and incorporate BIRT reports into TRIRIGA on SaaS?

I wanted to respond to this, in case these questions still needed answers.

  • (1) The functionality in TRIRIGA SaaS versus TRIRIGA on-premise should be the same. If there is something that is not working that the client feels should be working, I would encourage your client to raise a ticket with the TRIRIGA SaaS team.
  • (2) Yes, email notifications should work provided that the SaaS server has a way of reaching the client’s mail server.
  • (3) Yes, the client should be able to make BIRT reports and incorporate them into TRIRIGA SaaS.

[Admin: This post is related to the 05.24.16 post by ValuD about SaaS with TRIRIGA, and the 11.13.15 post about TRIRIGA SaaS in the Cloud Shop.]

Continue reading

ValuD at IBM InterConnect 2017


March 19 – 23, 2017, MGM Grand & Mandalay Bay, Las Vegas, Nevada

IBM InterConnect is one of the largest events dedicated to Cloud, Internet of Things, and Watson. With over 25,000 attendees and 2000+ technical sessions, conducted by some of the most greatest and innovative minds in the business, InterConnect is the place to be to discover, learn and explore the best technology on the market.

As a premier business partner of IBM, ValuD will be participating as an IoT/Watson exhibitor and speaking at 3 breakout sessions including a joint session with IBM on lease accounting. You can find us at Booth 989 in the IoT/Watson section.

  • Session ID: 2879: Directions in Real Estate and Facilities Management
  • Session ID: 4471: TRIRIGA SaaS: Umpqua Bank’s Out-of-the-Box IWMS Implementation Story
  • Session ID: 4424: How Do You Manage Lands in a Cloud?

[Admin: This post is related to the 03.17.17 post by ValuD about meeting the ValuD team, the 03.15.17 post by ValuD about managing lands in a cloud (Utah Department of Natural Resources’ TRIRIGA SaaS implementation), the 03.08.17 post by ValuD about Umpqua Bank’s TRIRIGA SaaS implementation, and the 03.02.17 post about the InterConnect 2017 Bootcamp labs.]

Continue reading

FM:Systems FM:Interact success story at Drexel University


Prior to using FM:Systems Integrated Workplace Management System (IWMS), FM:Interact, the University had abandoned an obsolete Space Management solution and were largely using Excel sheets to “guesstimate” space utilization…

After investigated 6 different Space Management software providers, they chose FM:Systems because it met, and exceeded, these baseline requirements:

  • FM:Systems provided more out-of-the-box functionality than its competitors
  • FM:Systems had a vested interest in our success, because it offered direct contact during implementation and maintenance, with no third-party managing the process
  • The Software as a Service (SaaS) model meant FM:Systems had a lower cost of implementation and ongoing maintenance
  • The system allows for unlimited “general users” which was critical to the RCM mandate for transparency
  • The user interface was easier to navigate for University stakeholders than other products investigated
  • The most compelling reason for choosing FM:Systems? Their people.

[Admin: This post is related to the 08.01.16 post about the competitors of IBM TRIRIGA.]

Continue reading