V10.0
Module
Description
Sets the database connection string for all the Cora Orchestration applications, a specific instance of a specific application, or all instances of a specific application.
Syntax
Set-CoraSeQuenceConnectionStringPostgres -Server <String> -Port <Int32> -Database <String> [-EncryptedCredentials <String>] [-Properties <Hashtable>] -ApplicationType <String> [-ApplicationID <Int32>] [-AllInstances] [<CommonParameters>]
Set-CoraSeQuenceConnectionStringPostgres -Server <String> -Port <Int32> -Database <String> [-EncryptedCredentials <String>] [-Properties <Hashtable>] [<CommonParameters>]
Parameters
-Server <String>
The name of the server. Standard format, including instance name.
| Required? | true |
| Position? | named |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Port <Int32>
The name of the port. Standard format, if not default.
| Required? | true |
| Position? | named |
| Default value | 5432 |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Database <String>
The name of the Cora SeQuence database.
| Required? | true |
| Position? | named |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-EncryptedCredentials <String>
The Cora SeQuence-encrypted credentials (username and password). Use the Cora SeQuence Toolkit to encrypt, if needed. If not provided, connectionstring will be set with Integrated Security=SSPI.
| Required? | false |
| Position? | named |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Properties <Hashtable>
Hashtable of properties to add to the default connectionstring. Existing keys in the default connectionstring will be overwritten.
| Required? | false |
| Position? | named |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-ApplicationType <String>
Sets the connection string to a specific type of application.
| Required? | true |
| Position? | named |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-ApplicationID <Int32>
Sets the numeric ID for a specific instance of the application type to set. Ignored if AllInstances is used.
| Required? | false |
| Position? | named |
| Default value | 1 |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-AllInstances [<SwitchParameter>]
Sets the connection string to all instances of the specified application.
| Required? | false |
| Position? | named |
| Default value | False |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
<CommonParameters>
This command supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable.
For more information, see about_CommonParameters.
Example
Set-CoraSeQuenceConnectionStringPostgres -Server "PostgresServer" -Port Port -Database "Sequence" -EncryptedCredentials "dOtg/dWG6Q1TJDAvqHLX6SkR33ArkTNyMEYXCBgOjU0RCQnHmN5ZNwfKciBh6dXKChuYGO8X4Y5nUAoHQ3S3tw=
