What is XSD and XML Schema

[Former Member]

Hi Experts,

I want to thank you all. I have learnt a lot of thing from SDN and from your help.

I have some dooubt in the following areas. Please help me.

1) What is XSD, XML Schema?

2)How to generate XSD schema from the existing repository?

2) How to import XSD to XML Schema?

4) How can we create repository from XML Schema and why?

I am no basic idea of XSD and XML Schema. So Plaese write me using some simple words and example so that I can practice it.

Thanks

[Former Member]

Hi

Follow the below procedure to create a repository from the XML schema.

1. In the Console Hierarchy tree, right-click on an MDM Server node and choose Create Repository from Schema from the context menu, or select the tree node and choose Repositories ® Create from Schema from the main menu. MDM opens the Windows file Open dialog.

2. Select the XML schema file to use to create the new repository and click Open. MDM opens the Create MDM Repository dialog.

3. Select the DBMS Server for the MDM repository from the drop-down list.

To reference a SQL Server named instance, append a backslash () and the instance name after the machine name above.

To use Windows authentication, leave the Login empty (requires the SQL Server Allow Windows Authentication Mode parameter in the MDM Server Settings file (mds.ini) to be set to True).

To remove an entry from the drop-down list of DBMS Servers, make it visible in the closed drop-down control and press Del.

The drop-down list of DBMS Servers includes only those servers that you have previously added to the list and will usually include for selection all the servers to which you might want to connect. If the desired server is not in the list, click the browse button (…) to open the Select DBMS Server dialog, and select from the list of DBMS Servers known to MDM. If the desired DBMS Server is not in this list either, then click the Add button in the Select DBMS Server dialog to open the Add DBMS Server dialog, and select from the list of servers (or type in a new name in the text entry control at the top of the dialog), and choose the DBMS type from the drop-down list. (For more information, see DBMS Servers List.)

4. Enter the appropriate DBMS login (which must have system administrator privileges) and password for the selected DBMS Server and click Next. MDM disables the DBMS Server, Login, and Password fields and enables the Repository Name and Port fields.

5. Enter the name for the new MDM repository.

6. If necessary, edit the TCP/IP port number in the Port text box. This would be necessary only if there are multiple MDM repositories, or if the default port number and/or two numbers following it in sequence are used by some other program on the host computer. Your Network Administrator can provide an alternate port number, if needed.

7. Click Finish to create the MDM repository. MDM creates the new MDM repository and adds it to the Console Hierarchy tree. The new repository automatically has the schema structure specified by the XML schema file.

Regards

[Former Member]

Hi ,

I will try to answer your queries in simple language:

1) What is XSD, XML Schema?

2)How to generate XSD schema from the existing repository?

2) How to import XSD to XML Schema?

4) How can we create repository from XML Schema and why?

Solution-

1. XSD is called as the Schema File Definition. You need to create this using the Repository Schema.

• XML Schema is the schema that you export/import from an MDM repository.

Console->Right click on the repository->Export Rep schema

2. XSD are generated using a software called XOMLITE45 which requires Java to be loaded on the system. You can use this software and very easily generate an XSD out of the Repository schema.

3. Once you have created the XSD, you can then upload the XSD under the XML Schema.

Console->Repository->Admin Node-> XML Schema

Once you upload it, it will be available in Import Manger and syndicator for future use.

4. You can create a repository struture out of the XML Schema that you will export from the Repository.

You can then import the Schema into a New repository or overwrite an existing Repository.

This is generally used for Creating XSD's and also for Back-up activites.

*Do not get confused. Please note

*XSD's created after XOMlite are stored under XML schema Node.

We cannot directly import an XML file from Port. It is done using an XML schema ( XSD) that you will have to load in Console.

These are the steps to create an XSD out of the Repository schema :

You require a repository structure to start off with the proceedings.

Please follow the steps :

1. Right click on the rep schema-> Export repository schema ( Save it on your desktop)

2. The schema that you have exported, will be needed to create the XSD.

3. To convert the XML into XSD, we require a "Xomlite" ( which You have got using Simona's link). And we require JAVA to run it.

4. For that, we need to copy the Templates, XOMLITE and the repository schema that you have exported. Place these 3 files in the Java Environment Bin folder.

D:\j2sdk1...\bin

5. Now we need to run the Jar File in JAVA.

6. Go to CMD in RUN.

7. go to D:\> cd j2sdk1.....\bin

8. go to D:\> cd j2sdk1.....\bin> java -jar Xomlite45.jar

9. this will ask for the file name - enter the Rep schema Name that you have placed in the Bin folder.

D:\> cd j2sdk1.....\bin> java -jar Xomlite45.jar File.xml

This will create the XSD in the same BIn folder.

Hope it helps.

Thanks and Regards

Nitin Jain

Edited by: Nitin Jain on Apr 28, 2008 9:46 AM

[Former Member]

Hi Halder,

1) What is XSD, XML Schema?

XML means extensible markup language used to store the data and transport the data.XML contains root

elememts,child elements , attributes and their values.

When you come to XML schema , it deos not contain any data.It describies just structure of XML

document.The XML schema language is also reffered to as XML schema definition(XSD).

The purpose of XML schema is to define the legal building blocks of an XML document.

1) XML schema defines elements that can appear in a XML document.

2) Defines attributes that can appear in a XML document.

3) Defines which elements are child elements.

4) Defines the order of child elements .

5) Defines the number of child elements .

6) Defines whether an element is empty or can include text.

7) Defines data types for elements and attributes.

😎 Defines default and fixed values for elements and attributes

How to import XSD to XML Schema?

The XML schema table is an MDM system table .When you first create the MDM repository , MDM

automatically creates the XML schemas table.Each record that you add in MDM consloe identifies

a particular XML schema that can be stored within MDM repository for use in MDM import manager

and Syndicator.

How can we create repository from XML Schema and why?

In MDM Console, we can export the repository structure to an schema file using export repository schema

option and later we can import same schema file to an existing MDM repository using import repository

schema command or we can create new repository using create new repository option from XML schema .

When you use the schema export and import features of console,only the structure will be imported and

exported, data will not be transported.Genarally it is used to backup the repository structure and used in

some other server without data.

2)How to generate XSD schema from the existing repository?

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf0e8a97-0d01-0010-f0a2-af3b18b7...

Hope it helps,

Reward points,if found useful.

Cheers,

Narendra.M

[Former Member]

Hi Pappu,

1) What is XSD, XML Schema?

Each XML schema file is an .xsd file that defines the XML schema.

XSDs describe XMLs (message data), either for master data object or for reference data. The XSDs do not contain a repository structure.

These links will help.

http://help.sap.com/saphelp_mdm550/helpdata/en/21/670a31c47e46bdb59732386ddedc16/frameset.htm

http://help.sap.com/saphelp_mdm550/helpdata/en/42/e9cfa1d2e23ee6e10000000a1553f7/frameset.htm

http://help.sap.com/saphelp_mdm550/helpdata/en/44/ab7ed765d37455e10000000a11466f/frameset.htm

2)How to generate XSD schema from the existing repository?

Pls refer How to Generate XSD Schemas from Existing MDM 5.5 Repositories under the HOW-TO guides of MDM

https://www.sdn.sap.com/irj/sdn/nw-mdm?rid=/webcontent/uuid/5024a59a-4276-2910-7580-f52eb789194b [original link is broken]

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf0e8a97-0d01-0010-f0a2-af3b18b7...

Also this thread will help you,

2) How to import XSD to XML Schema?

The name of each XML schema is automatically added to the drop-down list of: (1) import file types supported by the MDM Import Manager; and (2) XML schema definition files supported by the MDM Syndicator.

4) How can we create repository from XML Schema and why?

We have to create new repository from XML schema in times of upgrades or sending the repository to other servers without data.

Suppose after the upgrade, needs to transfer the changes to prod system.

[Exporting an MDM Repository Schema |http://help.sap.com/saphelp_mdm550/helpdata/en/f2/2f21039e9146098e7b238f1a4c8e5e/frameset.htm]

[Importing the Schema |http://help.sap.com/saphelp_mdm550/helpdata/en/c9/460487162c430d933aba9ff256a970/frameset.htm]

[Importing an MDM Repository Schema |http://help.sap.com/saphelp_mdm550/helpdata/en/fe/8aa2bbdb0d41a0a6b37194ea614f11/frameset.htm]

How to Transport Master Data Management Objects between Master Data Management 5.5 Systems (NW7.0)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20751e78-f81f-2a10-228f-eb3a1642...

Hope this helps,

+ An