John Schmidt

John Schmidt
John Schmidt is vice president of Global Integration Services at Informatica Corporation where he advises clients on the business potential of emerging technologies and directs the company’s Integration Competency Center Practice. Previous employers include Wells Fargo Bank, Bank of America, Best Buy, American Management Systems, and Digital Equipment Corporation. John has written hundreds of articles on Systems Integration, Enterprise Architecture, and Program Management, is a frequent speaker at industry conferences, and served as Director and Chairman of the Integration Consortium from 2002-2009. He wrote the first book in the world about ICC’s in 2005, Integration Competency Center: An Implementation Methodology, and followed it up in 2010 with Lean Integration: An Integration Factory Approach to Business Agility. For further information visit http://www.integrationfactory.com.

If you Want Business to “Own” the Data, You Need to Build An Architecture For the Business

If you build an IT Architecture, it will be a constant up-hill battle to get business users and executives engaged and take ownership of data governance and data quality. In short you will struggle to maximize the information potential in your enterprise. But if you develop and Enterprise Architecture that starts with a business and operational view, the dynamics change dramatically. To make this point, let’s take a look at a case study from Cisco. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Business Impact / Benefits, Business/IT Collaboration, CIO, Data Governance, Data Integration, Enterprise Data Management, Governance, Risk and Compliance, Integration Competency Centers | Tagged , , , , | Leave a comment

Integration, So Your Kids Can Understand

Rob Karel has been doing a nice job explaining Big Data, Metadata and other topics for Mom, so now I’d like to tackle another key group of stakeholders – your children. My kids have been asking me for years what I do at work.  It hasn’t been easy to come up with an explanation that they can understand, so I usually just end up with something like “I go to meetings and stuff.” That works for a while, but it’s not very informative or inspiring.  So if their friends ask “what does your dad do for work”, I can’t imagine what stories they make up. So here goes my attempt to explain to a sixth-grader what the job of a systems integration professional is. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Integration, Integration Competency Centers | Tagged , , , , | 1 Comment

One-Click Data Management

There are three reasons why we haven’t achieved 1-click data management in a corporate data marketplace. First, it wasn’t a problem until recently.  The signs that we really needed to manage data as an asset across the enterprise only appeared about 20 years ago.  Prior to that, data management occurred at the application system level and we didn’t need a separate focus on Information Asset Management (IAM) at the enterprise level.  The past five years however have a seen a strong growing awareness of the challenges and need for IAM; to a large degree driven by big-data opportunities and data privacy and confidentiality concerns. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Business/IT Collaboration, Data Governance, Data Integration, Data Integration Platform, Enterprise Data Management, Integration Competency Centers | Tagged , , , , , | Leave a comment

Data Management Is No Longer A Back Office Function

A front office as defined by Wikipedia is “a business term that refers to a company’s departments that come in contact with clients, including the marketing, sales, and service departments” while a back office is “tasks dedicated to running the company….without being seen by customers.”  Wikipedia goes on to say that “Back office functions can be outsourced to consultants and contractors, including ones in other countries.” Data Management was once a back office activity but in recent years it has moved to the front office.  What changed? (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Business Impact / Benefits, Business/IT Collaboration, CIO, Data Governance, Enterprise Data Management, Integration Competency Centers, Master Data Management | Tagged , , , , | 2 Comments

Stop The Hand-Coding Madness!

For some of you “old timers” in the IT industry, you will remember the days when we used to hand-code our own Database Management Systems. Of course today we just go out and buy a general purpose DBMS like MySQL, Oracle, dBASE, or IBM DB2 to name a few. Or, if we wind the clock back further, there was a time when we used to write our own operating systems. Today it comes with the hardware or we can buy an OS like UNIX,  iOS, Linux, OS X, Windows, and IBM z/OS. And I can still remember hand-coding network protocols in the days before TCP/IP became ubiquitous.  Today we select from UDP, HTTP, POP3, FTP, IMAP, RMI, SOAP and others. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Integration, Data Integration Platform, Integration Competency Centers, Uncategorized | Tagged , , , | 1 Comment

Garbage In, Treasure Out: Real-World Use Cases

Last week I described how Informatica Identity Resolution (IIR) can be used to match data from different lists or databases even when the data includes typos, translation mistakes, transcription errors, invalid abbreviations, and other errors.  IIR has a wide range of use cases.  Here are a few. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Big Data, Data Governance, Data Integration, Enterprise Data Management, Identity Resolution, Integration Competency Centers | Tagged , , | Leave a comment

Garbage In, Treasure Out

Even in “good” data there is a lot of garbage. For example a person’s name.  John could also be spelled as Jon or Von (I have a high school sports trophy to prove it).  Schmidt could become Schmitt or Smith. In Hungarian my name is Janos Kovacs. Human beings entering data make errors in spelling, phonetics, and keypunching.  We also have to deal with variations associated with compound and account names, abbreviations, nicknames, prefix & suffix variations, foreign names, and missing elements. As long as humans are involved in entering data there will be a significant amount of garbage in any database.  So how do we turn this gibberish into gems of information?

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Integration, Data Transformation, Identity Resolution, Integration Competency Centers | Tagged , , , | Leave a comment

Four Key Metrics To Hold Outsourced Suppliers Accountable

Whether you are establishing a new outsourced delivery model for your integration services or getting ready for the next round of contract negotiations with your existing supplier, you need a way to hold the supplier accountable – especially when it is an exclusive arrangement. Here are four key metrics that should be included in the multi-year agreement. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in CIO, Customer Services, Data Governance, Data Integration, Enterprise Data Management, Integration Competency Centers, Professional Services | Tagged , , , , , , | Leave a comment

From RASP to Agile

If you have been following publications in the Potential at Work Community or any number of Linkedin discussions such this one on the DrJJ group (a think-tank for information management best practices), you will have noticed the Agile methodology topic come up time and time again. For instance, check out the article Architect Your Way From Sluggish to Speed or the video Focus on Agility Adaptability.  It hasn’t always been this way. For many years the architectural focus was on RASP.

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Integration, Enterprise Data Management, Integration Competency Centers | Tagged , , , , , | Leave a comment

Calling All Architects To Join A New Career-focused Community

In the Information Age we live and work in, where it’s hard to go even one day without a Google search, where do you turn for insights that can help you solve work challenges and progress your career?  This is a tough question.  How can we deal with the challenges of information overload – which some have called information pollution? (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Big Data, Business Impact / Benefits, Business/IT Collaboration, Data Governance, Data Integration, Data Integration Platform, Data Services, Enterprise Data Management, Governance, Risk and Compliance, Integration Competency Centers, Pervasive Data Quality | Tagged , , , , | 1 Comment