Optimizing Integration: Salesforce To Netsuite Analytics Warehouse

By Author: Yantra Inc
Total Articles: 39
Comment this article

Understanding Salesforce And NetSuite Analytics Warehouse
Salesforce’s REST API provides a powerful, convenient way to access Salesforce data programmatically. NetSuite’s Analytics Warehouse, on the other hand, offers robust data warehousing and analytics capabilities. Integrating these two allows businesses to leverage Salesforce data in advanced analytics workflows.

Prerequisites for Integration

Before starting, ensure you have administrative access to both Salesforce and NetSuite accounts. You’ll also need a basic knowledge of NSAW and Salesforce.

Step-By-Step Guide To Integration
As a service administrator, you can use the NetSuite Analytics Warehouse extract service to acquire data from the Salesforce SaaS instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.

The process outlined is a comprehensive guide for loading data from Salesforce into NetSuite Analytics Warehouse. Here’s a structured summary of the steps:

Enable Salesforce REST in Salesforce
– ...
... Before beginning, ensure Salesforce REST is enabled on the “Enable Features” page within NSAW as depicted below.

Creating the Salesforce Data Connection in NetSuite Analytics Warehouse
Access Data Configuration: In NetSuite Analytics Warehouse Console, navigate to ‘Data Configuration’ under ‘Application Administration’.
Manage Connections: Go to ‘Manage Connections’ and select ‘Create’ and then ‘Connection’.
Setup Connection Details: Choose ‘Salesforce REST’ as the connection type. Fill in the details:
Connectivity Type: Select ‘Standard’.
Notification Email: Provide an email address for notifications.
Salesforce URL: Enter the URL of your Salesforce instance.
Token URL: Copy and paste the token URL from your Salesforce instance.
Authorization Type: Choose either ‘BASICAUTH’ or ‘OAUTH’ (in uppercase). Fill in the corresponding fields:
For ‘BASICAUTH’: Provide username, password, security token, URL, client ID, and client secret.
For ‘OAUTH’: Provide username, token URL, client ID, and private key.
Credentials: Enter Salesforce credentials (User Name, Password, Client ID, Client Secret, Security Token, Private Key).
Finalizing the Connection
Save the Connection: Click ‘Save’ to store the connection settings.
Refresh Metadata: On the ‘Manage Connections’ page, use the Actions menu for the connection and select ‘Refresh Metadata’.
Test the Connection: Ensure the connection is successful by selecting ‘Test Connection’.
Creating Data Augmentation
Navigate to Data Augmentation: Go to the ‘Data Augmentation’ tile on the ‘Data Configuration’ page.
Setup Data Augmentation: Create a data augmentation using Salesforce data. Choose ‘Regular’ as the source dataset type and select Salesforce as the pillar. Then, pick the applicable Salesforce source tables.
Note on Metadata Extraction
Remember that you can’t create augmentations for Salesforce data without performing a metadata extract first.

To know more visit- Optimizing Integration: Salesforce to NetSuite Analytics Warehouse