Architecting, installing and maintaining your SAS environment

Handling the SAS 9.2 Backup and Restore Transformation in DI Studio

Reply
Occasional Contributor
Posts: 17

Handling the SAS 9.2 Backup and Restore Transformation in DI Studio

Hi,

Creating a backup/restore job in Man console of v9.2 creates two or more sas jobs.

  1. Backup jobs (*_B)
  2. Restore jobs (*_R)

These jobs run %omabackup in a nice way however there are a number of other tasks that should be performed in conjunction.;

  • Service definition copies
  • Database backups
  • custom code backups etc.

I would like to create a DI job "Metachain" that includes the generated backup job or alternatively, modify the job itself in DI.

The backup job cannot be opened in DI because the transformation for the backup/restore is not a defined transform in metadata.  My questions are;

  1. Can the transformation(s) be defined in DI?
  2. If so, how?
  3. If not, what is everyone else doing for this housekeeping task?  Custom coding?

Thanks in advance

Cameron

Ask a Question
Discussion stats
  • 0 replies
  • 235 views
  • 0 likes
  • 1 in conversation