Data Integration - Informatica

Informatica Perspectives

The Year of the Integration Competency Center (ICC)

John SchmidtThe cover story on the March 8th issue of Computerworld is “Swinging Toward Centralization”. It talks about the pendulum moving toward IT consolidation as organizations strive to save money and improve controls. This article is not alone. A growing number of analysts are talking about consolidation, Lean IT practices, and taking “a production line approach to integration”.  When you combine all this rhetoric with the industry fundamentals, the stage is set for 2010 to The Year of the ICC. [Read more]

No Comments

Data as an Asset Part 7: The Future - Agile Data-Driven Enterprises

John Schmidt This is the last of the Data as an Asset series and what better way to wrap up the theme than with a view to the future. As stated by Thomas Redman, author of Data Driven, “Your company's data is a key business asset, and you need to manage it aggressively and professionally.” The future vision then is around Agile Data-Driven Enterprises. [Read more]

No Comments

The Flip Side Of Data Assets: Data As A Liability

John SchmidtContinuing with the Data as Asset series, in this posting I explore the negative side and what can happen when data becomes a liability. Physical assets such as buildings, equipment, or even money, can become a liability if not managed properly; buildings can become unsafe to work in, machinery can be dangerous to operate, and business investments can turn into money-sinks. Similarly, data and information systems can also be assets that provide economic value to the enterprise or they can be liabilities that destroy value or put the business at risk if not managed well. Here are three common scenarios. [Read more]

No Comments

Data as an Asset Part 5: Case Study In Managing Data Assets

John SchmidtMy last post on this theme A Market-based Approach To Valuing Data, introduced the idea of establishing an internal data economy as a way to value and manage data assets. Here now is a specific scenario for how this could work. I apologize in advance for the length of the posting, so please bear with me. The level of detail is necessary to demonstrate how an internal market can function in a practical manner. [Read more]

3 Comments

A Market-based Approach To Valuing Data

John SchmidtAs per discussions in prior postings on Managing Data as Assets, yet another method for valuing assets is to use market prices (mark to market). This method works best in a market for a homogeneous product where no individual buyers or sellers can affect those prices by their own actions. Securities such as stocks and bonds fall into this category. If you own 1,000 shares of Informatica stock for example, you know exactly what they are worth at any time since there is a highly liquid market for them – it doesn’t matter what you paid to acquire the securities (except for tax purposes) and you don’t have to sell them to determine their value – you only need to look at what they are trading for at the moment. [Read more]

1 Comment

Calculating EVA For Data Assets

John SchmidtContinuing from my prior post Valuing Data Using Managerial Accounting Practices, you don’t actually need to put data assets on the public balance sheets to achieve the desired management focus You could use internal management accounting methods such as EVA (Economic Value Add). In EVA, operating costs that have long-run benefits (such as R&D, brand advertising, certain IT investments) are recorded as assets rather than operating expenses. EVA is generally calculated by line-of-business as EVA = NOPAT – (WACC * NOC)

  • NOPAT = Net Operating Profit After Tax
  • WACC = Working Average Cost of Capital
  • NOC = Net Operating Capital [Read more]

2 Comments

Use Lean to Integrate Systems Faster, with Less Cost and Risk

John SchmidtSome executives have told me that 40 to 70 percent of their IT budgets are devoted to integration. These are the same ones that still tackle integration on a project-by-project basis, causing unnecessary expense, waste, risk, and delay. They struggle with integration “hairballs”: complex point-to-point information exchanges that are expensive to maintain, difficult to change, and unpredictable in operation.

The solution is two new services that Informatica announced this week; Integration Factory Implementation and Automated Deployment Framework. These services compliment the Informatica platform and are another outcome of the work that went into creating the Lean Integration book which will be available in book stores soon (visit www.integrationfactory.com if you can’t wait). [Read more]

No Comments

Valuing Data Using Managerial Accounting Practices

John SchmidtAs a follow up to my previous post Data As An Asset Part 1 – Should Data be on your Balance Sheet?, let’s get back to the balance sheet question and ask it differently – how COULD an organization go about formally valuing their information assets?

There is a relatively straight-forward way to establish the initial value of data assets by simply adding up the costs associated with creating the data. In other words, we could quite easily figure out what it costs to initially create the data – the acquisition cost. Once we have the initial value established, we could use standard depreciation models such as straight-line or accelerated depreciation to account for the deterioration in the value over time. [Read more]

No Comments

Data As An Asset Part 1 – Should Data be on your Balance Sheet?

John SchmidtYou often hear people say “Information is our greatest asset”. If that’s true, why can’t we find “data” assets on the financial balance sheet? Some organizations do indeed capitalize IT investments, but primarily in order to spread the costs over a number of years and not because they are valuing their data assets. Occasionally you might find data on the balance sheet such as the customer lists valued at $14.5B on AT&T’s 2007 financial statements – but again this was a one-time event related to the acquisition of Bell South and not because AT&T systematically values their data. [Read more]

4 Comments

Lean Versus Agile (Part 3) – Large-scale Project Challenges

John SchmidtContinuing the Lean versus Agile discussion, these methods work well for small-scale projects, but are they effective for large programs? This post addresses the question “Should an Integration Factory do anything different when supporting a project that is using a waterfall methodology versus one that is using an agile methodology?” The short answer is no, you shouldn’t do anything different for one simple reason; focus on the customer and deliver what valuable from his/her perspective. [Read more]

1 Comment

Next,