Data Integration - Informatica

Informatica Perspectives

Breakfast In The Cloud

Darren CunninghamOver the past few weeks we’ve been talking to Informatica customers about cloud integration at the Informatica 9 World Tour events. In most of the cities, we’re hosting a Cloud Breakfast to dive in to what Gartner has listed as one of the top 10 strategic technologies for 2010. Not surprisingly, interest has been widespread. Attendees include people in IT and line of business (LOB) roles; people with PowerCenter skills and long-time Informatica Cloud customers; CRM administrators and IT architects; sales and marketing operations; ISVs and quite a few consultants.

One thing that they all have in common is that they’re thinking about the opportunities and challenges that the shift to cloud computing represents. As one attendee put it, “we can either get on the train or get run over by it!”

[Read more]

No Comments

Archiving And Purging

Julie LocknerThe 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]

No Comments

Proposing Simplified Architecture For A Complex Age

Joe McKendrickGood 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]

No Comments

Applying Retention Schedules To Database Data

Julie LocknerOver 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]

No Comments

Tell Me All About The Informatica Marketplace

Tony YoungI 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]

2 Comments

Cloud Integration Drives CRM And Sales Success

Darren CunninghamToday 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]

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

Keeping Too Much Data? Delete It!

Julie LocknerOne aspect of an Information Lifecycle Management (ILM) project that often gets overlooked is deleting data. Once information has reached the end of its usefulness, delete it. It is the single-most cost effective task you can execute on an ILM project. If you don’t have the data, you don’t have to store it, manage it, or worry about it getting into the wrong hands. Delete it.

[Read more]

No Comments

New Survey Shows Time is Ripe for Information Lifecycle Management

Joe McKendrickNo question about it, we face an information tsunami. And many organizations do not yet have a coherent strategy to deal with all the new data that is surging their enterprises. Worse yet, when applications fail or slow down, they attempt to fix the problem by throwing more hardware at it – rather than dealing with the root cause of the issue – too much data. Most organizations are only just beginning to take the necessary steps to address these challenges and keep massive amounts of data from overwhelming their enterprise applications.

As part of my work with Unisphere Research/Information Today Inc., I recently had the opportunity to team with Informatica's Application ILM team to develop and publish a survey that explored ILM awareness and implementations among 277 managers and professionals affiliated with the Oracle Applications Users Group (OAUG).  (Full survey report available for download here.) [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

Next,