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

1. Signin to Daton

2. Select Pingdom from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your api token from your pingdom account to authorize Daton to periodically extract data from pingdom.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. 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

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. 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