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