Data Integration - Informatica

Informatica Perspectives

Cloud Presentation Stuns Conference

John Schmidt

Last month I posted an article about cloud computing and cloud integration (see Keep your feet on the ground and your head in the clouds for the full article) and encouraged readers to come to the Architecture and Integration Summit to see Informatica, salesforce.com and Amazon.com tell the story and see a demo. Those that came were not disappointed – the keynote presentation by Sanjay Krishnamurthy, Jeff Barr and Peter Coffee was electrifying! [Read more]

No Comments

Data Services – The Silver Bullet for SOA's Data Integration Pitfalls

Ash Parikh

In the post "SOA's Last Mile Part III: How to Address SOA's Hidden Data-Centric Pitfalls Effectively," David Lyle spoke about some high-level approaches to handling the data-centric pitfalls in an SOA.

I would like to introduce you to the solution…what I call data services, a flexible and cost-effective technology that can be the cornerstone of an SOA and EIM strategy by simplifying the complexity of both integrating diverse enterprise data that exists in individual silos as well as delivering a single, accurate and consistent view of all enterprise information, at the speed of business.
[Read more]

No Comments

Informatica launches industry's first on-demand data synchronization service for Cloud Computing

Chris Boorman

OK, I'm excited.  What do AAA, Dolby and Bax Global all have in common besides all being Informatica customers?  Give up?  Let me tell you … they’re all presenting at this week’s San Francisco Dreamforce event alongside our On Demand general manager, Ron Papas (you know the one who’s been ‘drinking the Kool-Aid’). Guess what they’ll be talking about … give up? Their presentation is called "Salesforce Integration – It’s not just for IT any more".

The responsibility of SaaS integration often lies outside of IT; in fact SaaS administrators have different skillsets to IT admins and these guys are going to explain why software (like ours) that addresses the needs of the SaaS admins is imperative for success in today’s business environment. 

By the way, did I tell you I was excited?!  Well, I have reason to be. For the first time in a long time, the industry is witnessing a momentous shift in the way companies manage their data integration processes – and you know what?  Without us, it wouldn’t be possible!

Informatica data integration is critical for SasS!

[Read more]

No Comments

Business Intelligence, Light and Fast (Part 1)

Joe McKendrick

Can business intelligence benefit from the current excitement around the rise of Web 2.0 and Enterprise 2.0? Some say the intersection of BI and Web 2.0 will advance us into “Business Intelligence 2.0,” which promises up-to-date information and actionable insights about every aspect of the business. Fellow blogger Rick Sherman recently observed that BI 2.0 isn’t just about tools and technologies, but about “getting more comprehensive, consistent, correct and current data…. We can finally interweave data from the data warehouse with real-time and event-driven data via our data integration efforts.”

Can Web 2.0 make the promise of BI 2.0 more of a reality? [Read more]

No Comments

Do you trust your data?

Chris Boorman

I find this rather an interesting and profound question!  Trusted data.  What does this mean, and how does it affect us all?  We've built all these systems over the years and we implicitly trust that the data provided is correct.

For years I have used online banking and I trust my bank (well, things have been OK up to now and I always check my statements and cross-reference incomings and outgoings).  Why do I check it - basically because I'm still a little nervous, it makes sense and I hear horror stories about hacking, stolen identities and all sorts of security issues.  The latest high profile example of this of course was the Sarah Palin hack (take a look at View From The Bunker for an interesting blog on security).

We make decisions all the time based on trust.  We buy presents for our loved ones, or cars and houses because we think we have enough funds - we trust our data.  I was chatting to a journalist recently over at the Oralce Openworld conference and he brought up the word trust … apparently he was using a very popular on-demand service (you know … the gorilla in the market!) to sell to customers and wasn't able to reconcile with his finance people.  They were telling him that his top 10 customers were completely different to the top ten in his SaaS system.  Hmm … a great example of "which data do you trust"?  The CRM system , or the finance system?  After investigation he found out that the problem was because the two systems were not connected and his company was relying on human process to update both systems.

That's the whole point of integration - to help ensure that your systems are connected and that the right information is available to you to help you improve your decision making process, and operate more effectively.  Today data is the lifeblood of every company, it's the true currency that we all deal in when we trade on the stock exchanges, or run drug trials across hospitals, or manage supply chains across continents.  You have to be able to trust your data - and yet the world is full of examples of mistakes made or mishaps occuring because of poor quality data.

Take a look at "Do You Trust Your Data?". It's a new site we've pushed out highlighting real-world examples of stories relating to trusting your data.  You can add your own (anonymously if you'd like).   We've love to hear from you.  Go on… I know you want to :-)

No Comments

Keep your feet on the ground and your head in the clouds

John Schmidt

The number of articles and blog postings on cloud computing is staggering. Here is one from Chris Boorman Cloud Computing - integration is key which in turn references several other blogs. And check out this Architecture and Integration Summit taking place in Minneapolis on October 30th www.architectureandintegrationsummit.com. Informatica is leading a keynote presentation along with participation from Amazon and Salesforce.com.  The presentation by Sanjay Krishnamurthi, Peter Coffee and Jeff Barr will conclude with a live demo showing how salesforce.com can be integrated with Amazon using Informatica’s On-Demand integration – cloud computing to cloud computing using cloud integration.  [Read more]

No Comments

IT Budgets, Clouds and Virtualisation

Chris Boorman

A blog at IT-Director.com caught my eye yesterday.  Entitled "IT Budgets, Clouds and Virtualization" it included the following comment:

“For Cloud computing, chief amongst these concerns is the readiness of commercial organisations to trust significant proportions of their essential, and hence incredibly valuable, corporate information to platforms and suppliers over whom they have little control and who might hold the data wherever they wish. Such a leap of faith is today beyond consideration in many business scenarios.”

This is spot-on.  There is so much talk about "cloud computing this, and cloud computing that".  When it comes to corporations there are many examples of outsourcing non-core business processes to the cloud.  Here at Informatica we use over 17 different services ourselves. I'd say the most mission-critical of these is our email marketing system (can't tell you who or I'd have to shoot you!).  We're rolling it out worldwide across our marketing team and have spent the last few months integrating it with our own on-premise CRM system, contact hub and datawarehouse.  Not a trivial task but incredibly important for me (well, I'm a marketeer) but probably less mission-critical to our CFO!

At the end of the day corporations WILL move data into the clouds so whilst I agree with Tony in the above-mentioned article, I also disagree with him (OK, bit of a split personality here now).  I agree that it is foolish to simply “go to the clouds”, but I disagree about the state of the industry.  It is possible to keep the data secure and we, amongst others, have proven that with our on-demand integration service.  It is also possible to integrate such services into core business processes.  My statement would be - don't overlook the integration. You do it at your peril.  We've had a LOT of experience of helping companies do this effectively - after all we're the data integration company!

Oh … and we can do it from in the clouds too :-)

No Comments

Cloud Computing - integration is key

Chris Boorman

The airways are a buzz with cloud computing.  I was reading an article just yesterday on a blog posting about building datawarehouses in the clouds.  Entitled "Google, Panorama and the BI of the Future" the article made reference to ourselves and the work we are doing in this area:

 … Once your data’s in the cloud, you’re going to want to load it into a hosted data warehouse of some kind, and I don’t think that’s too much to imagine given the cloud databases already mentioned. But how to load and transform it? Not so much of an issue if you’re doing ELT, but for ETL you’d need a whole bunch of new hosted ETL services to do this. I see Informatica has one in Informatica On Demand;

I think there are great opportunities here in helping to utilize the cloud to deliver not just business applications but also areas such as CDW (or cloud-based data warehousing).  This is something that we are looking at closely.  It starts with being able to access data in different systems (both on-premise and on-demand).  You may have already seen the work we are doing in this area:  take a look at our on-demand web-site at www.informaticaondemand.com.   Here you can see our cloud-computing data integration services - multi-tenanted, in the clouds with no software!  Pretty cool.  If you want to see a demo of what it's all about, take a look at our cloud computing integration demo.

There's a lot happening in the world of cloud computing and I'm delighted to see Informatica leading the charge in helping corporations to integrate and drive data quality across the clouds. 

Cloud computing cannot succeed without integration.  The last thing anyone wants is to simply fragment their data across the clouds.  Integration prevents this and ensures you can retain control of your data assets.

Do you agree?  let me know!

1 Comment

Pervasive Business Intelligence Means 'BI for the Masses'

Joe McKendrick

The success of pervasive business intelligence is all about trust in data. Enterprise data warehousing plays a crucial role in delivering information so that users can drive real-time decision-making reliably, and accurately reflects existing business conditions.

However, the enterprise information needed for pervasive BI comes in many forms, exists in many silos, and has many degrees of latency. The challenge is, before we hand off decision-making to more automated processes, how can we be sure this information presents a true picture of business?  You need a stronger foundation to ensure freshness, completeness and accuracy of data.

These are the issues that James Markarian, CTO of Informatica, along with Stephen Brobst, CTO of Teradata, pondered and explored in a recent Webcast.

The goal of pervasive BI is [Read more]

No Comments

'Cloud Computing' is Ready for Enterprise Prime Time, But… (Part 2)

Joe McKendrick

In my last post, I talked about the enterprise integration challenges that still challenge enterprises, even if they have moved processes to cloud computing or Software as a Service providers.

Will integration issues dampen the enthusiasm around cloud computing? What's the role of data environments in these new scenarios? To address these questions, I recently had the opportunity to speak with Chris Boorman, chief marketing officer with Informatica, and Ron Papas, senior vice president and general manager for Informatica On Demand, about the enterprise data management implications of this growing trend. (Chris also recently posted some of his observations here.) [Read more]

No Comments

Next,