Import data by using data provider connectors

Sustainability Manager includes a separate experience to import data from data provider connectors. We're building a robust catalog of prebuilt and custom connectors from operational data providers. For our first-party resources, prioritize partnerships that aggregate data across a key emission category, so that you can meet the needs of many customers at the same time.

Our long-term strategy is for data providers to take responsibility for connecting to our service and adopting the Microsoft for Sustainability data model. You can currently connect your data through comma-separated values (CSV) files, Excel files, Open Data Protocol (OData), and over 40 connectors that are available in Power Query. Future versions will include more first-party and third-party connectors that provide the required data set for each emissions category.

To import data from any of the available data provider connectors, select the DATA PROVIDER CONNECTORS tile under Data imports. Select any available solution and then enter your credentials. The credentials page and user experience might vary based on the data, data provider connectors, and integration with Sustainability Manager. After the credentials are validated, you define the schedule, provide a name for the import, and complete the setup. Based on your defined schedule, data is automatically imported from the data provider connector into Sustainability Manager.

For instructions on importing data, select one of the following data provider connectors:

• Ecolab connector
• EcoVadis Assessments
• Emissions Impact Dashboard connector

Related information

• Overview of data import
• Incremental data refresh
• Change data import connection ownership (preview)
• Import data with Excel templates
• Import data with Power Query
• Import data with data provider connectors
• Import data manually
• Review data imports
• Considerations and FAQs
• Integration