Batch export helps you incorporate OpsRamp-generated enterprise data into your data collection and analysis.
You can snapshot and batch export the following types of data for each client on demand and at scheduled intervals to Amazon AWS S3 and Microsoft Azure Blob Storage :
- Ticket data
- Alert data
- Metric data
- Inventory data
- Usage data
Data is exported in JSON format. A list of failed exports is also provided if applicable.
The exported data content depends on the type and frequency of the export schedule, which determines the data items and quantity.
Only a partner can set up a batch export, and a partner can specify different data types by client for export. When a partner uses the API to create an export, the export is created for all clients who have not previously created the same export using the user interface. You can schedule batch exports using the Batch Export API.
The following batch export types for different data types are available:
|Export Type||Applicable Data Type(s)||Description|
|Snapshot||Inventory||This data export provides a snapshot view of the data at the instance of export generation into the Amazon S3 bucket folder or Azure Blob storage.|
|Incremental||Alert, Ticket, Metric||The incremental batch export sends the previous three months of data as the first batch export. Subsequent exports are the incremental export of updated records. You can schedule recurring or on-demand data export:|
Metric data export occurs every hour by default and cannot be customized. You can get metric data using the metric APIs.
After exporting the data from OpsRamp to the installed integrations you can view the exported data on the OpsRamp platform, AWS S3, and Azure Blob:
|Batch Export Name||batch export name|
|Client Name||selected client name|
|Last Run||time and date of the last export|
|Last Export||status of the last export:|
|Action||To export data from OpsRamp. The Run Now action is available only for data export with the On Demand Only option.|
Step 1: Select the batch export add-on
- At the partner level or for a selected client, go to Setup > Integrations.
- Click Edit.
- Select the Add ons tab.
- Select Batch Exports.
Step 2: Install an export integration
Integrate with AWS S3 or Azure Blob to export the data to either an AWS S3 bucket or an Azure Blob container.
Create Amazon AWS S3 bucket storage or Microsoft Azure Blob storage folders.
Step 3: Create a batch export
Select the data type, specify the export schedule, and select the integration target.
Select Setup > Exports > Batch Export.
From the BATCH EXPORT screen, click the + icon.
Enter the following information:
Property Description Name Unique name of the export. Client Client for whom the data is exported. Type Type of data to export.
When selecting Usage, the option to choose Failure Export Notification is presented. The email notification provides details about the Name, Type, Client, Schedule, Export Destination, Last Run Time and Date, and Created By information:
- On Demand Only generates exports when a request is created or rerun.
- On-Demand and on Recurring Schedule generates export data when you raise a rerun request and generates an incremental export at scheduled intervals.
Export to Specify integration to AWS S3 or Azure Blob.
Click Save & Run to apply the export and display export details:
View batch exports on OpsRamp
You can view the configured Batch Export details in Exports > Batch Export. The BATCH EXPORT LIST page displays the details of the Batch Export.
View batch exports on AWS S3
You can view the generated batch exports in an AWS S3 bucket in the corresponding folders. For example, the alerts export is stored in the alerts folder:
AWS stores the export files in S3 folders in JSON format. The export file name has the following encoding:
- (a) schedule of batch export, recurring or on-demand
- (b) batch export type
- (c) unique client ID
- (d) schedule starting timestamp
- (e) schedule ending timestamp
- (f) recurring export serial number
View batch export on Azure Blob
You can view the generated data exports in the Azure Blob container in the corresponding folders:
Azure Blob stores the export files in Azure Blob containers in JSON format. The export file name has the encoding shown in the following figure:
- (A) schedule of batch export, recurring or on-demand
- (B) batch export type
- (C) unique client ID
- (D) schedule starting timestamp
- (E) schedule ending timestamp
- (F) recurring export serial number