Do you really need to discover Microsoft Dynamics AX metadata? The answer is a definite “Yes”, because as one of the world’s most implemented ERP/CRM packaged solutions for large and medium sized enterprises it suffers from the same metadata challenge as SAP, Oracle, and increasingly Salesforce systems. (According to Panorama Consulting Solutions’ most recent survey, […]
What comes before data extraction? In any data intensive project be it a data warehouse, data migration, master data there is a data discovery phase which has to be completed before any movement of data can be performed. This is what used to be called source data analysis and is in modern parlance more likely […]
Top 3 Data Integration mistakes I saw a fascinating post by David Linthicum on the Informatica Blog recently in which he discussed the Top 3 Data Integration mistakes which companies make and how to avoid them. One of these is essentially being unable to answer the question ‘Where’s the data and what does it mean?’ For the sake […]
new supported package for safyr We’ve been working hard on a new capability for Safyr®. This is in the form of a metadata extraction feature to enable customers to quickly and intuitively access and exploit the Microsoft Dynamics AX 2012 data model. As a result we are adding a new package to our list of […]
data modeL Of all the blogs we’ve written here at Silwood, by far the most popular are the ones that are about specific Data Models for SAP, Salesforce and Oracle packages (JD Edwards, E-Business Suite, Siebel and PeopleSoft). We’ve done a number of these over the last year or two. For example we wrote about […]
Introduction The theme at Enterprise Data World 2016 is “transforming to a data driven business” and Silwood Technology are delighted to be sponsoring the event again this year. This is a broad subject that covers a multitude of disciplines, for example, data governance, enterprise information management, master data, business intelligence and analytics as well as data […]
Introduction to Safyr for Salesforce Salesforce has an easy-to-use data modelling feature in the Schema Builder. This provides a graphical data modelling interface to the Salesforce metadata, allowing the user to choose which Objects to include in the diagram, and with zooming and navigation features. However, when there are a significant number of Custom Objects, […]
This is the latest in our occasional series of data models which we have produced using Safyr®. These give some insight into those common business areas in SAP and ORACLE applications for which an understanding of how the underlying metadata is structured are often required for Information Management projects. It’s a group of tables in the form […]
big data’s little jobs I happened across an interesting article by David Gee recently. It was entitled “A guide to the little jobs that will make big data work.” (http://www.itnews.com.au/blogentry/a-guide-to-the-little-jobs-that-will-make-big-data-work-409655) What I found particularly noteworthy, not to mention refreshing, was the acknowledgement of the importance of metadata in a big data project. This is not […]
PeopleSoft Financials data model Here is another in our occasional series of data models of those common business areas in SAP and ORACLE applications for which data models are often required for Information Management projects. This time it is a set of tables in the form of a data model from a PeopleSoft Financials system, […]
WHat exactly is a data lake? Recently I have been attending some vendor webinars on Big Data, Data Lake strategy, Hadoop in the context of Data Warehousing and Analytics in an attempt to gain a clearer understanding both of the technology platforms available and more importantly some knowledge of the use cases and benefits a […]
This is the latest in an occasional series of data models which will give some insight into those common business areas in SAP and ORACLE applications for which data models are often required for Information Management projects. It’s a group of tables in the form of a data model from an Oracle Enterprise Business Suite system showing a […]
This is an interesting blog by Steve Lucas, President of Platform Solutions at SAP. https://blogs.saphana.com/2014/11/12/a-roadmap-for-simple/ The first paragraph reads: “Our CEO, Bill McDermott, has thrown down the gauntlet on enterprise complexity so to speak and issued a challenge to every single SAP employee: Make our valuable products and solutions simple to understand, simple to discover, simple […]
As many of you will know, using Safyr® we can pull metadata from a range of ERP and CRM products, including SAP, Salesforce and PeopleSoft. Customers often ask about other packaged applications that they have implemented. “Can you also do XYZ product?”, and our answer used to be “No – we can only do the […]
This is the latest in an occasional series of data models based upon the packaged application we support with our Safyr product. It is an example of modelling Salesforce application tables with Safyr. Many of our customers and partners are increasingly using Salesforce as an enterprise system of record and of course with the addition […]
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. Imagine I’ve moved to a new town and I want to know the location of the nearest Supermarket, Post Office, ATM, etc. What do I do? I can ask […]
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. I am not going to spend time restating the benefits that organisations can reap from a properly implemented Master Data strategy in terms of increased revenues […]
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. With that in mind, you will […]
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. Previously on this blog we’ve produced a Bill of Materials model from a SAP system and an Accounts Payable model from a JDEdwards EnterpriseOne 9.1 system. This model […]
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 […]
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. Salesforce is much smaller than SAP or the Oracle apps in terms of the number of tables, but can still be challenging to understand […]
According to a recent report by leading analyst firm Gartner, heavily customised ERP (Enterprise Resource Planning) systems will have achieved the status of ‘legacy ERP,’ by 2016. In addition they suggest that as more agile, flexible competitors enter the market and mature, CIO’s will need to plan on what to do with their ‘legacy ERPs’. […]
“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. […]
This is the second in an occasional series of data models which will give some insight into those common business areas in SAP and ORACLE applications for which data models are often required for Information Management projects. It’s a set of tables in the form of a data model from a JD Edwards EnterpriseOne 9.1 system showing the […]
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. One of the people at the meeting was very experienced in the ETL tool the customer was using for this project. We were showing […]
We are in the process of providing content which will give some insight into those common business areas in SAP and ORACLE applications, for which data models are often required for Information Management projects. The first one I have created is a data model of the SAP tables used in the BOM Explosion process. The model was created following some analysis in […]
I’m always looking for new ways to explain what I do for a living. It’s made hard by the fact that it centres on a product that doesn’t do anything quite like any other tool in the ‘data’ space – which is to make it fast and easy to navigate the data models of […]
You must be registered to receive support
Please login or Register Here »
Note: The token is a unique string for each Safyr license and can be found on your product delivery instructions
Already registered? Login here »Enter your username
to receive your password
Welcome to Silwood Technology. We use cookies to enhance your browsing experience. Learn more OK