# NewRelic

### 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                | <p>Full Replication<br>Key Based Incremental</p> |
| 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](https://docs.sarasanalytics.com/source-api-keys/newrelic-api-keys)

### Integrate New Relic with Daton

1. Signin to Daton&#x20;
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&#x20;
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 |
| ---- | --------------- |