Well…er…Yes, and No. We get this comment lots of times. It’s sometimes hard to explain the difference. Strictly speaking, we do ‘metadata discovery’. I like analogies.
We would like to congratulate IBM, Informatica, SAP and Oracle on their continued strong showing in the latest Gartner Magic Quadrant for Master Data Management (MDM) of Customer Data Solutions.
We’ve had quite a bit of interest in our application data model examples from ERPs over the last few months. A number of people have said that they don’t have a modelling tool easily accessible and therefore can’t see what the diagrams look like, which is a fair point.
I have been reading quite a lot recently about the applicability of Agile methodologies for Data Warehousing amongst other initiatives and it appears to me that often the topic of source data analysis is under-represented in the literature and blogs so I thought I would discuss the subject of application metadata in an Agile data warehouse world.
This is the third in a series of data models drawn from the various ERP and CRM systems for which Safyr delivers rapid, accurate and usable metadata.
We’ve been providing a solution to get metadata out of ERP and CRM applications for quite a few years now and a common question over that period has been some variation of: “It’s great what you do for SAP (PeopleSoft, Siebel, etc…) – now tell me, can you do the same for our other packaged apps?”
We’re going to be adding Safyr® for Salesforce capability to our product in the next release (due June 2014) so I wanted to give a taste of what this will deliver.
“Garbage out, garbage in”
I know, I know I have got that the wrong way round. Well, actually I did it on purpose to illustrate a problem with BI/Data Warehousing projects and incidentally many other Information Management initiatives. That problem is the challenge of source data analysis – particularly with SAP, Oracle and Salesforce packages.
A few months ago I was at a meeting with a customer who was involved with a BI project that was pulling data from an SAP system into a Data Mart.