To add to Patrick's great answer, also be aware that the supported data sources vary depending on the platform Cognos Analytics is being used on. For example, the on-demand Cloud version has a small subset of supported data sources compared with the on-prem version. The hosted on-cloud version and Cloud Pak for Data cartridge version support only the Dynamic Query sources.
Cheers!
MF.
------------------------------
Mark Fry
Retired Field Solutions Architect
------------------------------