Several web services have been defined to provide additional functionality outside of the user interface. These somewhat-hidden services must be called directly, using a web browser. The URL is made up of several components:
SERVERURL-> the domain (and port) on which your SAS server resides
SASStoredProcessfor SAS 9, else
APPLOC-> The root folder location in which the Data Controller backend services were deployed
SERVICE-> The actual Data Controller service being described. May include additional parameters.
To illustrate the above, consider the following URL:
This is broken down into:
The below sections will only describe the
$SERVICE component - you may construct this into a URL as follows:
This service will provide a zip file containing the current database configuration. This is useful for migrating to a different data controller database instance.
Exports the data controller control library in DB specific DDL. The following URL parameters may be added:
&flavour=(only PGSQL supported at this time)
&schema=(optional, if target schema is needed)
Refreshes the Data Controller data catalog. The model is stored in SCD2 so it's a great way to track changes over time! The process can take a long time if you have a lot of tables - if a library crashes, you can exclude it from the refresh process by adding pipe-separated LIBREFs to the DCXXXX.MPE_CONFIG table (var_scope='DC_CATALOG', var_name='DC_IGNORELIBS').
The following params can be added:
&libref(optional) to run the process for just one library.