How to link multiple data source to a single widget in a cockpit

Question

I have to build a cockpit with data from multiple data sources, so I need to build a dataset with data coming from multiple sources (different databases). Is there a Way I can integrate and query them as a 'single' data set (without making a new data structure)?

Answer 1

Hi Davide,

no, the only way is to create a federated dataset, which means you create different datasets (each one based on its data source) and "join" them on a column (or more columns). Then you can create your cockpit taking data from your federated dataset.

Federated datasets are available only in knowage EE.

Regards,

Nunzia

Answer 2

You can create a specific database "datawarehouse" for this (this is one of the original roles of a datawarehouse to federate datas in one central place). You will need to regulary fill this datawarehouse from your various databases with an ETL (like Talend) and then use this datawarehouse database as the dataset source.

If if it's a one time thing, it maybe simpler to export your original data to CSV or XLS files and merge them to only one file. Then use this file as a dataset.