Category Archives: Vibe

The Swiss Army Knife of Data Integration

The Swiss Army Knife of Data Integration

The Swiss Army Knife of Data Integration

Back in 1884, a man had a revolutionary idea; he envisioned a compact knife that was lightweight and would combine the functions of many stand-alone tools into a single tool. This idea became what the world has known for over a century as the Swiss Army Knife.

This creative thinking to solve a problem came from a request to build a soldier knife from the Swiss Army.  In the end, the solution was all about getting the right tool for the right job in the right place. In many cases soldiers didn’t need industrial strength tools, all they really needed was a compact and lightweight tool to get the job at hand done quickly.

Putting this into perspective with today’s world of Data Integration, using enterprise-class data integration tools for the smaller data integration project is over kill and typically out of reach for the smaller organization. However, these smaller data integration projects are just as important as those larger enterprise projects, and they are often the innovation behind a new way of business thinking. The traditional hand-coding approach to addressing the smaller data integration project is not-scalable, not-repeatable and prone to human error, what’s needed is a compact, flexible and powerful off-the-shelf tool.

Thankfully, over a century after the world embraced the Swiss Army Knife, someone at Informatica was paying attention to revolutionary ideas. If you’ve not yet heard the news about the Informatica platform, a version called PowerCenter Express has been released and it is free of charge so you can use it to handle an assortment of what I’d characterize as high complexity / low volume data integration challenges and experience a subset of the Informatica platform for yourself. I’d emphasize that PowerCenter Express doesn’t replace the need for Informatica’s enterprise grade products, but it is ideal for rapid prototyping, profiling data, and developing quick proof of concepts.

PowerCenter Express provides a glimpse of the evolving Informatica platform by integrating four Informatica products into a single, compact tool. There are no database dependencies and the product installs in just under 10 minutes. Much to my own surprise, I use PowerCenter express quite often going about the various aspects of my job with Informatica. I have it installed on my laptop so it travels with me wherever I go. It starts up quickly so it’s ideal for getting a little work done on an airplane. 

For example, recently I wanted to explore building some rules for an upcoming proof of concept on a plane ride home so I could claw back some personal time for my weekend. I used PowerCenter Express to profile some data and create a mapping.  And this mapping wasn’t something I needed to throw away and recreate in an enterprise version after my flight landed. Vibe, Informatica’s build once / run anywhere metadata driven architecture allows me to export a mapping I create in PowerCenter Express to one of the enterprise versions of Informatica’s products such as PowerCenter, DataQuality or Informatica Cloud.

As I alluded to earlier in this article, being a free offering I honestly didn’t expect too much from PowerCenter Express when I first started exploring it. However, due to my own positive experiences, I now like to think of PowerCenter Express as the Swiss Army Knife of Data Integration.

To start claiming back some of your personal time, get started with the free version of PowerCenter Express, found on the Informatica Marketplace at:  https://community.informatica.com/solutions/pcexpress

 Business Use Cases

Business Use Case for PowerCenter Express

FacebookTwitterLinkedInEmailPrintShare
Posted in Architects, Data Integration, Data Migration, Data Transformation, Data Warehousing, PowerCenter, Vibe | Tagged , | Leave a comment

Data-Powered Insights Fueled by the “Internet of Master Data”

Master data management (MDM) has come a long way in the past decade or so.  When I was supporting my company’s customer master implementation back in 2001, my management was thrilled to simply have a customer master that brought a bit of order to the chaos sharing customer data between our CRM and ERP applications and downstream into our marketing data warehouse.

karel

Fast forward to 2014 and mastering customer data alone is often table stakes for leadership trying to transform their business from a product- or account-centric to a customer-centric organizations.

Here at Informatica, we’ve seen over 75% of our MDM customers in the past year purchase for multidomain use cases – meaning the scope of their initiative often spans mastering data such as Customers, Suppliers and Products as part of a coordinated effort.  These organizations have built compelling business cases to demonstrate that mastering multiple domains – and the relationships among those domains – is necessary.  Only a true 360 degree view of relationships among any data can provide the necessary insights to deliver on the desired operational efficiencies, optimized customer experiences, and growth objectives for their companies.

The progress we’ve all made in multidomain MDM is impressive, but it’s just scratching the surface of what’s possible.  What happens when MDM meets Cloud, Social, the Internet of Things and other master data enrichment sources such as D&B and Acxiom?  Dennis Moore, Informatica’s GM and SVP for MDM, envisions that a new “Internet of Master Data” will be formed that can include a massive new set of sensor and social data which it leverages to infer and recommend a new class of relationship insights.   For example, in addition to sentiment and relationships from social networks, location data from mobile devices and sensors can now inform customer – and product – behaviors that span beyond direct transactions and interactions within your traditional business applications.

Those of you who have invested in building a foundation of clean, consistent and connected data have a huge advantage as the value of MDM grows exponentially with the exponential growth of data. You are well-positioned to take advantage of the deeper insights and potential innovations now possible by adding Cloud, Social, and Machine data to optimizing analytics and operations.

This week at Informatica World 2014 in Las Vegas, we kicked off with our fantastic MDM Day pre-conference event with over 500 attendees.  During the event, we shared some early insights into our MDM 10 release planned for later this year which integrates the Informatica Vibe engine and incorporates other elements of the just unveiled Informatica Intelligent Data Platform vision to make it easier for customers to gain a 360 degree view of their most critical business entities, including customers, suppliers, products and assets.

We continue to be inspired by our awesome MDM customers and partners, and we’re excited to see what they can do to harness the power of the Internet of Master Data!

FacebookTwitterLinkedInEmailPrintShare
Posted in Informatica World 2014, Master Data Management, Vibe | Tagged , , , , | Leave a comment