Enrich Software Information

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.1 > Connectors > Alphabetic Connector List > Raynet One Technology Catalog > Output Data 

Enrich Software Information

The Software table contains enriched details of software.

Table

Column

Type

Software

SoftwareId

ManufacturerId

Status

VersionId

ProductId

Name

Vendor

Version

Description

Architecture

Language

Website

ProductFamily

ReleaseDateStatus

ReleaseDateClaim

ReleaseDate

EndOfLifeDateStatus

EndOfLifeDateClaim

EndOfLifeDate

ExtendedSupportDateStatus

ExtendedSupportDateClaim

ExtendedSupportDate

Edition

ProductPlatform

Support

License

LatestReleaseDate

LatestVersion

Confidence

CommercialModel

VersionLastModificationDate

ProductLastModificationDate

GUID

GUID

String

GUID

GUID

String

String

String

Integer

String

String

String

String

String

String

Date

String

String

Date

String

String

Date

String

String

String

String

Date

String

Integer

String

DateTime

DateTime

 

The SoftwareUnspsc table contains UNSPSC classification data for software.

Table

Column

Type

SoftwareUnspsc

UnspscKey

Title

Definition

Type

String

String

String

String

 

The SoftwareUnspscMatching table defines the relationship between software and its corresponding UNSPSC classification keys.

Table

Column

Type

SoftwareUnspscMatching

UnspscKey

SoftwareId

String

String

 

The SoftwareFunction table defines the details of software functions.

Table

Column

Type

SoftwareFunction

FunctionId

Title

Description

GUID

String

String

 

The SoftwareFunctionMatching table defines the relationship between software and its assigned functions, indicating primary and secondary roles.

Table

Column

Type

SoftwareFunctionMatching

FunctionId

SoftwareId

IsMain

GUID

GUID

Boolean

 

The SoftwareTransformationMatching table defines the relationship between software summary entries and catalog software.

Table

Column

Type

SoftwareTransformationMatching

SoftwareSummaryId

CatalogSoftwareId

FingerPrintId

IgnoreReason

GUID

GUID

GUID

Integer

The SoftwareLicense table defines licensing details for software.

Table

Column

Type

SoftwareLicense

LicenseId

Title

Description

CatalogLicenseId

GUID

String

String

GUID

 

The SoftwareLicenseMatching table defines the relationship between software and their associated licenses.

Table

Column

Type

SoftwareLicenseMatching

LicenseId

SoftwareId

GUID

GUID

 

The SoftwareManufacturer table defines information about software manufacturers.

Table

Column

Type

SoftwareManufacturer

ManufacturerId

Name

HomePage

CatalogManufacturerId

LastModificationDate

GUID

String

String

GUID

DateTime

 

The SoftwareIgnoreReason table defines predefined reasons for ignoring specific software records during enrichment.

Table

Column

Type

SoftwareIgnoreReason

Id

Title

Integer

String