Sonar Clarity Integration attribute mapping
Table of Contents
Matching keys
- Matching key for SaaS applications: SCIApplicationClass.SourceID (source attribute 'id')
- Matching key for application expenses: SCIExpensesClass.SourceID (source attribute 'id')
- Matching key for application contract tags: SCIContractClass.SourceID (source attribute 'itemId')
- Matching key for application contracts: SCIContractClass.SourceID (source attribute 'id')
- Matching key for application expense tags: SCIExpensesClass.SourceID (source attribute 'itemId')
- Matching key for application license tags: SCILicenseClass.SourceID (source attribute 'itemId')
- Matching key for application licenses: SCILicenseClass.SourceID (source attribute 'id')
- Matching key for application tags: SCIApplicationClass.SourceID (source attribute 'id')
- Matching key for application usage: SCIUserClassApplicationUsage.Application, SCIUserClass.SourceID (source attributes 'id', 'userId')
- Matching key for applications: SCIApplicationClass.SourceID (source attribute 'id')
- Matching key for tags: SCITagClass.SourceID (source attribute 'id')
- Matching key for user tags: SCIUserClass.SourceID (source attribute 'itemId')
- Matching key for users: SCIUserClass.SourceID (source attribute 'id')
Attribute mapping
| Import Job | Source Attribute/Transformation | Target Data Definition | Target Attribute | Relation Match Attribute |
|---|---|---|---|---|
| SCI: Import Assigned SaaS Licenses to Users | (Date and time of data provider execution) | SCIUserClassAssignedLicenses | SyncDate | |
| SCI: Import Assigned SaaS Licenses to Users | id | SCIUserClassAssignedLicenses | SaaSLicense | SourceID |
| SCI: Import Assigned SaaS Licenses to Users | userId | SCIUserClass | SourceID | |
| SCI: Import SaaS Application Expenses | (Date and time of data provider execution) | SCIExpensesClass | SyncDate | |
| SCI: Import SaaS Application Expenses | amount | SCIExpensesClass | Amount | |
| SCI: Import SaaS Application Expenses | applicationId | SCIExpensesType | Application | SourceID |
| SCI: Import SaaS Application Expenses | currencyIsoCode | SCIExpensesClass | AmountCurrency | |
| SCI: Import SaaS Application Expenses | description | SCIExpensesClass | Description | |
| SCI: Import SaaS Application Expenses | id | SCIExpensesClass | SourceID | |
| SCI: Import SaaS Application Expenses | matchedBy | SCIExpensesClass | MatchedBy | |
| SCI: Import SaaS Application Expenses | sourceTransactionId | SCIExpensesClass | SourceTransactionId | |
| SCI: Import SaaS Application Expenses | Status | SCIExpensesClass | Status | |
| SCI: Import SaaS Application Contract Tags | id | SCIContractClass | Tags | SourceID |
| SCI: Import SaaS Application Contract Tags | itemId | SCIContractClass | SourceID | |
| SCI: Import SaaS Application Contracts | allLicenseActiveUsersCount | SCIContractType | AllLicenseActiveUsersCount | |
| SCI: Import SaaS Application Contracts | applicationId | SCIContractClass | Application | SourceID |
| SCI: Import SaaS Application Contracts | autoRenewal | SCIContractClass | AutoRenewal | |
| SCI: Import SaaS Application Contracts | currencyIsoCode | SCIContractClass | YearlyCost__CC | |
| SCI: Import SaaS Application Contracts | id | SCIContractClass | SourceID | |
| SCI: Import SaaS Application Contracts | name | SCIContractClass | Name | |
| SCI: Import SaaS Application Contracts | noticeDate | SCIContractClass | NoticeDate | |
| SCI: Import SaaS Application Contracts | paymentTerm | SCIContractClass | PaymentTerm | |
| SCI: Import SaaS Application Contracts | renewalDate | SCIContractClass | RenewalDate | |
| SCI: Import SaaS Application Contracts | status | SCIContractClass | Status | |
| SCI: Import SaaS Application Contracts | yearlyCost | SCIContractClass | YearlyCost | |
| SCI: Import SaaS Application Expense Tags | id | SCIExpensesClass | Tags | SourceID |
| SCI: Import SaaS Application Expense Tags | itemId | SCIExpensesClass | SourceID | |
| SCI: Import SaaS Application License Tags | id | SCILicenseClass | Tags | SourceID |
| SCI: Import SaaS Application License Tags | itemId | SCILicenseClass | SourceID | |
| SCI: Import SaaS Application Licenses [Insert Only] | (Organizational Unit defined in Data Provider Configuration) | SPSCommonClassBase | OU | Production.ID |
| SCI: Import SaaS Application Licenses [Insert Only] | contractAutoRenewal | SCILicenseClass | ContractAutoRenewal | |
| SCI: Import SaaS Application Licenses [Insert Only] | id | SCILicenseClass | SourceID | |
| SCI: Import SaaS Application Licenses [Insert Only] | name | SCILicenseClass | Name | |
| SCI: Import SaaS Application Licenses [Update Only] | (Date and time of data provider execution) | SCILicenseClass | SyncDate | |
| SCI: Import SaaS Application Licenses [Update Only] | applicationId | SCILicenseClass | Application | |
| SCI: Import SaaS Application Licenses [Update Only] | contractAutoRenewal | SCILicenseClass | ContractAutoRenewal | |
| SCI: Import SaaS Application Licenses [Update Only] | contractName | SCILicenseClass | ContractName | |
| SCI: Import SaaS Application Licenses [Update Only] | contractNoticeDate | SCILicenseClass | ContractNoticeDate | |
| SCI: Import SaaS Application Licenses [Update Only] | contractPaymentTerm | SCILicenseClass | ContractPaymentTerm | |
| SCI: Import SaaS Application Licenses [Update Only] | contractRenewalDate | SCILicenseClass | ContractRenewalDate | |
| SCI: Import SaaS Application Licenses [Update Only] | currencyIsoCode | SCILicenseClass | YearlyCostPerSeat__CC | |
| SCI: Import SaaS Application Licenses [Update Only] | currencyIsoCode | SCILicenseClass | EstimatedSaving__CC | |
| SCI: Import SaaS Application Licenses [Update Only] | estimatedSaving | SCILicenseClass | EstimatedSaving | |
| SCI: Import SaaS Application Licenses [Update Only] | id | SCILicenseClass | SourceID | |
| SCI: Import SaaS Application Licenses [Update Only] | name | SCILicenseClass | Name | |
| SCI: Import SaaS Application Licenses [Update Only] | seats | SCILicenseClass | Seats | |
| SCI: Import SaaS Application Licenses [Update Only] | userLicenseActiveCount | SCILicenseClass | UserLicenseActiveCount | |
| SCI: Import SaaS Application Licenses [Update Only] | userLicenseAssignedCount | SCILicenseClass | UserLicenseAssignedCount | |
| SCI: Import SaaS Application Licenses [Update Only] | userLicenseInactiveCount | SCILicenseClass | UserLicenseInactiveCount | |
| SCI: Import SaaS Application Licenses [Update Only] | userLicenseUnassignedCount | SCILicenseClass | UserLicenseUnassignedCount | |
| SCI: Import SaaS Application Licenses [Update Only] | yearlyCostPerSeat | SCILicenseClass | YearlyCostPerSeat | |
| SCI: Import SaaS Application Tags | id | SCIApplicationClass | Tags | SourceID |
| SCI: Import SaaS Application Tags | itemId | SCIApplicationClass | SourceID | |
| SCI: Import SaaS Application Usage | (Date and time of data provider execution) | SCIUserClassApplicationUsage | SyncDate | |
| SCI: Import SaaS Application Usage | id | SCIUserClassApplicationUsage | Application | SourceID |
| SCI: Import SaaS Application Usage | lastActivity | SCIUserClassApplicationUsage | LastActivity | |
| SCI: Import SaaS Application Usage | usage30d | SCIUserClassApplicationUsage | Usage30 | |
| SCI: Import SaaS Application Usage | usage90d | SCIUserClassApplicationUsage | Usage90 | |
| SCI: Import SaaS Application Usage | usageAllTime | SCIUserClassApplicationUsage | UsageAllTime | |
| SCI: Import SaaS Application Usage | userId | SCIUserClass | SourceID | |
| SCI: Import SaaS Applications [Insert Only] | (Date and time of data provider execution) | SCIApplicationClass | Discovered | |
| SCI: Import SaaS Applications [Insert Only] | "231" (Fixed Value) | SPSCommonClassBase | State | Value |
| SCI: Import SaaS Applications [Insert Only] | (Organizational Unit defined in Data Provider Configuration) | SPSCommonClassBase | OU | Production.ID |
| SCI: Import SaaS Applications [Insert Only] | id | SCIApplicationClass | SourceID | |
| SCI: Import SaaS Applications [Insert Only] | name | SCIApplicationClass | Name | |
| SCI: Import SaaS Applications [Update Only] | (Date and time of data provider execution) | SCIApplicationClass | SyncDate | |
| SCI: Import SaaS Applications [Update Only] | "Sonar Clarity" (Fixed Value) | SCIApplicationClass | SourceTool | |
| SCI: Import SaaS Applications [Update Only] | accountsDetected | SCIApplicationClass | AccountsDetected | |
| SCI: Import SaaS Applications [Update Only] | accountsUsed | SCIApplicationClass | AccountsUsed | |
| SCI: Import SaaS Applications [Update Only] | category | SCIApplicationClass | Category | |
| SCI: Import SaaS Applications [Update Only] | currencyIsoCode | SCIApplicationClass | YearlyCost__CC | |
| SCI: Import SaaS Applications [Update Only] | id | SCIApplicationClass | SourceID | |
| SCI: Import SaaS Applications [Update Only] | lastActivity | SCIApplicationClass | LastActivity | |
| SCI: Import SaaS Applications [Update Only] | name | SCIApplicationClass | Name | |
| SCI: Import SaaS Applications [Update Only] | status | SCIApplicationClass | Status | |
| SCI: Import SaaS Applications [Update Only] | subcategory | SCIApplicationClass | SubCategory | |
| SCI: Import SaaS Applications [Update Only] | yearlyCost | SCIApplicationClass | YearlyCost | |
| SCI: Import SaaS Tags | (Date and time of data provider execution) | SCITagClass | SyncDate | |
| SCI: Import SaaS Tags | appCount | SCITagClass | AppCount | |
| SCI: Import SaaS Tags | description | SCITagClass | Description | |
| SCI: Import SaaS Tags | firstLevelParentLabel | SCITagClass | FirstLevelParentLabel | |
| SCI: Import SaaS Tags | id | SCITagClass | SourceID | |
| SCI: Import SaaS Tags | label | SCITagClass | Label | |
| SCI: Import SaaS Tags | name | SCITagClass | Name | |
| SCI: Import SaaS Tags | parentId | SCITagClass | SourceParentId | |
| SCI: Import SaaS Tags | priority | SCITagClass | Priority | |
| SCI: Import SaaS Tags | status | SCITagClass | Status | |
| SCI: Import SaaS Tags | userCount | SCITagClass | UserCount | |
| SCI: Import SaaS User Tags | id | SCIUserClass | Tags | SourceID |
| SCI: Import SaaS User Tags | itemId | SCIUserClass | SourceID | |
| SCI: Import SaaS Users | (Date and time of data provider execution) | SCIUserClass | SyncDate | |
| SCI: Import SaaS Users | currencyIsoCode | SCIUserClass | YearlyCost__CC | |
| SCI: Import SaaS Users | emails | SCIUserClass | Emails | |
| SCI: Import SaaS Users | id | SCIUserClass | SourceID | |
| SCI: Import SaaS Users | lastActivity | SCIUserClass | LastActivity | |
| SCI: Import SaaS Users | name | SCIUserClass | Name | |
| SCI: Import SaaS Users | status | SCIUserClass | Status | |
| SCI: Import SaaS Users | vendorsDetected | SCIUserClass | VendorsDetected | |
| SCI: Import SaaS Users | vendorsUsed | SCIUserClass | VendorsUsed | |
| SCI: Import SaaS Users | yearlyCost | SCIUserClass | YearlyCost |