Posts Tagged 'data warehousing'

CIO Insight: Top IT Applications in 2012 and Beyond

CIO Insight published a great slideshow overview today on  application adoption trends over the next 12 months. I’d embed if if I could figure out out. Here’s a brief summary:

Top 5 apps to be integrated:

  1. Business intelligence/analytics (39%)
  2. Productivity/collaboration (36%)
  3. Sales (34%)
  4. Financial (28%)
  5. Social Media (27%)
Top social media platform for marketing/customer support:
  1. Facebook (32%)
  2. Twitter (20%)
  3. LinkedIn (20%)
Biggest roadblocks for fully harnessing data (percent respondents):
  1. Insufficient integration (45%)
  2. Data-quality maintenance (40%)
  3. Network/system performance maintenance (35%)
Other results:
  • 57% of respondents anticipate that data volume will increase 25% during the next 12 to 18 months.
  • 56% of respondents feel that easily connecting applications and data will allow staff more time to work on other business initiatives.
  • 33% of respondents say they’ll implement at least four SaaS/cloud applications during the next two years.
  • 42% of respondents plan to incorporate cloud solutions to address integration needs.

Be sure to check out the complete presentation here.

#DF11 Video: Orchestrating Your Data: A Business Guide to Integration and Analytics

This Dreamforce 2011 presentation provides a good overview of both cloud-based analytics (GoodData) and data integration (Informatica Cloud). The session is from systems integrator Astadia, and features a nice balance of vendor overview, best practices, and some cool white boarding from an implementation expert – Aaron Mieswinkel.

Data Integration in the Cloud (via Business Analytics 3.0)

This post provides a comprehensive overview of cloud integration use cases, options and approaches. It’s definitely worth reviewing if you’re interested in the topic.

The Curious Case of Salesforce and Workday: Data Integration in the Cloud The growing enterprise adoption of Salesforce SFA/CRM, Workday HR, Netsuite ERP, Oracle on Demand, for apps and Amazon Web Services for e-commerce will result in more fragmented enterprise data scattered across the cloud. Automating the moving, monitoring, securing and synchronization of data is no longer a “nice-to-have” but “must-have” capability. Data quality and integration issues — aggregating data from the myriad sources and servi … Read More

via Business Analytics 3.0

5 Requirements for a Big Data Integration Platform

Two articles caught my attention today – and not surprisingly both had to do with Big Data and Cloud Computing.

Microsoft’s, Google’s big data plans give IT an edge – an interesting take on Google vs. Microsoft with good details on both. Note the recent stat from Gartner in the intro: “By 2015, companies that have adopted big data and extreme information management will begin to outperform unprepared competitors by 20% in every available financial metric.”

Sounds like Information Management has gone Extreme. Very exciting!

The other article comes from Loraine Lawson, who recently interviewed the always quotable James Markarian from Informatica: Big Data Platform Should Support Data Exploration. He outlines five key requirememts for a Big Data Integration Platform:

  1. Integration from a variety (there’s that word again!) of sources, from mainframes to messaging systems.
  2. Data quality and data governance.
  3. Text analytics and sentiment analysis.
  4. Support for R.
  5. A new attitude about analysis and design schemas.
You can read the entire interview here.

Here’s another interview with James, if you want more on the Big Data Integration topic:


Next Generation Cloud Business Intelligence?

MicroStrategy entered the cloud BI market today by announcing the general availability of MicroStrategy Cloud. From the press release:

“Compared to traditional on-premises BI approaches, MicroStrategy Cloud is quicker to deploy (within 48 hours) and more flexible, delivers world-class performance, and offers significant financial advantages. MicroStrategy Cloud is powerful and flexible enough to support the full range of cloud use cases, from fast, flexible tactical BI solutions, to the largest implementations where performance and scalability are imperative.”

The announcement goes on to highlight the following benefits:

  • World-Class Performance
  • Integrated Database and Data Integration
  • Accelerated Time to Market
  • Comprehensive Security
  • Elite Platform Partners
Of note on the partner front:
  • “IBM Netezza will provide its complete family of analytical appliances.”
  • “MicroStrategy Cloud customers will be able to choose from a multitenant Cloud-based Data Integration solution, or run their own dedicated Informatica environment in the MicroStrategy Cloud.”
  • “ParAccel will bring its analytic platform to MicroStrategy Cloud customers, delivering extreme scalability to thousands of nodes and tens of thousands of users in a flexible, solution that is optimized for virtualized and cloud-based environments.”
Is Cloud BI 2.0 now upon us? Be sure to read the entire MicroStrategy Cloud press release for more details.

Informatica’s Chris Boorman Talks About Big Data

Image representing Hadoop as depicted in Crunc...

Image via CrunchBase

Here’s an overview of Big Data from Informatica’s CMO Chris Boorman. He summarizes Big Data as the confluence of three major trends in the industry: the growing complexity and volume of transactional data, new sources of interaction data, and new ways of processing data (such as Hadoop). He also provides an overview of Informatica’s latest release.

The Increasing Importance of Cloud Data Replication

Last week we hosted a webinar on cloud data replication, with a particular focus on Salesforce CRM and The level of interest and interaction was amazing. Whether the use case is back-up, compliance or business intelligence, having a flexible and cloud-based approach to cloud data replication is clearly critical to software as a service (SaaS) application and platform success. You can check out the recording here.

Gartner: Data Warehousing at an Inflection Point

A few weeks ago at Informatica‘s annual industry analyst summit, one my favorite tweets was: “Who would have thought that 10 years later data warehousing would still be interesting?”

Well, today Gartner put out the following press release:  Gartner Says Data Warehousing Reaching Its Most Significant Inflection Point Since Its Inception. While there was surprisingly no mention of the impact of cloud computing, the release does make an important point about the shift in the balance of power from database management vendors to data integration vendors:

“Analysts maintain that there is a real opportunity for data integration tools vendors to challenge the database management system (DBMS) vendors as the primary data management architecture, and the DBMS vendors should not underestimate this potential competition.”

Additional information is available in the Gartner report “The State of Data Warehousing in 2011.” The report is available on Gartner’s website at

Tapping Into the Value of Your Cloud Application Data

Whether your a sales operations manager, analyst, CRM administrator or information architect, integrating cloud application data with other sources for reporting and analysis across systems has become a critical business requirement. The challenge with traditional data integration approaches is the frequency of change to the cloud application data model. How many new custom fields or objects did you add to Salesforce today? What was IT’s role in the change management process? How long were you willing to wait for your data integration scripts to be updated?

As one Salesforce customer put it in this AppExchange review:

“With a product like, which gives you so much power to do quick database configuration changes, you need a product like Informatica Cloud to give you that same agility on the data integration side. What good is being able to add a new field in to in just minutes if it takes months to get the data you want in to that field? For us, Informatica Cloud has all but eliminated that problem.”

Even Informatica’s own IT organization recognized the value of a cloud-based data replication service. According to Peter Vanderhaak,

“Once we realized how robust and easy to use Informatica Cloud could be, the following day we had a replication job moving data into a test data warehouse target – capturing incremental data changes and easily adaptable against an ever changing Salesforce data model. This would have taken weeks of development effort in a constantly changing SFA environment in the middle of a project that was still determining what fields and objects to create. Additionally, the ongoing maintenance would have caused major headaches and increased run-rate costs.

Well today I noticed this 5-star AppExchange review and I thought it was worth sharing:

Isn’t time you looked to see if cloud data replication might help you better tap into the value of your data?

You Can’t Put the Cloud Horse Back in the Barn

Thanks to my friend @rssanborn for tweeting this 2015 Cloud Checklist:

  1. Accept that many cloud providers already are better at security than you are.
  2. Private clouds should not be your end game.
  3. Know how to structure contracts.
  4. Understand the workloads you’re supporting.
  5. Seek coordination (not control) of cloud resources.

#5 in particular caught my attention. It speaks to some of the issues I’ve written about in this post about cloud politics and the role of data integration. I like how the author of the CIO Insight post, Tony Contzer, puts it:

“Those who try to put the kibosh on a business unit’s rogue adoption of cloud services are on the same fruitless path as the CIOs who fought Web browsers and voice over IP.”

The article features a few choice quotes from Gartner‘s Daryl Plummer (see his video interview in this post). He notes:

“Business units are not going to let you take back control. You can’t put the horse back in the barn.”

I was recently interviewed by Leigh Dow at ITToolbox and put it this way:

“With the SaaS model, the business can just go get software, do a trial with a credit card and start adopting and managing SaaS applications autonomously.  What often happens is a spiral of tools manifest in the company and at some point you get “SaaS sprawl.”  No different than what we saw in BI in the Data Warehousing space when data marts popped up and at some point they needed to be consolidated.  It is becoming a huge problem for IT. One customer told me, “we need to get on this cloud train or get run over by it”. Being the “department of no” isn’t an option.

RSS In(tegrate) the Clouds RSS

  • An error has occurred; the feed is probably down. Try again later.

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,746 other followers

Follow Me on Twitter

A Passion for Research

Focusing on CRM, cloud computing, ERP and enterprise software

SnapLogic Blog

Thoughts on Integration Platform as a Service (iPaaS), Analytics and the SnapLogic Integration Cloud

Learning by Shipping

products, development, management...

Laurie McCabe's Blog

Perspectives on the SMB Technology Market


thoughts on web services people pay for


studentforce .... designed by students for students


Get every new post delivered to your Inbox.

Join 4,746 other followers

%d bloggers like this: