Setting SAS MDM Macros

Overview

SAS MDM jobs and services require certain values in the mdm_macros.cfg file on all clients and on the server. These values are automatically added during the SAS MDM installation. If you need to make changes to your mdm_macros.cfg file after the SAS MDM installation and configuration process, you can edit the mdm_macros.cfg file on your client computer using Data Management Studio. Some of the paths used as values for the keys in this file must be modified for UNIX.

After making changes to the mdm_macros.cfg file, follow these steps:

If you change macro values through the Data Management Studio interface, an mdm_macros.cfg file is also created in \Users\<Your_User_ID>\AppData\Roaming\<Studio Install Directory>\<version>\etc\macros. You must combine those values with the values in the mdm_macros.cfg file in\Program Files\<Studio Install Directory>\<version>\etc\macros without duplicating key names.
After making these changes, you must copy the combined file to the macros directory on Data Management Server. If your Data Management Server system runs on another platform, ensure that the path delimiters are appropriate for the platform.
If you run SAS MDM services on a Data Management Server as web services, you must ensure that Data Management Server has access to the mdm_macros.cfg file.

For more information about the configured macros and their use, see the mdm_macros.cfg file.

Database Values

The SAS MDM installation process updates database connection values in your SAS MDM macro files. If you need to modify these after the installation process is completed, the values that you use for your database must be reflected in the mdm_macros.cfg file or files for your installation. For Oracle, the schema name must be in uppercase letters.

SQL Server does not use packages for stored procedures, nor does it necessarily separate logon information from schemas. Modify the mdm_macros.cfg file or files with the following values:

MDM_HUB_DB=SQL SERVER
MDM_SCHEMA=mdm42
MDM_PACKAGE=

Macro Descriptions

The following table lists the macros for the mdm_macros.cfg file along with their default values and descriptions. When editing this file, do not set the macros MDM_CLUSTER_MEM, MDM_BRANCH_MEM, MDM_SORT_MEM, and MDM_SURVIVE_MEM to values lower than 4 MB or 4,194,304 bytes. In some cases, doing so can cause the various processes to stop and return memory-related errors.

Here are the macro default values and descriptions:

MDM Macros
Macro with Default	Description
MDM_DEF_TIMESTAMP_FORMAT MM/DD/YYYY hh:mm:ss	Default timestamp format for the SAS MDM repository.
MDM_DEF_DATE_FORMAT MM/DD/YYYY	Default date format for the SAS MDM repository.
MDM_BRANCH_MEM 4194304	Branch memory limit.
MDM_SORT_MEM 16777216	Sort memory limit.
MDM_CLUSTER_MEM 16777216	Cluster memory limit.
MDM_SURVIVE_MEM 16	Survivorship memory limit (MB).
MDM_MAX_ROWS 0	File input limit (primarily bulk jobs). This macro is deprecated.
MDM_SORT_THREADS 8	Sort thread limit.
MDM_MAX_CLUSTERS 1000	Maximum number of entries returned by entity search.
MDM_MAX_CLUSTER_RECORDS 1000	Maximum number of entries returned by cluster search.
MDM_QKB	The fully qualified path to the QKB.
MDM_ARCHIVE C:\ProgramData\SAS\DataManagement\FileStorage\SASMDM\archive\	Output path from the archival job.
MDM_DATA C:\ProgramData\SAS\DataManagement\FileStorage\SASMDM\data\	Output path for bulk jobs.
MDM_LOGS C:\ProgramData\SAS\DataManagement\FileStorage\SASMDM\logs\	Output path for log files.
MDM_SCRIPTS C:\ProgramData\SAS\DataManagement\FileStorage\SASMDM\scripts\	Path to the scripts and metadata directory.
MDM_SAMPLE_DATA C:\ProgramData\SAS\DataManagement\FileStorage\SASMDM\samples\data\	The sample data directory.
MDM_SAMPLE_SCRIPTS C:\ProgramData\SAS\DataManagement\FileStorage\SASMDM\samples\scripts\	The sample scripts directory.
MDM_HUB_DB ORACLE	The database type: ORACLE or SQL SERVER.
MDM_DSN DSN=SASMDM	The name of the DSN for the SAS MDM repository.
MDM_SCHEMA MDM	The schema to use within the SAS MDM repository. This value should be all uppercase for Oracle.
MDM_PACKAGE MD.	The package for the stored procedure. Leave this blank for SQL Server.
MDM_OS_DELIMITER ;	OS-specific delimiter. Use `;` for Windows and `:` for UNIX platforms.
MDM_REMEDIATION_LIBS C:\Program Files\SASHome\DataFluxDataManagementStudio\2.7\lib\mdm\	The location of the data remediation Java application.

The following table lists the macro for the mdm_remediation_macros.cfg file along with its default value and description

Remediation Macros
Macro with Default	Description
MDM_REMEDIATION_URL http://localhost:80/SASDataRemediation/rest/groups	The location of the SAS Data Remediation REST web service application.

Last updated: April 19, 2017