06-27-2011 05:34 AM
I would like to export a job I've built in the DI Studio 4.21M3 to a CWM/XMI file, that can be read in another metadata tool. How would I do that actually? All I can find is a functionality to trigger an SPK export.
Thanks and regards,
06-27-2011 06:23 AM
I've never done it but when searching DIS's help using keyword 'CWM' I find this entry: "Exporting Metadata with a SAS Metadata Bridge".
When choosing File/Export/Metadata I'm getting a long list of available export formats in my DIS instance (4.21).
06-27-2011 06:26 AM
I see, that did the trick. I was trying to export directly via right mouse click on the job.
But here it seems that I can only export tables and not jobs. Do I miss something?
06-27-2011 07:57 AM
There is no CWM export facility for jobs, only for tables and columns. One possible way to get CWM job output using some programming would be to first export the job into the .spk package file which contains the full job XML if you include associated objects such as physical tables in it. Then write an XSL conversion on the job XML in the spk package to convert it to CWM format. Development does this sort of thing when it does differencing of job XML for versioning, which is coming in the 9.3 release of DI Studio. The 9.3 differencing facility pulls out the job XML from the .spk package content, and runs an XSL conversion on it to make the view more user friendly. You could do something similar to convert to another format. The OMR metadata format is loosely based on CWM structures, so there would be a fairly close correlation to CWM object types.
There has been a request to add this capability in the future, but no near term plans for it.
Hope this helps,