Skip to Content
author's profile photo Former Member
Former Member

Console

Hi Experts,

I am new to MDM and want to know the console.

i.e

1.What are the important features in Console.

2.Which type of Tables are more frequently used in realtime.

3.will give a neat explanation for dataconsole with realtime example.

Please help me a lot where i am new and very eager to learn MDM

Please do the needful.

Regards,

Raj.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 06:07 AM

    Hi Amruth,

    MDM console is the administrative tool with the MDM box.You have 4 MDM guis to work with the master datain MDM

    - Console

    - Data manager

    - Import manager

    - Syndicator.

    Out of these Console is where the Master data repository administration and security is handled.

    What are the important features in Console.

    - In console you initially perform the data modelling.which is the most imp step before going ahead with master data management through mdm.Data modelling means repository designing in simple words.Its involves determing the tables and the fields that will build the data rep but also the properties of every field and table in depth.As this will determine your data performance and operation ease in the later stage.

    -It also includes maintaining informations such as the remotes sytem from which master data is either inputed or outputted.and the ports details for configurng the same.

    - Also schema and security details etc.

    everything is short can be managed and handled from the MDM console as far as the design and administration is concerned.not just the repository but also the server information.

    Which type of Tables are more frequently used in realtime

    - This will completely depend on your real time project and themaster that you are trying to maintain through MDM.

    - The only table that compulsorily needs to be used and is the most imp table is the main table.

    - The rest tables can be used as per requirement.

    - For eg if you are storing Dependent information you will ahv eto use Qulaified table.Or if you have to store hierarchical data you acn use teh hierarchy or taxonomy table.

    - Note that all of these additional tables besides the main tale are optional.

    will give a neat explanation for dataconsole with realtime example.

    - In real time not all will have access to the mdm console.As this is teh administrative tool as said earlier and so only the system administrator will have rghts to work on this.

    - In real time the administrator will design the mdm rep,

    - He will also handle the security data like which all users should have access to which all tables and fields.

    - Also function level security needs to managed by the administrator like read wright access etc.

    - Also changing the port details etc whenever needed.

    - And most imp monitoring the repositor state like loaded/unloaded and also that the mdm server is always up and runing.

    You can also refer the below links on mdm console activities.:

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80fc0a2e-6561-2910-839e-8ff3e36dd4d6 (data modelling)

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/eb7447b1-0c01-0010-8d90-a2e004cad537 (data modelling)

    Hope it Helped

    Kindly mark the thread as answered if your query is resolved so that others can refer to similar query.

    Thanks & Regards

    Simona Pinto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:28 AM

    Hi,

    MDM Console is nothing but where u design your data model i.e. data repository.

    It is used to define tables,fields,constraints,relationship,roles and authorizations for a repository.You connect to MDM server and database using Console.

    Connect to console.enter MDM server name ,DBMS name,username and password.Then right click on seerver say Create Repository(eg :Customer)

    For customer u have various fields like iD ,Name,Account no,country etc.Go to Products(main) table and try adding these.U can also use standard business content(Unarchive it).you can download the business content from service.sap.com

    Main table,Look up table are used for frequently.

    You can refer help.sap.com

    Regards

    Nisha

    Edited by: Nisha L on Dec 18, 2008 7:30 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:30 AM

    Hi Amruth,

    MDM Console is used for Administrative purpose like Repository Maintainance which involves Creation, Deletion and Updation of existing repositories, Users & Roles maintainance and there are lots more

    Various tables present in the repository are:

    1. Main Table

    2. Lookup

    3. Lookup

    4. Lookup

    5. Lookup

    6. Object tables

    Usage of tables are completely depends upon the requirement. But Main table is the default one and all other tables are optional.

    Refer the below link for complete information about MDM Console

    http://help.sap.com/saphelp_mdm550/helpdata/en/8e/9f9c427055c66ae10000000a155106/frameset.htm

    Regards,

    Jitesh Talreja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:31 AM

    Hi Amruth,

    Console is one amongst the four MDM GUIs.

    The data modelling part of the master data management is done is console.

    There is basically one main table and four types of lookup tables.

    They are look up flat, qualified table, hierarchy and taxonomy.

    Apart from this we have object tables like images, pdfs, binary objects, sound files etc.

    Also there are special tables like masks, named search, relationship etc and system tables like roles, users, change tracking, port, remote systems etc.

    In the console we perform various operations like defining the remote systems, port, users, role, etc.

    The data modeling includes defining various tables and look ups and also varios fields.

    We can also define various constraints for users or roles in the console.

    Apart from this we can also change password and perform certain DBMS settings from the console.

    For more information refer to the below link.

    http://help.sap.com/saphelp_mdm550/helpdata/en/8e/9f9c427055c66ae10000000a155106/frameset.htm

    Hope it helps.

    Thanks,

    Minaz

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:32 AM

    Hi Amruth,

    SAP MDM have different clients like Console, Import manager, Data Manager, Syndicator.

    Mainly console is used for administration purpose.

    Database Modeling is happening here.We create repository and each repository have diff tables like main table, sub table, system table, object tables and special tables.

    Main Table: Till SAP MDM 5.5, there is only one main table in a repository.But from MDM 7.1 there can be multiple main table.A main table contains primary information about a business object such

    as a product or supplier

    Subtables. An MDM repository can have any number of subtables.A subtable is usually used as a lookup table to define the set of legal values to which a corresponding lookup field in the main table can beassigned; these tables hold the lookup information.eg: Hierachy tables.Taxnomy table, Qualified Table

    Object tables. Object tables, including the Images, Sounds, Videos,Binary Objects, Text Blocks, Copy Blocks, Text HTMLs, and PDFs tables, are a special type of lookup subtable, where each object table

    is used to store a single type of object. You cannot store an object directly in a main or subtable field in an MDM repository.

    Special tables. Special tables include the Image Variants, Masks, Families, Relationships, Workflows, Named Searches, Tuples(only on MDM 7.1), DataGroups, and Validation Groups tables

    System tables. System tables appear under the Admin node in the Console Hierarchy and include Roles, Users, Connections, Change Tracking, Remote Systems, Ports, Links, XML Schemas, and

    Reports, and Logs.

    During the starting phase of a projects, depends upon the requirements we have to model the repository.

    So depends upon the requirements we have to work on diff tables.

    Also console is used for creation of users, rolesSo security can be handle from here.

    Also change tracking can activate from console. Whenever there is any change in the database, that can be track using change tracking.

    Regards,

    Nikhil

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      It all depends on your requirements.

      Mainly you should work in Main table, Subtables Taxonomy table, Hiearchy Table, Flat Table, Object tables Images, Sounds, Videos, Binary Objects, Text Blocks, Copy Blocks, Text HTMLs, and PDFs tables,Special tables Image Variants, Masks, Families, Relationships, Workflows, Named Searches, Data Groups, and Validation Groups tables. and System tables Roles, Users, Connections, Change Tracking, Remote Systems, Ports, Links, XML Schemas, and Reports, and Logs.

      Regards

      Kaushik Banerjee

  • Posted on Dec 22, 2008 at 04:24 AM

    Hi Amruth,

    MDM Console :

    The Administrator or we can say work for repository maintainance and managment, Creation and setting up the roles and user.

    Kinds of tables are Main table, subtables, system tables, special tables and object tables.

    for rest of other things please go through help.sap.com. it's a kind of bible in MDM.

    Hope it helps,

    Rgds

    Deepak

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.