Data Integration – an Underappreciated Discipline

Posted Posted in Uncategorized

Data Integration

an underappreciated discipline


Often, we find ourselves heavily focused on one area of Knowledge Systems development and lately it’s been Data Integration. Having just come from assisting a global agribusiness with BusinessObjects Data Services work and now enhancing our internal ABBIE technologies SSIS scripting for new augmentation sources and visualisation tool data preparation, we find some common challenges to all tools.

There are many insights we can share with this, so we will split them into parts over the next weeks, posting more as we can squeeze out the time. This post will start with the one closest to mind, security.

Invariably the security needed to “write” or “create” is not natively available, and needs to be requested more than once. This is because DBA’s often cannot test the level needed by the tool. In an ideal dev environment, all developers have all access to all systems and databases they need, so security becomes a testing consideration.

However, in many organisations, especially outsourced ones, that’s not the case, and Service Request after Service Request must be put through to get the access needed. It’s not uncommon for more than a week to pass before a developer can even start coding.

It’s doubtful the outsource partner minds lots of service requests as each one leads to someone being engaged, but the developer has now got less time and thus needs to find new shortcuts to get his or her code out in time for the test cycle. Shortcuts invariably are more expensive in the long run as they don’t conform to standards as closely, can be filled with coded logic to circumvent slower predefined transforms and often will lack documentation.

The takeaway is not so much for the BODS developer, as you will come across this when you start so it’s not something you can prevent, but for Business Analysts and planners, we suspect in most cases the security requirement for the developer does not feature high on your scheduling agenda.

May we suggest that in all future projects you change that, and you remove a major impediment to a quality, on time result?

3 ways Triatin Achieves Success by Helping Our Clients Achieve Success

Posted Posted in Uncategorized

It appears success is often down to three factors.

The courage to innovate, the willingness to measure yourself and the diligence to record what you are doing.

These are three of the ideals we at Triatin use to offer value to our clients.

By innovating we improve the solutions we offer our customers every time we engage on solving a business challenge for them.

By being willing to measure ourselves we know what we offer is more value, the key to our success.

And by having the diligence to record what we do, when we do it and what the result is, we can share the success directly with our clients.

At Triatin we work with an open information, project planned team based approach. Our clients are quoted with a detailed project plan that clearly shows how we intend to deliver to their needs.

Triatin clients can watch their projects achieve their milestones in real time, drill to the detailed logs of each task, and work with us to clear obstacles and reduce costs.

Test us. Give us your business technology challenge and watch how fast we can deliver a clear path forward for you.

Monday Muse

Posted Posted in Uncategorized
Monday, April 23, 2018

Does fixing transport have to be expensive and complicated? What about these ideas? If they are dumb, please elaborate, we love constructive criticism at Triatin.

Why don’t electric cars have replaceable batteries? We are not an electrical engineers, there must be some reason but a battery under the car between the wheels that can be replaced by pushing it out of the car from the side to be replaced with a recharged one cannot be impossible to achieve? Drive up, pay a fee, the system orientates the vehicle, the battery is replaced and drive off

Why don’t electric cars have solar skins? Park in the sun and your battery goes up while you work. Add a small portable VAWT and you could generate even more power. It can be popped up when you park and stowed when you are leaving?

Why don’t we drive smaller electric buggies, driving on to automated platforms that integrate the buggy onto fast moving cargo trains or driving onto flat bed trucks that can drive at high speeds, dropping our buggies off closer to our destination for a small fee?

However this may soon be academic as automated cars and passenger carrying drones replace the current fossil fuel system. We see an automated system where you subscribe to transport like you subscribe to Netflix, simply a service.

In fact that system could be integrated with other logistics where food, purchases and other items are delivered while transporting people. Smaller drones can disengage from your passenger drone and drop off that book your neighbour bought just before you ordered your trip.

Whatever happens Triatin will be here to help with the data.