BookmarkSubscribeRSS Feed
milts
Pyrite | Level 9
Hi,

Please correct me if I'm wrong and sorry if my question sounds confusing.

I heard that ETL Studio uses XML as its file type when exporting jobs/etc while DI Studio's saves it as an .spk file. What is the structure of the XML file back then on ETL Studio's era? And why was the save as XML file when exporting metadata removed in DI Studio?

Thanks!
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You may want to consider opening a SAS Support tracking issue to address your SAS architecture questions - I noticed that the SAS DI Studio 3.4 Guide has the paragraph pasted below, regarding exporting metadata (Chapter 4, page 67):

Scott Barry
SBBWorks, Inc.



For more information about the export and import of whole metadata repositories,
administrators should see the metadata management chapters in the SAS Intelligence Platform: System Administration Guide, especially the "Creating, Moving, Copying, and Deleting Metadata Repositories" chapter.
LinusH
Tourmaline | Level 20
This might be a bit confusing.
As a part of the concept partial promotion, they created the Export/Import Wizards, which as you notice is a compressed package file. The package file itself contains a XML-file, a log and an extra file I don't really know what is used for. These can only be used within SAS environments, I guess, since job/process definition are very SAS specific.

Still, there is a tool called Metadata Exporter/Importer (reached from the Tool menu) which can be used if you plan to share metadata between SAS and other products such as ERwin, external DBMS etc. These files are XML as well, using the Common Warehouse Metamodel standard.

/Linus
Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 576 views
  • 0 likes
  • 3 in conversation