Connections
Connections are used to connect to external data sources. You can create, delete, and browse connections using the API.
- Connection must be attached to applications to be used.
- First connection in the list is the default connection for the application.
Browse connections
app_administrator
Connection details with all objects and definitions
sys_query_{connectionName}
HTTP | |
---|---|
Connection status
sys_query_{connectionName}
Status of the connection and response time.
HTTP | |
---|---|
Connection delete
app_administrator
HTTP | |
---|---|
Connection create
app_administrator
v2228
Notes:
Connect Timeout
is a connect timeout in seconds.Command Timeout
is a query timeout in seconds (default 60s)Encrypt=True
must be specify explicitly, if not provided connection will not be encryptedEncrypted=False
will be added to the connection string.
HTTP | |
---|---|
Connections strings examples
Examples
Standard Connection to SQL Server / Azure SQL / Amazon RDS:
Text Only | |
---|---|
Trusted Connection:
Text Only | |
---|---|
Instance Connection:
Text Only | |
---|---|