12 Export Data from Reporting and Analytics
Set up the data export process and run exports to an endpoint to manage data.
Self-service exports let you extract data from the Reporting and Analytics database to a file and then deliver the file to an endpoint through SFTP or through posting to a URL over an HTTPS connection. The export configuration contains code for querying the database and defines the format of the exported data. You associate an export schedule with the configuration to specify the enterprise locations from which data is exported, export frequency, and how the data file is delivered to the endpoint.
The Exports tab houses the export summary page, which shows status across all export configurations for your enterprise. You can drill down to view more details by clicking on the numbers associated with each status.
-
Filter status by selecting an execution time frame for a specific configuration.
-
View export configurations by location by clicking on a status. For example, click Failed to view all configurations by location that failed.
-
Search export results by export configuration and schedule or you can search for results of on-demand exports.
Other actions related to exporting data can be found in side menu of the Exports tab.
- Export Configurations
- Adding a Location Group
Specify a group of locations for which an export configuration exports data. Create a location group before adding an export schedule. - Delivery Profiles
- Export Schedules
Specify the enterprise locations for which an export configuration exports data, sets the export frequency and recurrence, and specify how the system delivers the exported data file. - On-Demand Exports
Run an export schedule on-demand outside of its scheduled run time. - Searching for Exports
Search for on-demand exports or configurations run with schedules. - Tutorial: Export Sales Operations Data
Explains step-by-step how to export menu item sales data for the Sales Operations data category. - Export Status Notification
You can proactively monitor the status of self-service exports by enabling email notifications to one or more people.