Raynet Integration Attribute Mapping
Table of Contents
Matching Keys
- Matching key for SaaS application: SCIApplicationClass.SourceID (source attributes 'application_id', 'id')
- Matching key for application class usages: SCIApplicationClassUsages.UsageDate, SCIApplicationClassUsages.User (source attributes 'usage_date', 'user_id')
- Matching key for assigned SaaS subscription: SCIUserClassAssignedLicenses.SaaSLicense (source attribute 'subscription_id')
- Matching key for SaaS user: SCIUserClass.SourceID (source attribute 'user_id', 'id')
- Matching key for Saas subscription: SCILicenseClass.SourceID (source attribute 'id')
Attribute Mapping
| Import Job | Source Attribute/Transformation | Target Data Definition | Target Attribute | Relation Match Attribute |
|---|---|---|---|---|
| Raynet: Import Assigned SaaS Subscriptions to Users | (Date and time of data provider execution) | SCIUserClassAssignedLicenses | SyncDate | |
| Raynet: Import Assigned SaaS Subscriptions to Users | subscription_id | SCIUserClassAssignedLicenses | SaaSLicense | SourceID |
| Raynet: Import Assigned SaaS Subscriptions to Users | user_id | SCIUserClass | SourceID | |
| Raynet: Import SaaS Application Usage | (Date and time of data provider execution) | SCIApplicationClassUsages | SyncDate | |
| Raynet: Import SaaS Application Usage | application_id | SCIApplicationClass | SourceID | |
| Raynet: Import SaaS Application Usage | sources | SCIApplicationClassUsages | Sources | |
| Raynet: Import SaaS Application Usage | usage_date | SCIApplicationClassUsages | UsageDate | |
| Raynet: Import SaaS Application Usage | user_id | SCIApplicationClassUsages | User | SourceID |
| Raynet: Import SaaS Applications [Insert Only] | (Date and time of data provider execution) | SCIApplicationClass | Discovered | |
| Raynet: Import SaaS Applications [Insert Only] | "231" (Fixed Value) | SPSCommonClassBase | State | Value |
| Raynet: Import SaaS Applications [Insert Only] | (Organizational Unit defined in Data Provider Configuration) | SPSCommonClassBase | OU | Production.ID |
| Raynet: Import SaaS Applications [Insert Only] | id | SCIApplicationClass | SourceID | |
| Raynet: Import SaaS Applications [Insert Only] | name | SCIApplicationClass | Name | |
| Raynet: Import SaaS Applications [Update Only] | (Date and time of data provider execution) | SCIApplicationClass | SyncDate | |
| Raynet: Import SaaS Applications [Update Only] | "Raynet" (Fixed Value) | SCIApplicationClass | SourceTool | |
| Raynet: Import SaaS Applications [Update Only] | category | SCIApplicationClass | Category | |
| Raynet: Import SaaS Applications [Update Only] | id | SCIApplicationClass | SourceID | |
| Raynet: Import SaaS Applications [Update Only] | name | SCIApplicationClass | Name | |
| Raynet: Import SaaS Applications [Update Only] | sub_category | SCIApplicationClass | SubCategory | |
| Raynet: Import SaaS Subscriptions [Insert Only] | (Organizational Unit defined in Data Provider Configuration) | SPSCommonClassBase | OU | ProductionID |
| Raynet: Import SaaS Subscriptions [Insert Only] | "0" (Fixed Value) | SCILicenseClass | ContractAutoRenewal | |
| Raynet: Import SaaS Subscriptions [Insert Only] | id | SCILicenseClass | SourceID | |
| Raynet: Import SaaS Subscriptions [Insert Only] | name | SCILicenseClass | ContractName | |
| Raynet: Import SaaS Subscriptions [Update Only] | annual_seat_cost | SCILicenseClass | YearlyCostPerSeat | |
| Raynet: Import SaaS Subscriptions [Update Only] | application_id | SCILicenseClass | Application | SourceID |
| Raynet: Import SaaS Subscriptions [Update Only] | auto_renewal | SCILicenseClass | ContractAutoRenewal | |
| Raynet: Import SaaS Subscriptions [Update Only] | currency | SCILicenseClass | YearlyCostPerSeat_CC | |
| Raynet: Import SaaS Subscriptions [Update Only] | id | SCILicenseClass | SourceID | |
| Raynet: Import SaaS Subscriptions [Update Only] | name | SCILicenseClass | ContractName | |
| Raynet: Import SaaS Subscriptions [Update Only] | renewal_date | SCILicenseClass | ContractRenewalDate | |
| Raynet: Import SaaS Subscriptions [Update Only] | seats | SCILicenseClass | Seats | |
| Raynet: Import SaaS Users | (Date and time of data provider execution) | SCIUserClass | SyncDate | |
| Raynet: Import SaaS Users | emails | SCIUserClass | Emails | |
| Raynet: Import SaaS Users | id | SCIUserClass | SourceID | |
| Raynet: Import SaaS Users | name | SCIUserClass | Name |