Informatica Perspectives

The main goals of any Application ILM project are to reduce cost, improve application performance while maintaining compliance.  To meet these goals, data has to be moved from a production database to either an online, accessible archive or purged completely from the system.  In either case, data is deleted from production.  Deleting data can have a significant impact on the production system’s performance if not executed carefully.  However, once the data is gone – the benefits have a ripple effect.  Production tables are smaller and more manageable.  Recovery times and maintenance windows can be reduced.  The cost of managing a smaller production database is reduced proportionally with the amount of data removed. 

[Read more]

The 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]

Good architecture is the foundation required for agile systems that are responsive to business needs. We see that with SOA, which has been missing a vital piece of its architectural approach – from the data. Since it came about in its current form in the early-to-mid 2000s, service-orientation (mainly focused on applications) has existed in a separate world from data management.

Problem is, an SOA-enabled infrastructure with bad data flowing through it can be useless and even dangerous. One commentator even compared SOA to a mosquito that can deliver payloads of bad data (”viral data”) at lightning speed all across the enterprise — pandemic style — before it can be stopped. [Read more]

Loraine Lawson did a great job covering the topic of the integration challenges around the cloud and virtualization. She reports that “…a recent Internet Evolution column [by David Vellante] looks more broadly at the cloud integration question and concludes that insufficient integration is holding up both cloud computing and virtualization.”

In fact, what currently limits the number of cloud deployments is the lack of a clear understanding of data integration in the context of cloud computing. This is a rather easy problem to solve, but it’s often an afterthought.

The core issue is that cloud computing providers, other than Salesforce.com, don’t consider integration. Perhaps they are thinking, “If you use our cloud, then there is no reason to sync your data back to your enterprise. After all, we’re the final destination for your enterprise data, right?” Wrong. [Read more]

While the market is showing signs of recovery from the "Great Recession" most state budgets have been feeling the squeeze from the lag in recovery. In a recent article titled The Sorry State of Finances, Liam Denning explained that, "55% of state revenue, before federal transfers, comes from personal and corporate income tax." Denning also stated that, "the first three quarters of 2009 were the worst for state tax since at least 1963."

There is an apparent lag between recovery in the private sector and a state receiving tax revenue. So what can states do about this problem while they suffer in the red? Mr. Denning said, "Since states can't run general funding deficits, closing gaps mean raising taxes, cutting services and resorting to one-time measures." Mr. Denning's list of solutions is certainly accurate, but does it include all options that states have? What about employing new technology to discover fraud or recover uncollected revenue? [Read more]

This week, I attended a CIO conference in Philadelphia, for the first time in a couple of years. It was really good to hear them talk about their experiences, goals and issues, and to talk with some of them one on one. It spurred a bunch of new thoughts, which I’ll be writing about in a series of upcoming blogs. This first posting is on CIOs playing offense.

In my last posting, I talked about the Dr. Jekyll/Mr. Hyde nature of data—data being both an asset and a liability. The CIOs talked about playing offense vs. defense. They really wanted to be engaged with business transformation and growth initiatives. But many were saddled with cumbersome, expensive IT environments that sucked up 90% of their IT spend and resources just to “keep the lights on”. In other words, they were spending almost all their time and energy playing defense. [Read more]

Over the last few blogs, we have stepped through a project to implement Information Lifecycle Management (ILM) on corporate databases.  First, we evaluated the target databases, then we determined the Business Objects and assigned retention periods to the data – including both Legal and Operational requirements.  Now that we are ready to start applying the retention policies and deleting data, it is a good idea to set up an archive database as an intermediate repository for business objects classified as legal records.
[Read more]

I am very fortunate to have a CIO role that extends beyond the traditional responsibilities of IT. Part of my role includes the strategy and implementation of the recently launched Informatica Marketplace.

The Informatica Marketplace has generated a lot of buzz with our customers and partners. Last week while I was presenting at the Pacific Crest Annual Cloud Computing Conference I heard the excitement about our new offering from many of the attendees. Mostly, people appreciated our continued thought leadership and commitment to providing an open platform to host solutions for data integration, data quality and data management. And yes, it is an open platform to host solutions that not only support Informatica, but other vendors too - even competitors. Our fundamental belief is that the hand of free enterprise will ultimately win, so we are willing to provide an open platform to do so.

Here are a few questions I've heard and answered over the last few weeks: [Read more]

Today Informatica announced that Bay & Bay Transportation has used Informatica Cloud Services to achieve a six month project payback on their total Salesforce.com investment and a 900 percent return on their critical data integration project.

Bay & Bay is using the turnkey, on-demand Informatica Cloud Services to provide robust, bi-directional synchronization between its logistics management databases and applications with Salesforce CRM. Using an intuitive web based integration wizard, the company automatically maps source and target fields, configures powerful data transformations, and sets automated synchronization schedules. And being a true multi-tenant cloud-based service, there is no hardware, software, or infrastructure for them to install, manage, or maintain.

[Read more]

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]