Tag Archives: BI

What Does “Right Time” Data Integration Mean to You? Join the Discussions at Informatica World 2013

The way I see it – it’s all about having access to the right data at the right time. A company is like a large ship that must be effectively steered at both a strategic as well as an operational level to reach its destination – despite treacherous waters. Where am I going with this? Well, companies continuously face challenging situations such as competitive threats, customer expectations, market trends, and other external constraints. Overcoming the challenges of global uncertainty requires business agility to navigate an efficient and effective course towards achieving the company’s objectives.

Ok – so what does all this have to do with right time data integration? Actually – EVERYTHING! Companies require timely information to add value to their products, customer relationships, and business partnerships – agreed? And business conditions today are influenced by powerful market forces such as globalization, mergers and acquisitions, regulatory compliance, fierce competition, tight operating budgets, increased demands for improved customer service, and ever faster product delivery – right?  So, it should follow that only the most responsive and agile companies will perform the best.

If you are with me so far, you will immediately see the connection between business agility and the speed of data processing and delivery. This typically spans a wide range of latencies depending on the business process. In analytical data integration projects (e.g. data warehousing) latencies can range from weeks to days. Operational data integration projects on the other hand require information within hours, minutes, and seconds. Examples of such projects include real-time data warehousing, operational data hubs, data synchronization, data replication, and agile business intelligence (BI).

The success of such operational data integration projects depends on the ability to meet service level agreements (SLAs) related to data latency. You may require data delivered frequently (e.g., real-time or near- real-time) or infrequently (e.g., weekly batch windows). Or, you may need to move large data volumes or small datasets between applications. Or, have ready access to the most current data available in operational systems. Or, you may need to deliver new data and reports in days vs. months. Or, streamline the accessibility of business partner data. Or, be aware of real-time events as they occur.

So, whatever right time data integration means to you, please do join us at Informatica World 2013 to discuss – here are my recommendations on just some of the relevant activities on this topic:


Tuesday, June 4

Wednesday, June 5

Thursday, June 6

BIRDS OF A FEATHER ROUNDTABLES (Check Agenda for Daily Timings):

  • How to Untangle the Data Integration Hairball

HANDS-ON LABS (Check Agenda for Daily Timings):

  • Table 13 – Data Virtualization for Agile BI / Data Services
  • Table 19 – Empowering Analyst Self-Service with Informatica Analyst
  • Table 41 – Informatica Data Replication
  • Table 44 – Data Integration Hub
  • Table 45 – B2B Data Transformation
  • Table 46 – B2B Data Exchange
  • Table 47 – RulePoint / Operational Intelligence Platform
  • Table 48 – Proactive Healthcare Decision Management

BOOTHS (Check Agenda for Daily Timings):

  • Operational Intelligence and Reporting
  • Real Time Data Integration
  • External Data for Analytics
  • Customer/Supplier Collaboration
  • Operational Synchronization


I look forward to seeing you at Informatica World 2013.

Posted in Data Integration, Informatica Events | Tagged , , , , , , | Leave a comment

Data Integration Specialists See a “Slow-but-steady” Rise in Salaries

According to Doug Henschen, Executive Editor at InformationWeek, “Despite the weak economy and zero growth in many IT salary categories, business intelligence (BI), analytics, information-integration and data warehousing professionals are seeing a slow-but-steady rise in income.” (more…)

Posted in Big Data, Cloud Computing, Data Integration | Tagged , , , | Leave a comment

Building the Business Case for Big Data: Learn to Walk Before You Run

In a recent webinar, Mark Smith, CEO at Ventana Research and David Lyle, vice president, Product Strategy at Informatica discussed: “Building the Business Case and Establishing the Fundamentals for Big Data Projects.”  Mark pointed out that the second biggest barrier that impedes improving big data initiatives is that the “business case is not strong enough.” The first and third barriers respectively, were “lack of resources” and “no budget” which are also related to having a strong business case. In this context, Dave provided a simple formula from which to build the business case:

Return on Big Data = Value of Big Data / Cost of Big Data (more…)

Posted in Big Data | Tagged , , , , , , , , , , , | Leave a comment

How Integration Platform-as-a-Service Impacts Cloud Adoption

Did you know that Forrester estimates in their 10 Cloud Predictions For 2012 blog post that on average organizations will be running more than 10 different cloud applications and that the public Software-as-a-Service (SaaS) market will hit $33 billion by the end of 2012?

However, in the same post, Forrester also acknowledged that SaaS adoption is led mainly by Customer Relationship Management (CRM), procurement, collaboration, and Human Capital Management (HCM) software and that all other software segments will “still have significantly lower SaaS adoption rates”. It’s not hard to see this in the market today, with cloud juggernaut salesforce.com leading the way in CRM, and Workday and SuccessFactors doing battle in HCM, for example. Forrester claims that amongst the lesser known software segments, Product Lifecycle Management (PLM), Business Intelligence (BI), and Supply Chain Management (SCM) will be the categories to break through as far as SaaS adoption is concerned, with approximately 25% of companies using these solutions by 2012. (more…)

Posted in Cloud Computing, Data Integration, PaaS, SaaS | Tagged , , , , , , , , , , , , | 1 Comment

2012 Cloud Integration Predictions – Data, MDM, BI, Platform and IT as a Service

I spent last weekend reading Geoffrey Moore’s new book, Escape Velocity: Free Your Company’s Future from the Pull of the Past. Then on Sunday, the New York Times published this article about salesforce.com: A Leader in the Cloud Gains Rivals. Clearly “The Big Switch” is on. With this as a backdrop, the need for a comprehensive cloud data management strategy has surfaced as a top IT imperative heading into the New Year – How and when do you plan to move data to the cloud? How will you prevent SaaS silos? How will you ensure your cloud data is trustworthy, relevant and complete? What is your plan for longer-term cloud governance and control?

These are just a few of the questions you need to think through as you develop your short, medium and long-term cloud strategy. Here are my predictions for what else should be on your 2012 cloud integration radar.  (more…)

Posted in Big Data, Business/IT Collaboration, CIO, Cloud Computing, Data Integration, Data Migration, Data Quality, Data Synchronization, Master Data Management, PaaS, SaaS | Tagged , , , , , , , , , , , , , , , , , | 3 Comments

Agile Data Integration Maximizes Business Value In The Era Of Big Data

Adopting Agile may require a cultural shift and in the beginning can be disruptive to an organization.  However, as I mentioned in Part 1 of this blog series, Agile Data Integration holds the promise to increase chances of success, deliver projects faster, and reduce defects.  Applying Lean principles within your organization can help ease the transition to Agile Data IntegrationLean is a set of principles first explored in the context of data integration by John Schmidt and David Lyle in their book on Lean Integration.  First and foremost Lean recommends an organization focus on eliminating waste and optimizing the data integration process from the customers’ perspective.  Agile Data Integration maximizes the business value of projects (e.g. Agile BI, Data Warehousing, Big Data Analytics, Data Migration, etc.) because you can get it right the first time by delivering exactly what the business needs when they need it.  Break big projects into smaller more manageable deliverables so that you can incrementally deliver value to the business.  Agile Data Integration also recommends the following: (more…)

Posted in Data Services | Tagged , , , , , | Leave a comment

Rich On Data, Poor On Actionable Insight

InformationWeek says companies lack Real-Time Insight

Many companies have built out their data infrastructure, composed of large data warehouses, varying data marts, integration processes, quality controls and much more.  And, it has driven tremendous value in the form of stronger business intelligence, better views of the customer, faster business processes and more.  But, with all the help on the analysis side, where’s the evolution in putting those findings into operational practice. Like quickly identifying that a premium/platinum-level client was put on hold by a customer care agent for more than 5 minutes (and no, the “we are experiencing unusually high call volume” does not let anyone off the hook).

InformationWeek’s May 24, 2010 cover story was titled “Are your Apps Smart Enough” and it prominently featured a BI report card.  Here were the grades: (more…)

Posted in Business/IT Collaboration, Complex Event Processing, Operational Efficiency, Real-Time | Tagged , , , , , , , , , | Leave a comment

If You Have A Data Integration Round Hole, Don’t Buy Square Pegs

I’m often taken aback by the focus on technology as “the solution,” and not as an approach to the solution. One of the reasons I blog for Informatica is because they do focus on the solution and not the tool. Believe me, vendors will sell plenty of tools if they provide those tools in the context of the solution.

So, how do you find the right data integration tool? It’s really a matter of understanding your own data integration requirements, and creating baseline models for what the existing “as is” state is. This means you must understand your data at the structure and model levels, or, more simply put, you must understand what you have, where you have it, and what it’s doing. (more…)

Posted in Cloud Computing, Data Aggregation, SOA | Tagged , , , , | Leave a comment

A Wave Of New Mergers And Acquisitions – Are You Prepared to succeed?

I was driving to work this week when I heard about Walt Disney Company’s announcement to buy comic book giant Marvel Entertainment (MVL) for US$4 billion.  I started thinking about what it would be like to see the X-MEN hanging out with Snow White’s Seven Dwarfs the next time I take my kids to Disneyland. At the same time, I was wondering if an increase mergers and acquisitions were a sign of an economic recovery?  (more…)

Posted in Application ILM, Business Impact / Benefits, Data Governance, Data Integration | Tagged , , , , | 1 Comment