ServiceGrid Article - Databroker

From DocWiki

Jump to: navigation, search

Contents

Overview

The Cisco ServiceGrid platform provides upload/import and download/export functions to acces the ServiceGrid database. These functions can be performed manually or automatically using schedulers.

  • Manual upload and download functions are performed directly from the affected module such as call lists from SG.call, device lists from SG.inventory, user lists from BasicData, and so on.
  • SG.databroker combines the automatic upload and download functions at one single point of the platform.
  • SG.databroker also provides the log lists of all uploads and downloads that are completed.

NOTE: Automatic uploads and downloads need additional settings such as upload profiles that are set in the SG.databroker module.

An overview function can be activated or deactivated using the permission groups in order to access the functions or setup of a module.

Uploads

The upload functions are used for the initial import of basic data, such as users, locations, devices, and so on, and for periodically synchronizing the data managed in other databases on a need basis.

Upload List

The upload list shows all manual and automatic uploads that are completed for the defined time period. The cross or check symbol at the beginning of each record indicates whether the upload is completed or not. The following actions can be performed within an upload list:

  • Click the Triangle symbol for receiving the upload details.
  • Click the cross or check symbol for canceling the running upload.

Upload Details

If a selected upload continues to progress, click the Refresh button to update the proviced log information. If you want to go back to the upload list page, click the Back to list link.

Field Names
Field Description
ID
Unique ID of the upload
Filename
Name of the uploaded file
State
Indicates whether an upload is successful or unsuccessful or is still in progress
Entity
Shows the type of uploaded information
UploadTime
Time of the upload
StartTime
Start time of the upload
CompletedTime
End time of the upload
LinesProcessed
Shows the number of lines that are processed in the upload file
Total processed time
Shows the processed time of the upload. This value is fixed for a completed upload or incremental for an upload in progress
SendCompleteMailFlag
A flag specifying whether an Email should be sent after the upload is completed
Editor
User name who performed the upload
FileSize
Size of the upload file
ScheduledTimeUTC
Planned time for processing the upload
Journal
Shows the no. of records that have been created, changed or unchanged
















Upload Profiles

Upload Profiles are required for automatic uploads completed through Email. An upload profile contains all settings and the field mapping of the upload file. An automatic upload that fulfills the correct preconditions will use the upload profile for performing the upload. Automatic uploads will be performed only if a suitable upload profile exists; otherwise, the uploads will be trashed.

Downloads

The download functions are used to provide data such as call data, location data, user data, device data, etc. to other applications or databases.

The download list shows all manual and automatic downloads that are completed. The cross or check symbol at the begining of each line indicates whether the upload is completed or not.

The following actions can be performed within a download list:

  • Click the Triangle symbol for receiving the download details.
  • Click the Add a scheduler button for performing a new download automatically and periodically.

For a complete list of Cisco ServiceGrid Articles, go to the List of Articles page.

Related Articles

Databroker Concept

Uploading Data

Downloading Data

Rating: 0.0/5 (0 votes cast)

Personal tools