07-14-2017 12:19 PM
We are looking for advice on using the relationship data that is stored in the postgres database.
This information is populated via the Relationship Loader (sas-relationship-loader). We have used the Relationship Reporter (sas-relationship-reporter) successfully.
We have some specific reports we would like to develop that accessing the Postgres database would facilitate.
Has anyone used this metadata database? How did you connect to it? And are there example queries available?
07-16-2017 07:01 AM - edited 07-16-2017 07:02 AM
what you are asking for - to access the WIP database to query the relationships, I believe it is not documented. For this purpose, I would rather ask the question to SAS Technical Support 9 (and/or wait here, perhaps a SAS employee can asnwer you the question). But please beware the SAS WIP database it is not intended to be queried for non-internal-SAS purposes, so also perhaps you won't get your answer. If you get this question answered, please let us know it, we feel curious!
I think it would be more interesting for you to use sas-relationship-reporter by exporting the data to a CSV file and create your own little datamart. (with the parameter -format CSV )
Something else it might help you: if you have SAS Visual Analytics, there is a process you can enable to get the reports out of the box: http://blogs.sas.com/content/sgf/2015/03/04/relationships-are-easy-for-sas-objects/ (and a SAS dataset that will be loaded into VA, and you can copy to a different location for your own purposes).
07-17-2017 09:51 AM
The challenge with the sas-relationship-reporter is that it does not have all the same exports available - without having to run "lots" of different exports/queries and then parsing and stitching the info back together. The goal is to be able to have queries that simplify impact lineage reporting (initial sources and final targets - without all the intermediary steps), as well as do quality/standards reporting on tables and jobs that are being built in SAS DI.
The PostgreSQL tables *should* make this easier.
07-17-2017 09:55 AM
FYI, if it takes too long to get the answer you need, you can always create the relationship tables by yourself with the BI Lineage plugin from the SAS Management Console.