Unsupported content

 

This version of the product is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

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
Attribute Name and Type

Description

Result Description
label string

A textual summary of the request made

Hash
hash _string

A hash that uniquely identifies this request

Discovery duration
discovery_duration int

The length of time that the request took.

Request time
request_time date

When this request was made.

Failure reason
failure_reason date

If the request failed, this will have a textual explanation of why it failed.

Hard failure
hard_failure boolean

True if the result is classed as a hard failure.

Cancelled
cancelled boolean

True if command was cancelled.

Provider
provider string

The name of the provider that handled this request to an integration.

Connection Parameters
connection_xxx Any type

The value of a given connection parameter passed from the pattern.

Query Parameters
query_xxx Any type

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:
ConnectionUsage:
IntegrationConnection:
SQLIntegrationConnection

The connection that was used to produce this result

SQLIntegrationQuery

IntegrationResult:
QueryUsage:
IntegrationQuery:
SQLIntegrationQuery

The static query that was used to produce this result

Pattern

DiscoveryResult:
Request:
Pattern:
Pattern

The pattern that triggered this result

IntegrationAccess

DiscoveryResult:
DiscoveryAccessResult:
DiscoveryAccess:
IntegrationAccess

The integration access that produced this result

DiscoveryAccess

DiscoveryResult:
DiscoveryAccessResult:
DiscoveryAccess:
DiscoveryAccess

The discovery access that produced this result

SQLResultRow

List:
List:
Member:
SQLResultRow

Associated SQL results

SessionResult

DiscoveryResult:
Metadata:
Detail:
SessionResult

Session details

Was this page helpful? Yes No Submitting... Thank you

Comments