Set up Batch Export

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: On-demand - Export provides a snapshot of the data at the time of the generation of the export. Recurring - Export provides snapshots of the data at the chosen time. When you request incremental data on demand, the export generates a snapshot of the previous three months. 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:

Attribute	Description
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: Success Failed
Created By	author
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:
Schedule	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