write_connections
Manage data source and destination connections for CData Sync by creating, updating, or deleting configurations. Define how to access databases, APIs, and files with provider-specific connection strings.
Instructions
Create, update, or delete data connections. If not authenticated with CData Sync, you will be prompted for credentials. Connections define how to access your data sources (databases, APIs, files) and destinations. Connection strings are provider-specific - consult CData documentation for your provider. Cannot modify or delete connections currently in use by running jobs. To change providers, delete and recreate the connection.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Operation to perform. Create new connections, update existing (connection string only), or delete unused connections | |
| name | Yes | Connection name. Use descriptive names like 'Prod_Salesforce' or 'Dev_MySQL'. Case-sensitive. | |
| providerName | No | ADO.NET provider for 'create' (e.g., 'CData Salesforce', 'System.Data.SqlClient'). Cannot be changed after creation. | |
| connectionString | No | Provider-specific connection parameters. Format varies by provider. May contain credentials - handle securely. | |
| verbosity | No | Default log level for this connection: 1=Error, 2=Info (default), 3=Transfer, 4=Verbose | |
| workspaceId | No | Workspace ID to use for this operation. Overrides the default workspace. Use 'default' for the default workspace or a UUID for specific workspaces. |