ASEXPORT Procedure

Example: Exporting from a DataFlux Authentication Server to a SAS Metadata Server

Features:

PROC ASEXPORT statement

MATCH SINGLETON statement

MATCH statement

ADD statement

LIST statement

EXPORT statement

Details

This example demonstrates the following actions:
  • specify metadata values
  • create explicit singleton matches between these two domains
  • auto-match domains by name
  • add remaining unmatched domains
  • perform explicit user matching
  • auto-match users by FQLN
  • add remaining unmatched users
  • list everything for review
  • create an input file (per noforward) for PROC METADATA that we can review
Assign a file reference.The FILENAME statement assigns a libref to an external SAS library that contains a permanent SAS catalog.
filename asx 'C:\TableServer\asexport.xml';
Specify metadata values.
proc ASEXPORT meta=
              (
                 user='username' password='password'
                 server='localhost'
                 port=port_number
                 repos='repositoryID'
                 filter=(DOMAINS "*"
                         USERS   "*"
                         LOGINS  "Login[Domain/AuthenticationDomain
[@OutboundOnly='0']]")
              )
              as=
              (
                 server='localhost'
                 user='username'
                 pass='password'
                 port=port_number
                 filter=(DOMAINS "domain=(domain_names)"
                         USERS   "enabled=TRUE subject=(ADMUSER, 
Shared_Login_Manager, tsadm, 'USER%')"
                         LOGINS  "(login IDs for included domains)")
              )
              verbose
              tracefile='C:\TableServer\asexport.croc' traceloc=SQL 
traceflags='319'
              retain
              out=asx
              ;
   
Create explicit singleton matches between these two domains.
   match singleton DOMAIN / criteria="as.domains.name_n='LOCAL' and 
meta.domains.name_n='domain_name'" log;
   match singleton DOMAIN / criteria="as.domains.name_n='UNIX' and 
meta.domains.name_n='domain_name'" log;
Auto-match domains by name.
   match DOMAINS / log;
Add remaining unmatched domains.
   add DOMAINS / log;
Perform explicit user matching.Attempt at least one user that has a matching Login. Nothing should match.
   match singleton USER / criteria="as.users.name_n='SHARED_LOGIN_MANAGER' 
and meta.users.name_n='FEDERATION SERVER SHARED LOGIN MANAGER'" log;
   match singleton USER / criteria="as.users.name_n='USER1' and 
meta.users.name_n='TSADM'" log;
   match singleton USER / criteria="as.users.name_n='TSADM' and 
meta.users.name_n='TSADM'" log;
Auto-match users by FQLN.
   match USERS / log;
Add remaining unmatched users.
   add USERS / log;
List everything for review.
   list DOMAINS USERS;
Create an input file (per noforward) for proc METADATA that we can review.
   export / noforward noverbose;
End processing of PROC ASEXPORT.
quit;
Last updated: June 7, 2017