Raised on behalf of a customer:
We have SQL servers with installed DQC Feature (Data Quality Client) that we wont be able to enable under Pupppet SQL module :
Example : "SQL_2014" : [ "Conn", "SDK", "BC", "ADV_SSMS", "SSMS", "DQC", "BOL", "IS" ],
==> In last version of sqlserver module (Ref 2.3.0) supported features are still without DQC:
Specifies one or more features to manage. Valid options: 'BC', 'Conn', 'SSMS', 'ADV_SSMS', 'SDK', 'IS', 'MDS', 'BOL', 'DREPLAY_CTLR', 'DREPLAY_CLT'.
==> This makes module to throw error for those SQL servers stating "Invalid value "DQC"". Module supports the instance DQ service, but not the DQC feature (the Client) which is strange.
"Failed to apply catalog: Parameter features failed on Sqlserver_features[Generic Features]: Invalid value "DQC". Valid values are Tools, BC, Conn, SSMS, ADV_SSMS, SDK, IS, MDS, BOL, DREPLAY_CTLR, DREPLAY_CLT. (file: /etc/puppetlabs/code/environments/NonProdNOOP/site/profile/manifests/new_sqlserver.pp, line: 155) "
Please add support for DQC feature in future version of Sqlserver module.