Data imports

Data imports enable you to import data into Flexera One SaaS Management that is not automatically captured by your other discovery sources. Once imported, this data is consolidated into indicators, charts, and tables on the Flexera One SaaS Management pages. You can use Data imports to:

  • Update multiple subscriptions in a single flow. You can update any of the standard, editable subscription fields in Flexera One SaaS Management.
  • Add user and user activity data for an application. You can add data for applications that are not supported by the SaaS connectors or applications captured by a connector that does not return API data on users and activities.

Import subscription data

This feature is currently in beta and available only in select tenants. To request access, please contact your Flexera representative.

When uploading data for subscriptions in Data imports, keep in mind the following:

  • Subscription ID values are not validated when you upload a CSV file.
  • If a subscription does not have existing values for Billing period and Metric, these fields must be added to the CSV and mapped in the Mapping step when creating the import. If a subscription already has values for Billing period and Metric, these fields do not need to be mapped.
  • Purchase date, Cost per unit, and Currency are interdependent. All three values must be provided or the record will fail to import.
  • For Currency, you must enter a currency that exists in your Snow Atlas tenant or the record will fail to import. For more information on currency management in Snow Atlas, see Currency settings.
  • Expiration date must use the format yyyy-mm-ddT00:00:00:00Z. It cannot be assigned a null value or the record will fail to import.

You can upload CSV files in Data imports to update information for your subscriptions in Flexera One SaaS Management. This enables you to modify or add fields for multiple subscriptions at once, rather than edit them individually. In Data imports, you can update any of the editable fields for your subscriptions. For more information on the supported fields, see Edit subscription: Reference.

Before you create an import, you should generate a CSV template. This template lists all the editable fields that can be modified for the subscriptions you choose to update. For information on generating templates, see Generate import templates. Once you have modified or added fields in a CSV template, upload the CSV file in Data imports. For more information, see Create data imports.

When you create the import configuration, the CSV file is processed and saved in the system. Data from the import is displayed in Flexera One SaaS Management when the Data Update Job completes, or when you manually select Update data at the bottom of a page in Flexera One SaaS Management.

You can update the data captured by a Data import by uploading modified or new CSV files for the import configuration. For more information, see Upload additional data.

Import user and activity data for an application

You can upload CSV files in Data imports to add information about users and user activities for applications. Each import can have multiple user or activity records pertaining to an application. For data from an Activities import to appear on the Flexera One SaaS Management pages, a corresponding Users import must exist for the same vendor and application, and the user identifiers in Activities must match those in Users. For information on creating data imports for Users and Activities, see Create data imports.

When you create an import configuration, the CSV file is processed and saved in the system. Data from the import is displayed in Flexera One SaaS Management when the Data Update Job completes, or when you manually select Update data at the bottom of a page in Flexera One SaaS Management. Users and activity data retrieved from an import configuration are represented by the Data import discovery type in Flexera One SaaS Management. For information on discovery sources, see SaaS discovery.

You can update the data captured by a Data import by uploading modified or new CSV files for the import configuration, or by creating an API integration. For more information, see Upload additional data and Create API integrations.

API integrations

API integrations are only supported for Users and Activities imports.

API integrations can automate the workflow to update data captured in a Data import. These integrations can be supported by automation scripts you create in your local environment that trigger the API calls required to upload data in a CSV file, and then import that data into Flexera One SaaS Management. The basic flow for an API integration is as follows:

  1. Request an upload URL to Azure blob storage from the SaaS API. The response includes a pre-signed, time-sensitive URL to Azure blob storage and a file ID.
  2. Upload a CSV file to Azure blob storage using the pre-signed URL.
  3. Create a task to import the CSV data into Flexera One SaaS Management by placing a request to the SaaS API.

For more information on the steps that can be automated with scripting, see Create API integrations.

To create API integrations, you require access to the SaaS APIs. To get access, create an application registration that has the Manage SaaS data import API integrations permission for SaaS Management. Creating an application registration generates client credentials that you can use to obtain an access token for the SaaS APIs. For more information, see Manage application registrations and Authentication with client credentials.