Audit Artifact Dependencies

Follow

BJ Erickson

• July 28, 2016 16:14

I'd like an output of all artifacts and their dependencies.

 

I know you can do this by selecting the "Toggle Dependencies" button artifact by artifact and get the breadcrumb trail.  But we have too many artifact to do them manually.  I'd like an export (csv, xlsx...)  

Best case, some sql hitting the repository, returning the artifact breadcrumb trail, where I can limit it by OWNER in the sql.

0

• 

  Gido

  • July 28, 2016 19:32

  The feature you are looking for is available via REST API call Workbook Dependencies, which is part of an add on package Advanced Governance. 

  After installing the REST API Dependencies add-on, you can download the hierarchy of up- and downstream dependencies for a given workbook in JSON format.

  0

  Comment actions Permalink
• 

  Joel Stewart

  • July 28, 2016 23:14

  Hi BJ, the most accessible method for this is through the Toggle Dependencies button as you have highlighted. 

  Within the database, only the immediate "parent" of the existing artifact is stored. Building the full chain of dependencies through a single query is cumbersome since SQL is not well suited for recursion. Furthermore, the dependencies in the metadata are stored differently for different connection types (i.e. workbook-to-workbook or import-to-workbook).

  How long are the dependencies in your environment? I'd be glad to share this feedback with our product team directly to request a product enhancement on your behalf.

  0

  Comment actions Permalink

Please sign in to leave a comment.