How to extract SAS® Customer Intelligence Objects from your SAS Metadata Repository.
To extract Metadata for the SAS® Customer Intelligence objects, like for example the export definitions, you can use the SAS® Customer Intelligence 6.x Integration Utilities. These utilities are typically located on your Compute Tier at the following location: <SASHome>\SASMarketingAutomationIntegrationUtilities\6.x
1) In my example I would like to extract the export definition with name “FiServ - Export to SMS” stored in folder “Definitions\Export Definitions”
2) As a first step you need to create a request xml file. In my example the request xml file would look like:
<?xml version="1.0"?>
<MAExtractRequest>
<ExportDefinitionDO detail="All">
<Folder operator="=">
<Name operator="=">Definitions\Export Definitions</Name>
</Folder>
<Name operator="=">FiServ - Export to SMS</Name>
</ExportDefinitionDO>
</MAExtractRequest>
Saved as “export_definitions_extract.xml”.
Note: Requesting an export definition with detail set to "ALL" and removing the tag
<Name operator="=">FiServ - Export to SMS</Name>
will result in one or more complete definitions being extracted.
3) The command line to extract the definition would look like:
<SASHome>\SASMarketingAutomationIntegrationUtilities\6.x
sasmaextract.exe sasdemo password DefaultAuth "Business Context Name" export_definitions_extract.xml out_export_definition.xml
4) The output file “out_export_definition.xml” does contain the tags for <FieldName>:
<FieldName>Individual ID</FieldName>
<FieldName>trackingCode</FieldName>
<FieldName>First Name</FieldName>
<FieldName>Surname</FieldName>
<FieldName>Mobile Number</FieldName>
<FieldName>Age</FieldName>
<FieldName>Gender</FieldName>
<FieldName>Income</FieldName>
<FieldName>Marital Status</FieldName>
<FieldName>Challenger</FieldName>
Which correspond to the data items selected in your export definition:
Note: Modified field names in the “Selected:” Field section are not extracted.
If you need more information have a look at the “SAS® Customer Intelligence 6.x Integration Utilities User’s Guide” located at: http://support.sas.com/documentation/solutions/ci/6.5/en/PDF/ciintutilug.pdf where 6.x should be modified with the version you are using.
