Hello, everybody. This is my first blog, finally. I wanna to get some points, and make some friends. You can also visit my msn space: http://shenpng.spaces.live.com (http://shenpng.spaces.live.com). I’m a fun of NetWeaver. As a PI Consultant, I’m also interested in EP,MDM,BI. Recently, we have hunderds of scenarios like jdbc to proxy, proxy to jdbc. on the project. I’m tired to create so many data types.I hate routine works. Then I found that, I could write a program to generate XSD, and import it for data type definition. first, I collect all fields in one txt file for each table. 
My program will read all txt files in the folder, and generate XSD files like this:
Now import the XSD one by one for data types. You can get what you want.
My program will read all txt files in the folder, and generate XSD files like this:Now import the XSD one by one for data types. You can get what you want.
Have you thought about enhancing your work to create a generic code in order to include deeply nested structures too? Single level node have very limited applications usually. This topic can actually have many points involved. A few are:
1. When you talk about JDBC receiver structure, you may add some code for making the "key" node if required.
2. When creating any node, you also need to think about the occurrence. (Pass it in source or..?)
3. Type of field (string, integer) could be required to pass.
Regards,
Prateek
It will make development much easier and mean less tedius work.
/Daniel Graversen
http://figaf.com
Good effort thoe to automate metadata creation.