13 Export Data from Reporting and Analytics
Set up the data export process and run exports to an endpoint to manage data.
Export configurations let you export 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.
- Adding an Export Configuration
Add subject areas to the configuration, add code that queries the database, specify the format of the exported data. - 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. - Adding a Delivery Profile
Specify delivery through SFTP or HTTPS, define destination settings such as the server location for SFTP or the URL for HTTPS, specify authentication details. A delivery profile must be added before adding an export schedule. - Adding an Export Schedule
Specify the enterprise locations for which an export configuration exports data, set the export frequency and recurrence, 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. - Changing the Export Configuration Owner
- Deleting Export Configurations
- 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.