topic Re: QDC and SAS Data Integration in Catalog and Lineage

QDC and SAS Data Integration

flavio_fazzano — Tue, 07 Dec 2021 22:35:04 GMT

My customer uses SAS Data Integration to replicate data from their data sources to a Data Warehouse (which is the source of QDC); is it possible to integrate QDC with SAS Data Integration to have the complete lineage from the source?

Re: QDC and SAS Data Integration

Clever_Anjos — Fri, 28 Aug 2020 13:10:02 GMT

Flavio

Catalog provides an API that leverage the ability to include lineage information

Re: QDC and SAS Data Integration

JitenderR — Mon, 31 Aug 2020 20:26:50 GMT

Hi @flavio_fazzano Do you mean use SAS ETL to load data into the database on which Qlik Catalog is creating the catalog? QDC cannot plug into SAS, as it's an ETL tool, but you can use below two methods to create the lineage. Note that you will NOT be able to create the lineage for SAS objects as it's external to QDC. Example - if you want to know what all tables a specific database table (that is cataloged in QDC) read, what all aggregations were performed etc, this cannot be done in QDC.

1) use metadata (say put SAS object name, etc under description) and bulk upload in QDC.

2) in the lineage diagram, add icons/images that will show that the database table was loaded using a SAS object. Below screenshot gives list of lineage controller API's. you can see the first and 6th in the list giving you ability to create Edges and Nodes that are external to QDC.

Let me know for any additional questions.

Regards

Re: QDC and SAS Data Integration

flavio_fazzano — Fri, 04 Sep 2020 22:04:47 GMT

Thanks JR !!!