Architecting, installing and maintaining your SAS environment

Using the Releationship Postgres database to report lineage

Reply
Regular Learner
Posts: 1

Using the Releationship Postgres database to report lineage

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?

 

Trusted Advisor
Posts: 1,312

Re: Using the Releationship Postgres database to report lineage

[ Edited ]
Posted in reply to DavidGannon

Hello @DavidGannon,

 

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).

Senior User
Posts: 1

Re: Using the Releationship Postgres database to report lineage

Posted in reply to JuanS_OCS

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. 

Trusted Advisor
Posts: 1,312

Re: Using the Releationship Postgres database to report lineage

Posted in reply to kellington

Indeed.

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. 

 

http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p14w0edwch53wdn1fior...

Ask a Question
Discussion stats
  • 3 replies
  • 149 views
  • 0 likes
  • 3 in conversation