Skip to main content
Matrix42 Self-Service Help Center

Sonar Clarity Integration attribute mapping

  1. Last updated
  2. Save as PDF

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  
  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Article type
    Topic
  2. Tags
    This page has no tags.