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