Integration Result node
An Integration Result node is a record of the result of running SQL queries against a remote database. It does not contain the actual data returned by the queries, this is stored in the related SQL Result Row nodes.
An Integration Result node is related to either the Provider Access node for the endpoint at which the database resides, in the case of database integration, or the Discovery Access node used for the discovery of that database instance, in the case of database discovery.
Integration Result Lifecycle
The following section describes the scenarios in which an Integration Result is created,updated or destroyed.
Creation
An Integration Result node is created whenever a pattern makes a new request to a SQL database.
Update
Integration Result nodes are never updated.
Removal
Integration Results are removed when the related Provider Access node or Discovery Access node is destroyed.
Integration Result node attributes
The attributes and relationships of an Integration Result node are described in the tables below.
UI Name |
Description |
---|---|
Result Description |
A textual summary of the request made |
Hash |
A hash that uniquely identifies this request |
Discovery duration |
The length of time that the request took. |
Request time |
When this request was made. |
Failure reason |
If the request failed, this will have a textual explanation of why it failed. |
Hard failure |
True if the result is classed as a hard failure. |
Cancelled |
True if command was cancelled. |
Provider |
The name of the provider that handled this request to an integration. |
Connection Parameters |
The value of a given connection parameter passed from the pattern. |
Query Parameters |
The value of a given query parameter passed from the pattern. |
Integration Result node relationships
The relationships of an Integration Result node are described in the following table.
Destination |
Relationship |
Description |
---|---|---|
SQLIntegrationConnection |
IntegrationResult: |
The connection that was used to produce this result |
SQLIntegrationQuery |
IntegrationResult: |
The static query that was used to produce this result |
Pattern |
DiscoveryResult: |
The pattern that triggered this result |
IntegrationAccess |
DiscoveryResult: |
The integration access that produced this result |
DiscoveryAccess |
DiscoveryResult: |
The discovery access that produced this result |
SQLResultRow |
List: |
Associated SQL results |
SessionResult |
DiscoveryResult: |
Session details |
Comments
Log in or register to comment.