Retrieves settings for the Data Connections. Without a -Filter, QOps-PrepareDataConnections uses the filter saved in the repository. If none is saved either, it touches nothing and says so, rather than reporting success having done nothing — write commands do not act on everything by default. Pass -Filter * if that is what you want. The Data Connection selection could be done by adding one or several comma-separated Names in the -Filter parameter. Note, that QOps-SetFilter setting doesn't affect this command.
Works against a Qlik Sense site and a Qlik Cloud tenant. Against a Qlik Cloud tenant, the connection each space carries for its own data files is left out — Qlik owns that one, QOps-BuildDataConnections cannot recreate it, and a repository holding one per space says nothing you can act on. The run reports how many it left out.
Where the account cannot read a particular connection, the run carries on through the others: that one is named with the reason the server gave and comes back as Failed beside the ones that succeeded. This holds on Qlik Cloud and on Qlik Sense.
Syntax:
QOps-PrepareDataConnections [-Filter] [-Sort] [-Profile] [-Verbose]
Parameters meaning:
-Filter specifies parameters for selecting Data Connections to process with QOps, allows filtering by following:
- Name
- Id
The multiple masks are supported in a way of repeating the field identifier group with a semicolon and with a comma separator inside a group, ex.: -Filter "Name=*ibcs*;Name=*api*,Id=*".
The Semicolon defines result joining with OR logic, the Comma defines results joining with AND logic. When the field name is omitted all possible values for this field will be applied.
-Sort specifies parameters for sorting Data Connections to process with QOps, ex. -Sort "Name=Asc". Allows filtering by following:
- Name
- Id
-Profile overrides default User Profile with the specified one
-Verbose enables extended command line output
Example:
QOps-PrepareDataConnections
QOps-PrepareDataConnections -Filter "Name=DataConnection1"
QOps-PrepareDataConnections -Filter "NameDataConnection1,Name=DataConnection2"
This command is not available in QlikView mode
-VerboseLog enables full verbose output including complete API response dumps and debug information. By default, QOps now produces concise output summaries.