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. 1.
    Generate NewRelic API Key for Daton
  2. 2.
    Read more on How to create NewRelic API Key here

Integrate New Relic with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select New Relic from Integrations page
  3. 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. 4.
    You will be redirected to second page where you need to provide the Access Key for your New Relic Account.
  5. 5.
    Select required tables from the available list of tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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.
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.
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.
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.
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.
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.
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.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype
UserList
Purpose: Show a list of all users.
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.
Replication: Full Replication
Replication Key: N/A
Fields
Name
Target Datatype