SAP MDM Training-SAP MDM Tutorials,SAP MDM Jobs,SAP MDM Resumes-SAP MDM

SAP MDM Interview questions

In this two part series weblog, I have put together 10 questions that can help customers understand the importance of MDM within their enterprise. In Part I, I focused on business aspect of master data management while in this part my focus is on IT aspect of MDM. I hope you find it useful. Please provide your comments and feedback. Also, let me know if there are important questions that need to be answered during MDM implementation.

What have IT done to maintain accuracy and reliability of master data?

There is no way in the world that IT has not done anything and left it to business users in heterogeneous IT environment. If you are big SAP shop then you are probably using ALE integration or XI to transfer master data across all instances. If your landscape is mix then you may either have custom solutions or EAI tools doing work for you. But, give a closer look at the question here and then try to find out ‘what’ IT has done so far to ensure reliability and accuracy of master data. Answer most likely is going to be ‘none’ just because there were not any sophisticated tools available until now to solve this problem.

How does SAP NetWeaver MDM fit into your new IT Architecture?

Yes, ‘New Architecture’ is important here. If you and your IT are talking old way of point to point integrations, custom interfaces and not thinking of new ways of solving IT problems then stop. I think even before you start topic of MDM, you may want to focus on new IT architecture, which is more flexible and agile to adapt to new business requirements. Today’s ‘Services Oriented Architecture’ just talks about these benefits and one should think about introducing MDM in this new architecture. Master data is the foundation of business and master data management is the core of new architecture as well.

Where should I start?

Ok, I got all my pieces right, now what? Where should I start, what should I do first, how does my roadmap for MDM look like? If you not only have answers to all the questions above but have started working on implementing them, then you are on right track. You always want to start with defining master data management strategy for your enterprise and then start implementing it. Remember, SAP NetWeaver MDM is an important piece of your puzzle but not the bigger one. You need to have answers to all the questions above to start implementing MDM tool to achieve results you expect.

Why NOW?

Many customers I talked to have either major ERP project or technology enhancement projects like RFID going on. One does not want to carry forward their problems around master data going forward. It is important to think about bigger picture from your IT roadmap perspective but having MDM as an important piece of it is critical for achieving better results. You may need to find out pros/cons for MDM along with cost and benefits of it. But don’t just calculate the cost of implementing MDM but find out cost of not having MDM and you will know the answer for ‘why NOW’.

SAP MDM Training

SAP MDM Tutorials

Master Data Management - Why Now? Part I

In this two part series weblog, I have put together 10 questions that have helped customers understand the importance of SAP MDM within their enterprise. In the first part, I focus on business aspect of master data management while in the second part I will focus on IT aspect of MDM. I hope you find it useful. Please provide your comments and feedback. Also, let me know if there are important questions that need to be answered during MDM implementation.

Is management of master data strategic to your enterprise?

Master data has always been high importance to organizations but many times people don’t pay much attention to maintaining and managing master data properly. One need to ensure that management and maintenance of master data is not only of high importance to the enterprise but also strategic in terms of having reliable and accurate information management. Master data management strategy should encompass but not limited to achieving accurate and reliable master data, governance, maintaining quality of master data and ultimately achieving better results.

What is master data for your enterprise?

Generally, master data comprise of customer, supplier, product, employee, etc but is not limited to only these objects. For Oil and Gas industry, master data object can be oil well, while for food and drug industry it could be chemical composition. One need to define master data for the enterprise and should specify exclusively why.

Where and how master data is being used in your enterprise?

Once the definition of master data is clear, it is important to find out where and how master data is being used in the enterprise. One can not restrict its view to application only because sometimes use of master data could be beyond application boundaries. E.g. product which may get originated in an application can be used in a marketing campaign and may have totally different attributes than application could have. This is very important exercise of overall MDM implementation because this will define characteristics of the master data object. Once all the attributes and characteristics of master object are clear, one can start linking them to software applications.

Do you have master data management processes?

Whenever this question gets asked, one responds back with return question – ‘do I need one’? And answer is always yes. Many times people get confused between a process and a workflow. Every organization has processes and sure they have for master data management as well. Question needs to be asked around – is current process to manage and maintain master data enough? Having well defined process - from creation of master data to its retirement through retention and maintenance over its lifecycle is very important and should be well thought of during SAP MDM implementation.

How do you maintain master data quality in your organization?

What does it mean? We don’t maintain it, our IT systems maintain quality of data – this is the most common answer I had received so far. But, I must admit that some companies are ahead on this aspect than others and I realized, based on statistical data that was presented to me that enterprise needs to think of having processes and procedures to maintain data quality.

Have you implemented Master data governance?

Governance is a hot topic everywhere, from corporate governance to IT governance, it has taken important turn in the way we manage things. Having an authoritative body who defines policies and procedures, implementation of those policies and procedures and then monitoring them through out is a general purpose for governance. The same applies to master data management and it can be part of overall IT governance or information governance but one should thought about as overall MDM strategy.

SAP XI Training

SAP PI Training

Retrieving Data from MDM server using the MDM Java API

In my previous Weblog MDM Connectivity to Java Applications. I have introduced the SAP MDM connector.
In this Weblog I will go deeper and show how to establish a connection and retrieve data from MDM using the connector APIs.

The classes in the MDM Java library expose the functionality of the MDM catalog to a java application. The main functionality are:

Establishing connection
catalog data model,
multi-dimensional search
catalog data retrieval
catalog data management.

The main class in the library is the CatalogData class, which exposes all the services of the MDM Server.
Among the services that it provides outside of those of the MDM catalog itself are a local catalog data cache,
a pool of MDM Server connections, and full thread-safety. Other objects in the library exist to support the
CatalogData class. They are either used as arguments to methods or return values for methods and properties
of the CatalogData class.

The following code shows how to retrieve categories from the MDM repository.
Step 1: Obtain a connection to the MDM repository.
1.1 get the context :
Context ctx = new InitialContext();
1.2 lookup in the JDNI to get the connection factory class
IConnectionFactory connectionFactory = (IConnectionFactory)ctx.lookup("deployedAdapters/MDMEFactory/shareable/MDMEFactory");
1.3 Get Connection Spec to set connection properties
IConnectionSpec spec = connectionFactory.getConnectionSpec();
1.4 Set Connection Properties
spec.setPropertyValue("UserName", "Administrator");
spec.setPropertyValue("Password", "123456");
spec.setPropertyValue("Server", "server1");
spec.setPropertyValue("Port", "50000");
spec.setPropertyValue("RepositoryLanguage", "Chinese [HK]");
1.5 Get the Connection
IConnection connection = connectionFactory.getConnectionEx(spec);
Step 2 : obtain access to the native object
2.1 Retrieve Native inteface
INative nativeInterface = connection.retrieveNative();
2.2 Get the CatalogData the physical connection
CatalogData catalog = (CatalogData) nativeInterface.getNative(CatalogData.class.getName());
Step 3: Retrieve data from Catalog
3.1 Create ResultSetDefinition for products table
ResultSetDefinition resultdefenition = new ResultSetDefinition("Categories");
resultdefenition.AddField("Id");
3.2 Create Search object for Categories table
Search search = new Search("Categories");
3.3 Get Data from repository.
A2iResultSet rs = catalog.GetResultSet(search, resultdefenition, "Id", true, 0);
Once we have all the data in the result set, one can do manipulation on it and retrieve the data.
Step 4: Close the connection
connection.close();
The last step is configuration:
Step 5: Set the connector libraries in the application-j2ee-engine.xml file
The MDME Connector uses the SAP Connector Framework and MDME4J libraries as a shared library.
You need to add these libraries into the application-j2ee-engine.xml file.

 <?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE application-j2ee-engine SYSTEM "application-j2ee-engine.dtd"> &ltapplication-j2ee-engine> &ltreference reference-type="hard"> &ltreference-target provider-name="sap.com" target-type="library"> tc/conn/connectorframework </reference-target> </reference> &ltreference reference-type="hard"> &ltreference-target provider-name="sap.com" target-type="library">MDME4J</reference-target> </reference> &ltprovider-name&gtsap.com</provider-name> &ltfail-over-enable mode="disable"/></application-j2ee-engine>

Using MDM5.5 Java Connector with SAP Enterprise Portal 6.0

This example uses a portal component which opens a connection to a repository running on MDM Server,
retrieves data from the repository, and closes the connection.
There are 5 steps we will implement:

Set the connector libraries in the deployment descriptor file portalapp.xml
Open a connection to a repository
Get the physical connection via the native interface
Get data from a repository
Close the connection

Step 1: configure the potalapp.xml file
The MDME Connector uses the SAP Connector Framework and MDME4J libraries as a shared library.
You need to add these libraries into portalapp.xml.

&ltapplication>
  &ltapplication-config>
    &ltproperty name="SharingReference" 
   value="com.sap.portal.pcd.glservice,  com.sap.portal.ivs.connectorservice,
   SAPJ2EE::library:MDME4J"/>
  </application-config>
</application>

Step 2 : Open a connection to a repository (using the connector gatway service)

The useful EP6 features of system object aliases and single=sign-on user mapping are available

only by using the Connector Gatway Services approach.

// Get the Connector Gateway Service 
IConnectorGatewayService cgService = (IConnectorGatewayService) 
	PortalRuntime.getRuntimeResources().getService(	IConnectorService.KEY);

// Create ConnectionProperties for portal user
ConnectionProperties prop =
new ConnectionProperties(request.getLocale(), request.getUser());

// Get a connection 
IConnection connection =
cgService.getConnection("MDME_SYSTEM_ALIAS_NAME", prop);

Step 3: Get the physical connection via the native interface

Retrieve the native interface from the connection, and invoke getNative method.

// Retrieve Native inteface
INative nativeInterface = connection.retrieveNative();

// Get the CatalogData the physical connection
CatalogData catalog = (CatalogData)
nativeInterface.getNative(CatalogData.class.getName());

Step 4: Get data from a repository

All methods of the CatalogData object are available for retrieving data.

The following code uses the GetResultSet method as an example.

// Create ResultSetDefinition for products table
ResultSetDefinition rsd = new ResultSetDefinition("Products");
rsd.AddField("Name");
			
// Create Search for products table
Search search = new Search("Products");
			
// Get Data from table
A2iResultSet rs = catalog.GetResultSet(search, rsd, "Name", true, 0);

Step 5:Close the connection

connection.close();

The Architect's World - Episode 11

Prologue:

The B2B bust never happened. It’s a return of ideas. MDM 5.5 could potentially bring the concept back to life. It is the strategic decision that SAP would take in the future with MDM that would prove to be the trigger for a B2B resurrection. There exists today a substantial gap between the promise and the reality of collaborative commerce unlike what was touted in the late 90s. Visionaries always wanted us to believe that we will all soon be connected to vast, virtual, paradigm-changing digital public marketplaces & start collaborating. Like the X-Files, these marketplaces were supposed to be “somewhere out there”, we were never supposed to know where or when. From these initial thoughts are derived a set of key capabilities and requirements which may be used in the evaluation of specific collaborative commerce implementation technologies.

And more importantly, understanding the space or having a single platform vendor address business needs, not just technological, and not looking at MDM 5.5 as a lone, disconnected product as is seen by many today. Well connected and making sense. Virtual collaboration that allows the business processes of a customer’s value chain partners who are linked through the Internet, and the knowledge that is available would be exchanged throughout the value chain for a specific industry vertical with universally accepted identification numbers. Virtual collaboration is a means to increase efficiency while maintaining or even reinforcing uniqueness, a solution that now seems to be within reach with the integration of MDM in the SAP NetWeaver platform. And thus, the improvement scope for an organization broadens from reducing costs to increasing revenues, accelerating time-to-market and enhancing customer satisfaction.

A new form of virtual interaction is added to our comprehensive platform model: collaboration. Naturally, this will increase the complexity of the partners’ interactions, which are now mostly limited to informational and transactional interactions with customers who are attempting this initiative with MDM 5.5 today. At first, collaborative interactions between organizations need to focus on the operational level - upon establishing virtual links between the business processes involved. With EP as the front-end and a little bit of flexibility with SP02 proves this. Let us call this the e-Integration stage. SP02 will at least assuage MDM 5.5 users with its display abilities through the enterprise portal. This may be followed by a second collaboration stage: e-Partnering, in which the value chain partners would extend their collaborative interactions to tactical and maybe, even strategic levels. For this, the interaction with BI 3.5 would make sense. The opportunities created by such virtual collaboration are immense, especially in the area of composites. Let us try to see how MDM 5.5 in conjunction with GDS and industry specific needs will shape the vertical nets of the future as an integral part of the netweaver stack and help us define a case for MDM to carve a road ahead with ESA for an organization that is exploring such a possibility towards collaborative commerce.

Blast from the past:

An eMarketplace could be a business destination, which provides a broad offering of products, services and content as well as a venue for business transactions electronically including exchanges and an eProcurement is purchasing of materials, mainly indirect materials or services through an electronic Exchange. MDM 5.5 would be a great solution for catalog management and syndication for the same. In the past, these used to be advanced excel based tools to create .cif files for catalog management.

Buying and Selling of direct materials, finished goods, services come under eMarketplaces. eMarketplaces most often include an exchange as part of their services. For example, a marketplace might offer catalogs, Negotiations, and an exchange in addition to a number of supply chain services. (A combined digital marketplace of Ariba Marketplace and Ariba Dynamic trade) The core engine for the same is an advanced catalog management engine – something like the MDM 5.5 solution.

Name calling: Exchanges, eHubs, iHubs, e-Markets, Trading Networks, e-MarketPlaces, NetMarkets etc. etc. etc.

Resurrection of the e-marketplaces?

Early adopters across the value chain had experimented with a variety of new business-to-business commerce models, technologies and application designs. At the same time, there was always a growing demand for new standards to facilitate the exchange of information, catalog content and transactions between buyers and sellers. While the methods have been numerous and complex, the underlying goal has remained the same: to bring buyers and sellers together with an automated flow of information and transactions, while still supporting individual business and contractual relationships between trading partners, but for small collaborative chains and inherent players as depicted in our storyboard. The essence of the B2B boom now gets carried forward, except now there is a promise of reality.

The Extended Enterprise Concept now gets stretched to become an Extended Collaborative Enterprise. And the case of logical composites become:

1. Design: Product conception and design for New Product Introduction (NPI)

2. Planning: Determine product mix and quantities based on demand forecast and manufacturing capacity

3. Sourcing and reverse auction: Identify and select suppliers and negotiate and establish purchase contracts with suppliers

4. Marketing & Sales: Market and create demand for new and existing products

5. Manufacturing & Inventory Management: Work with sourcing to maintain low inventory levels and manage an efficient just-in-time (JIT) process

All these have one element in common – master data. A virtually connected extended collaborative enterprise, which the original initial players could not manage owing to a myriad of technological platform with no master data management backbone.

The Matrix Evolution:

First-generation digital e-marketplaces with the sell-side as one supplier and many buyers and the second-generation ones with the Buy-side with one buyer and many suppliers had vendors like CommerceOne, Ariba (ex-tradex), FreeMarkets (now Ariba) and others commerce solutions had fallen short of this goal with the top down approach they had, compared to the bottom-up approach with SAP NetWeaver. They had limited their focus to either the buy-side or sell-side of the equation, without truly understanding how to bring buyers and sellers together into small collaborative chains. The other shortcoming was, despite the concept of Vertical marketplaces having taken shape then, the industry backing behind the key standard bodies was disparate. A stance SAP has changed completely.

This lopsided view of the commerce process resulted in one participant (the buyer or seller) inappropriately dictating proprietary solutions or standards to the other. And, in most cases, this strategy did not scale. The next-generation of commerce solutions saw the birth of eMarketplaces. They were specifically designed to enable multi-buyer/multi-seller interaction and collaboration. They provide a common trading hub, where multiple buyers and sellers could come together and conduct commerce without compromising individual processes and relationships among the participants which is best understood by the pictorial depiction of the evolution as below:

The Matrix Revolution: MDM could be the cup of life for e-marketplaces

E-marketplaces and Vertical exchanges never died, it was only a shakeout of the incompetent and a result of nascent technology . E-procurement systems, e-marketplaces and exchanged always rode on catalog management systems. With MDM 5.5 (xCat), it would have ideally provided the perfect catalog management solution to the same. For those who been through the B2B boom and bust, it would not be completely wrong to say that these concepts existed at that point in time, they set the foundation in place. Catalog syndication is not a new concept when we were consolidating MRO items and finished goods to be hosted on the exchanges, marketplaces and e-procurement solutions. Where the B2B bubble failed was the disjoint way in which these solutions with the backend ERP systems. Again, this is only ONE factor. Today, MDM 5.5 (some call it a regression from the MDM 3.0 solution), on the ABAP stack. MDM 5.5 is a standalone application, nothing to do with WAS – pure xCat application, does not hold much promise. But what is important is the vision that one may want to decipher that SAP may be taking with the same. One would presume that the next version (MDM 7.0?) would be on a WAS (Java +ABAP) stack, fully integrated with EP in the true sense using XI and BI (and beyond) for a complete solution.

Some solution architecture thoughts on MDM in your landscape:

(a) Acting as the online hub for catalog management, syndication across the landscape, the master being the source of truth, flexibility for an organization would be rendered to create online stores with ease through the enterprise portal – specific and business partner driven.

(b) Business partner-specific product catalogs published online to help organizations wired exchanges and e-marketplaces providing community specific information like pricing and specifications to create a network of coherent business partners where the data is harmonized within the organization and extended to the partner community.

(c) Synchronization of trading item catalogs with vertical-specific hubs like Transora or UCCNet data pools, using GDS to create a meta-directory of items facilitating the use of industry-specific standards. An Industry specific yellow pages for all materials to be synchronized and used for trading. (This would necessitate the need for XI and BI leading to Analytics and CAF)

(d) Extended Supplier extranets to facilitate reverse auctions, linked up with the e-marketplaces to be considered as xAPPs extended from what pure-play vendors set out towards. These composites need to switch between intranets and extranets to address various processes.

This is where composites need to seamlessly address processes to complete process loops over the extended value chain and this is the culmination of all our efforts with ESA.

MDM 5.5 – Old wine in a new bottle, and it tastes good!

Before we get into the MDM mould and explore some of the details it is important to understand a little on the background on the product evolution. The MDM product was available for the last few years and its last version was MDM 3.0 this product was ABAP based tool with decent capabilities in large scale data integration and consolidation between SAP systems. The problem with this application was that it was way too complicated for a quick implementation and lacked the feel-good factor on the front-end. SAP may have had to decide whether to invest more on development efforts or to buy off another application from a vendor that would be able to provide the missing capabilities. The quest for this tool led SAP towards A2I and their product called xCat(Of course, there would be other strategic thought processes).

Even though the xCat product was intended for product catalog management, it seems to have the potential - both from a conceptual and a technical standpoint – to fit snugly under the SAP NetWeaver umbrella. At first this product was called MDME (MDM Extension) but now it was announced as the MDM official tool by SAP. The MDM5.5 application can help in providing data Modeling , data consolidation, fast data extraction , and decent search capabilities, and it seems realatively simple for installation and implementation (both from infrastructure standpoint and end user experience). Add to this a good experience in business scenario handling for MDM, as it was captured during the years in the “old” MDM development team and the technology which enables one to do complex things with little effort.

Product Catalog Management, doesn’t it sound familiar?

A PCM product would help the catalog manager of a product company manage the different aspects of information about the product. It could be complex with a lot of information to be handled. Every product oriented company has to have its product catalog in order to use it both internally (for manufacturing, purchasing, etc) and externally (customers, suppliers, etc). Complexity could be owing to a product that can be built from several parts, of various configurations, and can be connected to other associated products. In most companies the product information comes from different places in the organization (manufacturing, purchasing, operations, etc) derived from that it is stored in different IT systems to help in:

a. Extracting product information from different source systems

b. Consolidating information and convert different terminology of the same product

c. Providing ways of organizing the information depending on the user group for specific information

d. Providing fast and intuitive search

e. Providing different ways of displaying the catalog – especially, quick publishing online via EP using Java APIs

The Online Laundromat - MDM

Here we need to answer what is Master Data, well if I will try to define it in a simple way I can say that Master Data is descriptive data regarding specific entity. The Master Data is fairly Static and it is not contains transactional information

So Master Data Management systems came to solve those issues, by providing tools for extracting master data from different IT systems, consolidating master data coming from different sources, central Management crosses IT systems and master Data Provisioning from and to the different IT systems in the organization. The PCM is just a private case of MDM with some extensions like printing catalogs or image management.</p. <p>To ensure that we progress towards the b2b vision, the MDM 5.5 comes in useful when you need to define a generic/flexible data model that is able to pull in data from different sources to have a consolidated source for all master data. Then comes the job of cleansing the data across organization (find duplicates , find similarities ,define transformation rules, etc) in the master server and finally create slaves to help use the data and uses personalized access to Master Data according to end user profile (progress is already up for review with SP2 and finally synchronize the Master Data with different systems holding equivalent information (something that may not be possible today) However, the speed of accessing the data with MDM 5.5 is nothing short of phenomenal, especially when it comes to large number of records.

The Plug Ins (QuarkXPress and Adobe InDesign) come in very handy in publishing catalogs are part of the PCM scenario’s supported by this tool, the Image Manager is for handling Images usually kept in products context and the Plug Ins are meant for publishing the product catalog in different ways. Customers without an MDM solution till date have been trying out all possibilities to handle this. Sample third party applications containing this data which needs to be integrated via the enterprise portal as part of a POC. Add to the the java APIs which can be used by organizations to create their own storefronts. Now, this is an area which has to be put in place by SAP very fast. Imagine customers with an MDM solution in place creating web applications in IBM Websphere or any other application server to create their on static web-stores. Of coursem this is a technological solution, but if falls completely out of sync with the bigger picture with SAP. It is debatable whether this approach is good or not.

The Management Console

The console is primarily intended for two roles – The MDM administrator which deals with connectivity, accessibility, security, etc and the other, The MDM modeler, for creation and maintenance of the object/data model as defined according to business needs.

An Stop-gap arrangement for XI – Bring on the Import Manager

With limited data sources to deal with, the Import Manger is today meant for importing data from several data-sources (can be relation DB, can be excel-sheet) in order to define and population of the data model. With this, one can define the rules for importing data into the model according to the source structure. To assist in aggregation of data from electronically format (the source), transforming the same using rules, rationalizing and normalizing the data to finally have a clean set of data without having to do any coding is where the punch lies.

Of course, it has always been a point of debate on the usage of XI 3.0 for the same. But if it is a one-time load (which is not the idea here), it makes no sense. It is like using a Cadillac for buying groceries. Once the entire landscape is in perspective with the master and the slaves defined, along with data upload and distribution strategies in place, XI starts making sense. It has to come in sooner or later as the landscape will move towards GDS (it the vertical is retail) with 1SYNC today, along with the mandate for the usage of BI and Solution Manager in the landscape. But it is the need today that should define the IT strategy. Maybe not stop-gap at all.

A Stepping stone towards ESA – The Syndication Manager

The Syndication Manager is the component that knows how to exchange data with other systems, meaning this tool will be the one that will handle the synchronization between the MDM storage and the source systems. The syndication manager will not do it alone but it will warrant the use of XI in order to provide a robust way for interacting with the myriad systems the client would have in the landscape. Then again, this is an area which will have explored in detail before an solution can be proposed.

Content Manager

The content manager is what the end user needs to maintain and work with Master Data. Also known as “the client”, it finds its use in fetching data in the most intuitive way across users working on the same data model. In reality, the workflow feature for adding, changing and flagging for deletion the master data is not something that The workflow to manage the master date stored in the MDM (add, change, flag for delete), supposedly to be with workflows (a .exe file available with SP02, which is currently being explored in-house) should really set the ball rolling.) may work. If it doesn’t provide the desired results, there are options to get this in place – create customized iViews for changing and deleting records, create a custom workflow engine integrated with EP to handle this or use webflow, or use a third party workflow engine. MDM being deployed on WAS would be very useful indeed from an integration standpoint.

The invisible men - MDM Java APIs

The MDM5.5 server exposes API both for java and Microsoft applications (.Net and previous) that enables your applications to use the data and functionality provided by it. Due to the fact that most of the MDM5.5 functionality is done in the server, every thing that you can do from one of the clients above you can do from your applications via the API. API for ABAP is being developed as we speak and will be available in the near future. Now, the point that needs to be kept in mind is – how does one, as a Solution Architect, influence the decision of having this on-line web-store within the boundaries of SAP Applications?

GDS and Vertical Nets:

The next step of the solution makes sense when we bring in the vertical industry specific nets into the picture. And this is the area when XI and BI start making sense in the big scheme of things. Leading one to believe that MDM 7.0 (Or whatever), would be an application deployed on WAS (Java and ABAP) soon and xCat would soon be a thing of the past. When we extend our solution as an on-line marketplace with or without SRM/EBP with MDM to publish catalogs on an online store with the Java APIs on an application on or not on WAS, it may not help an organization derive the true business benefits of collaborative commerce with what SAP has on the anvil. Extend this with GDS and the RFID concept and that is leads one to the concept of resurrecting B2B exchanges.

Epilogue:

This is something that may or may not happen in toto. But it is logically possible. And with the SAP NetWeaver platform in place, MDM 5.5 does become the backbone for these c-chains in the future. Conservative companies will be in a position to reach out to their business partners in a collaborative manner with minimal investment. The emergence of 1SYNC, the transition of Transora from a B2B marketplace running Ariba Marketplace, an e2open with Dynamic trace…..the new IT landscape layout and the orchestration of the various elements that would render the usefulness of ESA. Afterall, wasn’t SOA a core concept with the B2B boom? This is where ESA begins. More on this topic on my next blog

MDM as a core NetWeaver component

MDM is a wonderful tool for data consolidation and harmonization. All customers with multiple applications, each with multiple definitions of data assets, soon or later will face redundancy, waste, and lots of lost opportunities. MDM comes along to solve all this, and while it can be used as an standalone application, I’ve found that using it with other NetWeaver components will greatly help to raise its value.

In order to demonstrate the huge flexibility of MDM as a core part of NetWeaver, I propose the following architecture as a simulation of data integration system:

mdm

In this example, I’m planning to use any standard SQL based system such as mySql or even MS Excel to demonstrate its flexibility and ease of use. Both sources should have different data structure and some duplicated data, such as in real life. MDM will then harmonize and syndicate all data using XI as the main media for this. This way, we will be able to use XI characteristics such as workflow integration.

It’s clear that the same integration could be done without SAP XI, however, establishing point to point connections will probe to be unmanageable due to the overhead caused by the addition of new systems, duplication of business objects and lack of transparency on the data flow. By introducing XI, all data will become compatible and as a result we will obtain a highly scalable landscape, reducing costs and time of implementation.

I am currently developing this architecture and I want to share my results. Soon I’ll post my experiences, recommendations and problems I encounter during this process.

Brief Introduction to Masks in MDM 5.5

What are Masks?

As Roman Rytov explains in one of his blogs, Masks are static lists of selected object and not executed every time. To put it in other words, Mask is a snap shot of the whole bunch of records.

SAP’s MDM Console guide’s definition: A mask acts like a stencil, in that it blocks (“masks”) all main table records from view except the defined subset of records that are included in the mask, to allow the subset to be viewed and manipulated as a whole.

Is there any separate table for Masks?

Yes. There is a Special Table(Hierarchy) called Masks. Whenever a new repository is created, a special table called "Masks" is also created by default (along with other special tables).

How to create a Mask?

Select the Menu option "Records->Modify Mask..." and in the available Masks, right click and add a Mask as a sibling or child.

How to add/remove records to/from a Mask?

From the MDM Client go to “Records” Mode and from the List of records displayed, select the records that you want to add to a mask, right click and choose “Add to Mask” from the context menu. Choose the mask to which you want to add records from the cascading hierarchy of menus.

For removing records from the mask or to replace records in the mask, try other options displayed in the context menu.

Where can I use the Masks?

The customer has a product repository mounted on MDM and he has different users accessing this repository. The customer's requirement may be is to restrict the users from accessing the complete set of records and allow them to access only a subset of records.

This solution can be achieved easily by utilizing the Masking capability in MDM 5.5. First of all, different masks will be created and records to these masks will be added as per the requirement. After this, the users will be given access to a specific Mask containing the records that are relevant to the user (Hint:Just play around with the "Users" & "Roles" in Console).

SAP MDM TRAINNG

del.icio.us Tags: sap mdm tutorials,sap mdm training in hyderabad,sap mdm training in banglore