SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

CWM/XMI Export of ETL Jobs

Reply
Contributor
Posts: 38

CWM/XMI Export of ETL Jobs

Hi all,

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,

Thomas

Respected Advisor
Posts: 4,173

CWM/XMI Export of ETL Jobs

Posted in reply to thomash123

Hi

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).

HTH

Patrick

Contributor
Posts: 38

Re: CWM/XMI Export of ETL Jobs

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?

Thanks,

Thomas

SAS Employee
Posts: 38

CWM/XMI Export of ETL Jobs

Posted in reply to thomash123

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,

nar@sas

Contributor
Posts: 38

Re: CWM/XMI Export of ETL Jobs

Hi,

as we are currently facing the same question: Has there been any update on this topic?

Thanks,

Thomas

Respected Advisor
Posts: 4,173

Re: CWM/XMI Export of ETL Jobs

Posted in reply to thomash123
Ask a Question
Discussion stats
  • 5 replies
  • 2456 views
  • 0 likes
  • 3 in conversation