Connection
| Field | NULL | Description | Note |
|---|---|---|---|
| id string (GUID) | The id of the connection | ||
| name string | The name of the connection | ||
| originalName string | The original name of the connection | ||
| serverTypeId string (GUID) | The id of the server type | ||
| databaseServer string | The database address | ||
| databaseUser string | The database username (encrypted) | New in version 3.10.0. | |
| serverTypeName string | The type of the server | ||
| connectionString string | The connection string | ||
| visible boolean | Whether this is visible in Data Model | ||
| deleted boolean | Whether this is deleted | ||
| relateToConnectionId string (GUID) | Y | The id of the related connection | |
| tenantId string (GUID) | Y | The id of the tenant if available | |
| dBSource object | A DBSource object | ||
| relationships array of objects | An array of Relationship objects | ||
| physicalChange integer | The change status | ||
| copyDataConnector boolean | Is selected for copy in Copy Management (only data connector mode) | New in version 3.9.3. | |
| checked boolean | Is selected for copy in Copy Management | ||
| databaseName string | The name of the database |
Sample:
{"id":"89e91284-6546-44d0-8de0-f8f666a590ea","name":"Northwind","serverTypeId":"d968e96f-91dc-414d-9fd8-aef2926c9a18","serverTypeName":"AZSQL","connectionString":"1aBRE29O143H1SyQGNMkU3I3CNyM+gqaxFEuOSKGzd0U0cD+==","checked":false,"copyDataConnector":false,"databaseName":"Northwind","databaseServer":"localhost","databaseUser":"8oX0eYKrA7PlcqOIYA==","dbSource":{},"deleted":false,"originalName":null,"physicalChange":0,"querySourceCategories":[],"relateToConnectionId":null,"relationships":null,"tenantId":null,"visible":false}