Genarating XSD from Repositories.

[former_member283645]

Hi every one,

When we need to syndicate data in xml format we need to have a xsd schma file in syndicator.

If a repository has 1 main table, 4 lookuptables and 1 qualified, taxonomy and hierarchy tables.

1) Should we need to create xsd file for each table separatly and use them in syndicator separatly or 1 xsd file for complete repository?

2) Can anyone explain the standerd and simplest way to generate xsd files for both mdm 5.5 and mdm 7.1 versions??

Thanks & Regards

Eva M

[Former Member]

Hi Eva,

I agree with Aamir points

some more clarification on your question

1) Should we need to create xsd file for each table separately and use them in syndicator separately or 1 xsd file for complete repository?

Ans: you do not require to create separate XSD file for each table but your xml file size will increase and it will impact on performance during importing of data to MDM

So i would suggest create separate XSD file for Taxonomy data as its contain attributes and attributes value which value are changing dynamically so there will two XSD one is for main, qualified, tuple table and other for taxonomy table.

2) Can anyone explain the standard and simplest way to generate xsd files for both mdm 5.5 and mdm 7.1 versions??

Ans: SAP provide SAP Studio through which u can generate XSD for MDM 5.5 and 7.1 and XOMlite, Altovaspy software

So i would suggest if you have SAP ECC system then create customize Message Type (IDOC Type) and Create XML Schema and convert this XML Schema in to XSD through XI, SAP Studio, Xomlite

or

SAP Business content provide standard XSD Schema File you can utilize those file or export repository Schema from

MDM repository and convert in to XSD

Thanks,

Jignesh Patel

Edited by: jignesh patel on Aug 19, 2010 4:02 PM

[former_member283645]

SAP provide SAP Studio through which u can generate XSD for MDM 5.5 and 7.1 and XOMlite, Altovaspy software

So i would suggest if you have SAP ECC system then create customize Message Type (IDOC Type) and Create XML Schema and convert this XML Schema in to XSD through XI, SAP Studio, Xomlite

Hi Jignesh,

Do you steps to create xsd from sap studio?

Also, do you have steps to create in xsd from ECC system?

Kind Regards

Eva M

[former_member182007]

Eva

you can follow below podcast in order to get the step by step approach for generating xsd from SAP NWDS.

http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/d0694d7d-ead4-2c10-8e89-c3312fb63581

hope it helps.

Deep

[Former Member]

Hi Eva,

are you doing any Customize enhancement in SAP for any segment in IDOC TYPE if not use SAP Standard XSD file.

for any modification on this standard XSD use can use altova spy software which allow you to addition deletion and changes to schema segment

Abt you Question:

Also, do you have steps to create in xsd from ECC system?

to generate XSD file from ECC take help of Technical Consultant(ABAP Resource) they have proper idea

some step as follows :

1. first Create customize Message type e.g. Z_MATMAS (TCode WE81)

2. Create Customize IDOC Type by utilizing standard SAP IDOC type and add,for e.g. Z_MATMAS05 (TCode WE30)

3. Assign this customize IDOC Type to Message Type (TCode WE82)

4. Use (Tcode WE60) and generate XML Schema

Note : after Customizing Message Type IDOC Type need to write functional module for posting IDOC to SAP

Note : if you are using standard IDOC Type from SAP use (Tcode we60) and generate XML Schema file

after generating XML schema generate XSD Schema through XI, SAP Studio, Xomlite

Also, do you have steps to create in xsd from ECC system?

Some How to guide are available on SDN step by step approach for generating xsd link as follows

Which may help you

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

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c065c565-60a4-2c10-8d95-af250ca89478

Thanks,

Jignesh Patel

[Former Member]

>>Should we need to create xsd file for each table separately and use them in syndicator separately or 1 xsd file for complete repository?

It depends upon your business requirement, below are pros and cons of both:

One big XSD with all the tables in it:

This will increase the size of XML file, there may be lots of fields which will be blanks, if a check is make for mandatory field, that check will fail. Secondly, if there is change in any lookup table, you need to change the big XSD which will also impact other syndication maps (you may have to redo all the maps again).

Separate XSD's for different tables:

This will require more effort in creation of XSD (since you will make multiple XSD's) but effort after that will be greatly reduced, it is much easier to manager individual XSD's without impacting other maps, also the size of XML will be less.

I have always used separate XSD's for different tables.

>>Can anyone explain the standard and simplest way to generate xsd files for both mdm 5.5 and mdm 7.1 versions??

For MDM 5.5, you can use XOMlite but for MDM 7.1 i haven't been able to find a tool which automates the whole process (most tools miss Tuples). To tell you frankly, manual XSD creation is not that time consuming. to save some time, you can get basic XSD structure from any tool (liquid XML, NWDS etc) and then use Altova XML Spy to modify them as per your requirement.

Thanks

Aamir

[former_member182007]

Eva

hope below URL helps you

it states the same concern.

Deep