NewRelic

NewRelic ETL connector for data replication

Snapshot

Features

Details

Release Status

Beta

Source API Version

v2

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

New Relic Access Key

Replication Type

Full Replication Key Based Incremental

Replication Key

updated_at date

Suggested Replication Frequency

24 hrs

##Tables/APIs Supported

ApplicationsList

ApplicationMetricData

AlertVoilationsList

AlertChannelsList

BrowserApplicationList

KeyTransactionsList

ServersList

UserList

AlertIncidentsList

Pre-requisites

  1. Generate NewRelic API Key for Daton

  2. Read more on How to create NewRelic API Key here

Integrate New Relic with Daton

  1. Signin to Daton

  2. Select New Relic 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. You will be redirected to second page where you need to provide the Access Key for your New Relic Account.

  5. Select required tables from the available list of 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

TABLES

ApplicationsList

Purpose: This API endpoint returns a list of the Applications associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/applications/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype

ApplicationMetricData

Purpose: This API endpoint returns a list of values for each of the requested metrics.

Source API Documentation https://rpm.newrelic.com/api/explore/applications/metric_data

Replication: Key-Based Replication

Replication Key: from

Fields

Name

Target Datatype

AlertVoilationsList

Purpose: It returns a list of the violations associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/alerts_violations/list

Replication: Key Based Replication

Replication Key: start_date

Fields

Name

Target Datatype

AlertChannelsList

Purpose: It returns a list of the channels associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/alerts_channels/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype

BrowserApplicationList

Purpose: This API endpoint returns a list of the Browser Applications associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/browser_applications/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype

KeyTransactionsList

Purpose: This API endpoint returns a list of the key transactions associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/key_transactions/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype

ServersList

Purpose: This API endpoint returns a list of the Servers associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/servers/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype

UserList

Purpose: Show a list of all users.

Source API Documentation https://rpm.newrelic.com/api/explore/users/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype

AlertIncidentsList

Purpose: This API endpoint returns a list of the Incidents associated with your New Relic account.

Source API Documentation https://rpm.newrelic.com/api/explore/alerts_incidents/list

Replication: Full Replication

Replication Key: N/A

Fields

Name

Target Datatype