Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY

QLIK CATALOG - Publish Registered Entities to Qlik Sense Using Business Name

franco_galati
Partner
Partner

QLIK CATALOG - Publish Registered Entities to Qlik Sense Using Business Name

Qlik Catalog has a nice resource that is publish data directly to Qlik Sense. While Qlik Sense uses associative engine, is necessary change column names to allow end users or BI analysts link tables (associate) through associative model. A best solution is Catalog, because a Business Name is available to rename columns before delivery it to Sense. That means a Data Administrator can change columns name in Qlik Catalog, allowing Qlik Sense get data automatically linked by new column names (id to id). Further more, field names not intuitive can be changed to both elegant and intuitive names. All this is very nice in Qlik Catalog! 

But, life is not perfect. 😞 

Catalog has two different ways to delivery Data direct to analytics tools like Qlik Sense. First one is Catalog reading all data sources and storing tables in a new destination, what Catalog calls MANAGED ENTITIES. For this entities Business Name (I mean, change names of columns in Qlik Catalog before delivery it to Sense) works perfectly. However, tables can be set as Registered, that means Qlik Catalog will NOT load data into other repository, but will inform Qlik Sense to get data direct from data source. In this case, Catalog will NOT change column names, although Business Name option exists for Registered entities. 

I'd like suggest Catalog uses Business Name in Source Module (also called EXTERNAL) adding alias (AS) in SELECT statements when reading tables or files in Registered mode. It's a very usefully feature in Managed tables that should exists in Registered as well. 

franco_galati_0-1637184631265.png

@fernando_tonial 

7 Comments
sabrinaabreutoc
Partner
Partner

Excellent suggestion! Very interesting!

robertonovelloi
Partner
Partner

Nice 

cyro_duarte_toc
Partner
Partner

Nice!

PabloLabbeImaps
Partner
Partner

Totally agree !

fernando_tonial
Partner
Partner

I totally agree!!

BrunoBerger
Contributor
Contributor

It would be a good deal for sure.

Renato_
Partner
Partner

Excellent suggestion, I totallu agree.