Up to top

Category: Data Model Enterprise Information Management

9th November 2016

Is it necessary to discover Microsoft Dynamics AX metadata?

Categories: Data, Data and Application integration, Data Discovery, Data Model Enterprise Information Management, Enterprise Metadata Management, Microsoft Dynamics AX

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, […]

Continue reading »

18th October 2016

Data discovery – the step before extraction

Categories: Data Discovery, Data Management, Data Model Enterprise Information Management, Data Warehouse, Enterprise Application, Enterprise Metadata Management, Metadata discovery, Oracle, Salesforce, SAP

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 […]

Continue reading »

7th September 2016

Where’s the data? Avoiding data integration errors

Categories: Data, Data and Application integration, Data Discovery, Data Model Enterprise Information Management, Enterprise Information Management, JD Edwards, Metadata, Metadata discovery, Oracle, PeopleSoft, Safyr, Salesforce, SAP

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 […]

Continue reading »

31st August 2016

Access and exploit Microsoft Dynamics AX 2012 data model with Safyr

Categories: Data, Data Discovery, Data Management, Data Model Enterprise Information Management, Enterprise Application, Enterprise Metadata Management, Metadata, Metadata discovery, Microsoft Dynamics, Microsoft Dynamics AX, Safyr

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 […]

Continue reading »

29th June 2016

Download sample data models for SAP, Salesforce and Oracle packages

Categories: Data, Data Discovery, Data Model Enterprise Information Management, Enterprise Application, Enterprise Metadata Management, JD Edwards, Metadata, Oracle, PeopleSoft, Safyr, Salesforce, SAP, Siebel

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 […]

Continue reading »

8th April 2016

Transformation to a data driven business needs metadata

Categories: Data, Data Discovery, Data Governance, Data Management, Data Model Enterprise Information Management, Data Warehouse, Enterprise Information Management, Enterprise Metadata Management, Metadata, Metadata discovery

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 […]

Continue reading »

3rd March 2016

Extract, explore and exploit Salesforce metadata using Safyr

Categories: Agile, Data Discovery, Data Management, Data Model Enterprise Information Management, Enterprise Application, Enterprise Metadata Management, Metadata, Metadata discovery, Salesforce

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, […]

Continue reading »

3rd February 2016

Using PeopleSoft metadata to model Customer Master

Categories: Data Model Enterprise Information Management, Enterprise Metadata Management, Metadata, PeopleSoft

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 […]

Continue reading »

4th January 2016

Metadata – one of Big Data’s “dirty little jobs”?

Categories: Big Data, Data, Data Discovery, Data Management, Data Model Enterprise Information Management, Data Warehouse, Metadata, Metadata discovery, Safyr, Salesforce, SAP, SAP BW, SAP HANA

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 […]

Continue reading »

12th October 2015

Use Safyr to find the PeopleSoft Customer-Contact Data Model – quickly and easily

Categories: Data, Data Discovery, Data Model Enterprise Information Management, Enterprise Metadata Management, Metadata, Metadata discovery, PeopleSoft

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, […]

Continue reading »

8th September 2015

What are you pouring into your Data Lake?

Categories: Big Data, Data, Data Discovery, Data Model Enterprise Information Management, Data Warehouse, Enterprise Metadata Management, Metadata

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 […]

Continue reading »

1st July 2015

Ever wondered how you could create an Oracle eBusiness Suite General Ledger Data Model?

Categories: Data, Data Management, Data Model Enterprise Information Management, Enterprise Application, Enterprise Information Management, Enterprise Metadata Management, Metadata, Metadata discovery, Oracle, Safyr

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 […]

Continue reading »

26th May 2015

SAP “Run Simple” is great for the future, but what about the complexity of the past?

Categories: Business Process, Data, Data Management, Data Model Enterprise Information Management, Enterprise Application, Enterprise Information Management, Enterprise Metadata Management, Metadata, Metadata discovery, S4/HANA, Safyr, SAP, SAP BW, SAP HANA

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 […]

Continue reading »

24th March 2015

Using Safyr ‘ ETL for Metadata’ to harvest Microsoft Dynamics metadata

Categories: Data, Data Model Enterprise Information Management, Enterprise Application, Enterprise Information Management, Enterprise Metadata Management, Metadata discovery, Microsoft Dynamics

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 […]

Continue reading »

24th February 2015

Modelling Salesforce application tables with Safyr and Microsoft Visio – a worked example

Categories: Data, Data and Application integration, Data Discovery, Data Model Enterprise Information Management, Enterprise Metadata Management, Metadata discovery, MIcrosoft Visio, Safyr, Salesforce

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 […]

Continue reading »

18th December 2014

“So what your product, Safyr, does is Data Discovery – Right?”

Categories: Data and Application integration, Data Discovery, Data Model Enterprise Information Management, Enterprise Application, Enterprise Metadata Management, JD Edwards, Metadata discovery, Oracle, PeopleSoft, Salesforce, SAP, Siebel

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 […]

Continue reading »

10th December 2014

The role of application metadata in a Master Data implementation

Categories: Data Governance, Data Model Enterprise Information Management, Enterprise Application, JD Edwards, Master Data Management, Metadata discovery, Oracle, PeopleSoft, Salesforce, SAP

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 […]

Continue reading »

1st December 2014

Application data model examples

Categories: Data Model, Data Model Enterprise Information Management, JD Edwards, Safyr, Salesforce

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 […]

Continue reading »

3rd November 2014

How to find Data Models for SAP BW InfoCubes

Categories: Data, Data Model, Data Model Enterprise Information Management, Enterprise Metadata Management, Metadata discovery, Safyr, SAP, SAP BW

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 […]

Continue reading »

22nd October 2014

Applications, applications everywhere? And never the data to find?

Categories: Data, Data and Application integration, Data Model, Data Model Enterprise Information Management, Enterprise Application, Enterprise Information Management, Enterprise Metadata Management, Safyr

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 […]

Continue reading »

30th April 2014

Coming soon….Safyr for Salesforce

Categories: Data, Data and Application integration, Data Model Enterprise Information Management, Enterprise Application, Enterprise Information Management, Enterprise Metadata Management, Metadata discovery, Safyr, Salesforce

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 […]

Continue reading »

13th February 2014

Are complex ERP data models holding organisations back or helping them move forward?

Categories: Business Process, Data, Data and Application integration, Data Model Enterprise Information Management, Enterprise Metadata Management, Metadata discovery

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’. […]

Continue reading »

9th December 2013

Perhaps it is time to start acknowledging the challenge of source data analysis?

Categories: Business Process, Data and Application integration, Data Model Enterprise Information Management, Data Warehouse, Enterprise Information Management, JD Edwards, Oracle, PeopleSoft, Safyr, SAP, SAP HANA, Siebel

“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. […]

Continue reading »

24th September 2013

Data Model of JD Edwards Accounts Payable – download here

Categories: Data, Data Model Enterprise Information Management, Enterprise Application, Enterprise Metadata Management, JD Edwards, Metadata discovery, Safyr

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 […]

Continue reading »

16th September 2013

Are you a Data Modeler or Data Worker?

Categories: Data, Data Model Enterprise Information Management, Data Warehouse, Safyr, SAP

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 […]

Continue reading »

3rd September 2013

Data Model of SAP Bill of Materials Explosion – download here

Categories: Data, Data Model, Data Model Enterprise Information Management, Enterprise Metadata Management, Safyr, SAP

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 […]

Continue reading »

15th July 2013

Satnav and Data Discovery

Categories: Data, Data Model Enterprise Information Management, Enterprise Application, Enterprise Information Management, Enterprise Metadata Management, Metadata discovery, Safyr

  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 […]

Continue reading »

SIGN UP FOR SILWOOD NEWS »
Close

CUSTOMER SUPPORT

You must be registered to receive support
Please login or Register Here »


Forgot Password? Remember me

CUSTOMER REGISTRATION

Note: The token is a unique string for each Safyr license and can be found on your product delivery instructions

Already registered? Login here »

PASSWORD RESET

Enter your username
to receive your password

Login here »

Welcome to Silwood Technology. We use cookies to enhance your browsing experience. Learn more OK