Monday, June 17, 2013

Application Integration Reveals System Development Issues

By Peggie K. Lambert


Getting different applications to talk to each other is a problem faced by many companies. Application integration is particularly troublesome when legacy systems are involved, and transferring data between old mainframe systems and more modern applications can be cumbersome and time-consuming. A good deal of time is spent on ensuring this happens, and software is often available to help with the process.

There is a lot of middleware around designed to help overcome these problems, and this is often very helpful. Failing this, a procedure to download, from one database, convert the data, then upload to another database might be necessary. Such procedures are often unstable and demand the attention of highly skilled people.

Originally it was felt that object oriented databases would overcome these problems for new applications. However, many applications are developed independently, and the problem of duplicate entities persists. The solution would be to have one database, with all applications making use of it, especially for common data.

Different application packages will still have their own databases, and this could easily lead to duplication of entities and redundancy. The need for middleware to capture or transfer common data is once more created. As it often happens that packages are acquired, this scenario is an ongoing problem for most organizations.

What is needed to resolve the situation today is a situation where an enterprise database with standard modules to update, maintain, and query the common data is created. Any new applications would then simply interface with that central database. Application specific data could be integrated with the enterprise database or kept separate, as appropriate.

Such a simplified view of company date is still completely futuristic. The power of computer hardware makes it possible for inefficient. Sub-optimal configurations to survive. Perhaps the IT professionals could learn from manufacturing, where the lesson was learned long ago that keeping older, inefficient, machinery because it had been paid for and was still work was an ineffective approach, which lowers quality and productivity.

A disproportionate amount of time and money is absorbed by application integration. Many smaller companies cannot deal with the complexities, and simply choose to live with the problem. In time it is possible that a move might be started towards rationalizing the whole approach to applications. Maybe one day everybody will look back and laugh at the current state of the art, after computers have fully emerged from the Dark Ages of systems development.




About the Author:



No comments:

Post a Comment