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}