Remove-NAVTableConnection
Removes a connection to an external database table from the Business Central application.
Syntax
Remove-NAVTableConnection
[-ServerInstance] <String>
-ConnectionType <TableConnectionType>
-ConnectionId <String>
[-Force]
[-ProgressAction <ActionPreference>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Remove-NAVTableConnection
[-ApplicationDatabaseServer <String>]
-ApplicationDatabaseName <String>
[-ApplicationDatabaseCredentials <PSCredential>]
-ConnectionType <TableConnectionType>
-ConnectionId <String>
[-Force]
[-ProgressAction <ActionPreference>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
Use the Remove-NAVTableConnection cmdlet to remove an external table connection from the application/service. You can connect to a Business Central database by specifying the Business Central Server instance or the application database.
Examples
EXAMPLE 1
Remove-NAVTableConnection -ServerInstance BC -ConnectionType CRM
-ConnectionId myCRM
This example removes a connection to a Dynamics 365 for Sales table from a Business Central Server instance.
Parameters
-ApplicationDatabaseCredentials
Specifies the user name and password of an SQL Server Authentication login account that provides access to the Business Central application database in SQL Server.
You use this parameter to access the database by using SQL Server Authentication. If you want to use Windows Authentication, then you can omit this parameter The login account must be a member of the db_owner role on the database.
Type: | PSCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ApplicationDatabaseName
Specifies the name of the Business Central database that contains the application tables in a multitenant deployment.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ApplicationDatabaseServer
Specifies the name of the computer on which the SQL Server instance for the Business Central database that contains the application tables is installed in the multitenant deployment.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Confirm
Prompts you for confirmation before executing the command.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ConnectionId
Specifies the name of the table connection.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ConnectionType
Specifies the type of table connection. In Business Central , you can specify two types of connection: CRM or ExternalSQL.
Type: | TableConnectionType |
Accepted values: | ExternalSQL, CRM |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Force
Forces the command to run without asking for user confirmation.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ProgressAction
A common PowerShell parameter that determines how PowerShell responds to progress updates generated by a script, cmdlet, or provider. Learn more.
Type: | ActionPreference |
Aliases: | proga |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerInstance
Specifies the name of a Business Central Server instance, for example, BC or myinstance. You can specify either the full name of an instance, such as MicrosoftDynamicsNavServer$myinstance or the short name such as myinstance.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-WhatIf
Describes what would happen if you executed the command without actually executing the command.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |