Pingdom
Pingdom ETL connector for data replication
Pingdom
Pingdom ETL connector for data replication
Snapshot
Features |
Details |
Release Status |
Released |
Source API Version |
v3.1 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
Pingdom API token |
Replication Type |
Key Based Incremental Full Based Replication |
Replication Key |
Date |
Suggested Replication Frequency |
24 hrs |
| Tables/APIs Supported | |
checks |
maintenance |
maintenance_occurrences |
probes |
Integrate Pingdom with Daton
- Signin to Daton
- Select Pingdom from Integrations page
- Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide your api token from your pingdom account to authorize Daton to periodically extract data from pingdom.
- Post successful authentication, you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration
Workflow
- Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- Users would be able to edit/pause/re-activate/delete integration anytime
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
PINGDOM Data
Checks
Purpose: Returns the list of all checks.
Source API Documentation https://docs.pingdom.com/api/#tag/Checks/paths/~1checks/get
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
NUMERIC |
created |
NUMERIC |
name |
STRING |
hostname |
STRING |
resolution |
NUMERIC |
type |
STRING |
ipv6 |
BOOLEAN |
verify_certificate |
BOOLEAN |
lasttesttime |
NUMERIC |
lastresponsetime |
NUMERIC |
status |
STRING |
maintenanceids |
STRING |
Maintenance
Purpose: Returns a list of user's maintenance windows.
Source API Documentation https://docs.pingdom.com/api/#tag/Maintenance/paths/~1maintenance/get
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
NUMERIC |
description |
STRING |
from |
NUMERIC |
to |
NUMERIC |
duration |
NUMERIC |
durationunit |
STRING |
recurrencetype |
STRING |
repeatevery |
NUMERIC |
dayofweekinmonth |
NUMERIC |
effectiveto |
NUMERIC |
checks |
RECORD |
MaintenanceOccurences
Purpose:Returns the list of maintenance occurrences.
Source API Documentation https://docs.pingdom.com/api/#tag/Maintenance/paths/~1maintenance/get
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
id |
NUMERIC |
maintenanceid |
NUMERIC |
from |
STRING |
to |
STRING |
duration |
NUMERIC |
durationunit |
STRING |
Probes
Purpose:Returns a list of all Pingdom probe servers for Uptime and Transaction checks.
Source_Api documentation https://docs.pingdom.com/api/#tag/Maintenance/paths/~1maintenance/get
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
NUMERIC |
country |
STRING |
city |
STRING |
name |
STRING |
active |
BOOLEAN |
hostname |
STRING |
ip |
STRING |
countryiso |
STRING |
region |
STRING |