QDC and SAS Data Integration

[flavio_fazzano]

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?

[Clever_Anjos]

Flavio

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

[JitenderR · Accepted solution]

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

JR 

[flavio_fazzano]

Thanks JR !!!