Wednesday, January 25, 2012

The Redefinition of Integration….. or Not


By David Akka
Over the weekend I flew to the final destination of my tour of Australia, Ayres Rock, and you may laugh but I spent the time in the airport lounge catching up on the very many reviews of 2011 in the world of technology. One which particularly caught my eye was The Most Significant Integration Story of 2011 by Loraine Lawson. In her article Lawson suggested that “the idea of what we mean by ‘integration’ has evolved substantially this year, from a focus on separate tools and particular types of integration to a more … well, integrated and strategic approach”. This made such interesting reading to me as each one of the 4 of the changes Lawson found, being called for by her peers, already exist in our own integration solution which has been around for at least a decade!

Adding data quality and master data management (and perhaps governance) to data integration tools – our integration tool provides;
  • Data Conflict /Error and Resolution- allowing the user to configure the desired response and includes a recovery policy for any data conflict/error handling as part of the underlying technology
  • Management, Monitoring & Audit- adding an audit trail to any step of the process using a “business-style” method (like working with MS Excel functions) rather than scripting technology, keeping registration and logs of all transaction to easily create adetailed audit log
A reduction in overall time spent resolving technology integration issues – our integration tool allows;
  • Easy access to various sorts of data sources including DBMS (such as MS SQL, Oracle, DB2, Pervasice, MySQL), ODBC accessible data sources, XML documents, and Flat files
  • Visual mapping of data fields from the selected data course to the selected destination
The data mapper 
  • Our built in monitor provides the project supervisor with a  detailed information about the progress of every business process from a top level overview to the very detailed view of every step in the process
  • While adding an audit trail to any step of the process
Reduction in time taken to integrate new applications
  • Our solution supports executing the same project over all major platforms
  • Projects can directly connect and utilise data sources from all the leading DBMSs and can also connect to any other DBMS via ODBC.
  • The solution comes with its own Component SDK which enables designers to rapidly and easily create their own customised components to any application
The crux of the argument was a call for the integration of all three branches of integration: data, application and business process — into one overarching enterprise approach to integration.This is exactly what our tool has been designed to provide and has been providing for customers across the globe for the last ten years. This begs me to question  is the call for change necessary when the solution already exists?
Lawson concluded by hoping 2012 will “help start us on the path toward making these ideas a reality” well thankfully I can continue my trip safe in the knowledge that our integration tool is already a reality and we at Magic are 10 years ahead of trend, a great place to be!
David Akka is the Managing Director of Magic Software (UK) Ltd and have worked with Magic Software for over 14 years.