Skip to main content
  • Why Choose GURUS
    • About Us
    • Clients
    • Events
    • Gurus Partner Program
    • Reference Program
    • GURUS for GOOD
  • Careers
    • Job Openings
    • Working at GURUS
    • GURUS Academy
  • Contact
Free Business Intelligence Demo   1.877.664.1023
  • Solutions
    • NetSuite
      • NetSuite OneWorld
      • NetSuite PSA & SRP
      • NetSuite OpenAir
      • NetSuite Sandbox
    • Data Toolkit
      • Business Intelligence for NetSuite
        • BI by Role
        • NetSuite Data Warehousing
        • BI Templates for NetSuite
      • GURUS NetSuite Data Exporter
        • Financial Planning & Analysis Edition
    • Custom Solutions
      • Container Management
      • Engineer-To-Order (ETO)
      • Dynamic Special Order
      • Marketplace Reconciliation
      • Bulk Transaction Emailer
    • NetSuite Modules
      • Financials and Management
        • Dunning Letters
        • Financials
        • Fixed Assets
        • Incentive Compensation
      • Manufacturing
        • WIP & Routing
        • Work Orders & Assemblies
      • Retail and Distribution
        • Demand Planning
        • Grid Order Management
        • Inventory Management
        • Procurement
        • WMS Lite
      • Services
        • Job Costing
        • Project Management
        • Resource Allocation
        • Revenue Management
      • Software
        • Contract Renewals
        • Software Management
    • Boomi
    • NetSuite Add Ons Solutions
    • NetSuite for Private Equity Firms

    FREE BUSINESS INTELLIGENCE DEMO

    Request your Free Business Intelligence Demo & Discovery Call Today. Have our resident BI expert guide you through the solution’s features.

    Learn More

  • Industries
    • Industry Solutions
      • Food and Beverage
        • NetSuite’s Top 5 for Food and Beverage
        • Top Software For Food and Beverage Industry
        • Food and Beverage Industry Trends
      • Life Sciences
        • Biotherapeutics
        • Clinical Trials
        • Genomics
        • Laboratories
        • Medical Devices
        • Medical Distribution & eCommerce
        • Medical Practices
        • Medical Software
      • Professional Services
      • Software & Internet Providers
      • Hospitality
      • eCommerce
      • Media & Publishing
      • Non-Profits
      • Engineering
      • Construction
      • Manufacturing
        • Cloud-Based ERP for Manufacturing
        • Complete Manufacturing Workflow with NetSuite
        • How to Increase Profits with NetSuite ERP
      • Cannabis & CBD
      • Wholesale Distribution
        • The Benefits of an ERP For Wholesalers
        • Top Wholesale Distribution Software
        • Wholesale Distributors vs. Direct-To-Consumer
      • Healthcare
        • 5 ERP Features For Healthcare Suppliers
        • Healthcare ERP for Clinics
        • NetSuite FAQ for the Healthcare Industry
      • Energy
      • Retail
        • Benefits of NetSuite for Retail
        • Improve Customer Experience with NetSuite
        • Scale Operations with NetSuite for Retail

    FIND THE NETSUITE BUNDLE FOR YOUR INDUSTRY

     

    Our team of specialists can customize your NetSuite with the right features to meet the needs of your business. Find the right solution for your industry.

    Learn More

  • Services
    • NetSuite Services
      • NetSuite Implementation & Configuration
      • NetSuite Project Rescue
      • NetSuite Training
      • NetSuite Data Migration
      • Business Process Review
      • NetSuite Integration
      • NetSuite Upgrade Readiness Review
      • Customization & Development
      • Assessment & Architecture
      • NetSuite Optimization
      • NetSuite Support
      • Staff a Project
      • NetSuite Admin Services
    • Integrations and Connectors
      • NetSuite Integrations
        • NetSuite to Salesforce Integration
        • NetSuite to Shopify Integration
        • NetSuite to HubSpot Integration
        • NetSuite to Procore Integration
        • NetSuite EDI Integration
        • NetSuite eCommerce Integration
      • Salesforce Integrations
        • Salesforce To HubSpot
        • Salesforce To NetSuite
        • Salesforce To Outlook
        • Salesforce To QuickBooks
        • Salesforce To Slack
        • Salesforce To Call Center Software

    FIND THE RIGHT CUSTOM SOLUTION TAILORED TO YOUR INDUSTRY

    Custom ERP solutions to connect your company’s needs with NetSuite functionalities using custom script. Learn more to find a solution that meets your company’s needs.

    Learn More

  • Pricing
    • NetSuite Pricing
    • Integrations Pricing

    NetSuite Implementation Pricing

    Find the answers to all your NetSuite ERP cost, licensing and implementation questions in our comprehensive Pricing Guide for buyers.

    Learn More

  • Resources
    • Browse resources
      • FAQ
        • NetSuite Data Exporter
        • GURUS Business Intelligence
        • NetSuite FAQs
      • Guides
        • NetSuite Implementation Guide
        • NetSuite Saved Searches
        • NetSuite Self-Assessment Guide
      • Blog
      • Video
      • Press Releases
      • ERP Comparison Chart
    • Filter resources
      • All
      • Demos
      • Podcasts
      • White Papers
      • Data Sheets
      • Webinars
      • Glossary

    NetSuite: What Is It?

    This GURUS micro-video series revolves around everything NetSuite. If you’re on the fence about implementing NetSuite, stop and watch to see exactly what NetSuite has to offer.

    View All Videos

Breadcrumb

  • Home
  • Blog
  • BI Integration User Guide: NetSuite to Salesforce

BI Integration User Guide: NetSuite to Salesforce

Profile picture for user Neil Stolovitsky
By: Neil Stolovitsky 27.04.2023
Copied to clipboard

 

It is not uncommon for the NetSuite customer to explore various methods to integrate their CRM and ERP data for improved analytics and visibility into their business processes.

As a first instinct related to their CRM and ERP integration initiative, many organizations initially seek connectors that address their application integration needs in the hopes of centralizing key metrics in their primary system of record.

As a result, these integrations can lead down a long road involving heavy investment in resources and money to achieve their ultimate goal.

Fortunately, not all integration projects require a heavy investment, and in fact the right tools can deliver powerful data analysis in a fraction of the time.

Request More Info About BI Integration: NetSuite to Salesforce
 

At GURUS Solutions, the in-house product Business Intelligence (BI) for Netsuite is built on a proven Google tech stack.

It allows customers to integrate their Salesforce data with NetSuite for robust analytics on popular data visualization tools such as Looker Studio, Tableau Software and Microsoft Power BI.

Our user guide is designed to walk you through a typical way our customers can have accurate data from a NetSuite and Salesforce integration with our business intelligence tool.

Table of Contents

1. How to Install BI for NetSuite?

2. Configuring the BigQuery Data Warehouse

  • Google Cloud Project Setup
  • GURUS NetSuite Standard Data Model Synchronization

3. Looker Studio Data Visualization Setup

  • Accessing NetSuite Data Model
  • Blending Data Sources

4. Google Sheets Connection to Salesforce

  • Google Sheets Connection Setup
  • Blending BigQuery NetSuite and Salesforce Data Sheets in Looker Studio

5. Other Integration Options

How to Install Business Intelligence (BI) for NetSuite?

Business Intelligence for Netsuite (Powered by GURUS) is a turnkey analytics solution built on the Google Cloud tech stack leveraging Google’s BigQuery data warehouse.

Installation of the product requires the purchase of a license and a standard activation, which is led by the GURUS product team.

The NetSuite bundle and proprietary GURUS connector synchronizes NetSuite Data with a pre-built data model housed in a data warehouse for consumption.

Configuring the BigQuery Data Warehouse

The first step in connecting your NetSuite data to the Google BigQuery data warehouse is to set up a Google cloud project for BigQuery to enable hosting and billing purposes.

GURUS can host the BigQuery project for you or you can host your own.

Google Cloud Project Setup

Should you choose to create a project and host your open BigQuery data warehouse, you must have the resourcemanager.projects.create permission.

This permission is included in roles like the Project Creator role (roles/resourcemanager.projectCreator), which is granted by default to the entire domain of a new organization and to free trial users. 

For information on how to grant individuals the role and limit organization-wide access, see the Managing Default Organization Roles page.

If you do not specify the parent resource, a parent resource is selected automatically if applicable based on the user account's domain.

You can create a new project using the Google Cloud Console, the Google Cloud CLI, or the projects.create() method.

Step 1: Creating a New Google Cloud Project

  1. Go to the “Manage Resources” page. You can look this page up in the search bar.
  2. Press on the “Create Project” button in the top left corner.
  3. Give the project a name. 
  4. Select your company's named organization.
  5. Choose the GURUS BI folder as a location.

Step 2: Creating a Billing Account

  1. Only create a billing account if you do not have one.
  2. Log into GCP with the guidance of the GURUS activation team.
  3. These steps must be done by a user with the “Billing Account Administrator” role.
  4. To create a billing account, press on the “Navigation Menu” on the top left of the screen and press on the “Billing” tab.
  5. Select “Manage Billing Accounts.”
  6. Press on “Create Account” and create the billing account.

Step 3: Assign Billing Account to the Project

  1. Has to be done by a user with the role of “Billing Account User.”
  2. Go to the “Manage Resources” page. You can look this page up in the search bar.
  3. Press on the “Navigation Menu” on the top left of the screen and press on the “Billing” tab.
  4. Press on the “My Projects” tab.
  5. Press the three dots and select “Change Billing.”
  6. Assign the customer’s billing account.

Step 4: Setup the Billing and Logs to export to BigQuery for Reporting

As part of the Business Intelligence for NetSuite activation, the GURUS team will set up usage reports to track customer specific metrics, configure Google Cloud service accounts to configure GURUS proprietary BI connector, add Power Users if needed, and set up BigQuery data sets.

Sample Usage Report Provided to Customers

Table creation of the NetSuite data model along with 60+ views, custom records and fields defined by the customer will be configured during activation.

To access BigQuery go to https://cloud.google.com/bigquery/ and login to your Google Account.

Once logged in, Click on View Console.To learn more about this process, please reach out to your designated sales representative or click here for a demo and pricing.

Looker Studio Data Visualization Setup

Accessing NetSuite Data Model in Looker

Should you choose to create a project and host your open BigQuery data warehouse, you must have the resourcemanager.projects.create permission.

  1. Google Account - Confirm that you have access to your Google account
  2. Google Looker Studio - Confirm you have access to Google Looker Studio by going to: https://lookerstudio.google.com/u/0/navigation/reporting
  3. By going to "Shared with me" you should see the reports we shared with you.
  4. BigQuery dataset - Confirm you have access to GURUS BI dataset.
  5. In Looker Studio, click "Create" and select "Dataset".
  6. Select BigQuery.
  7. Select "My Projects".
  8. You should see your project "${customerGcp}".
  9. Clicking on it, you should see the "netsuite_production" dataset.

Blending Data Sources

If you want a single chart to visualize data from two or more different data sources in Looker Studio, you can blend data to enable your chart to visualize fields from multiple data sources.

This allows you to join the records of one data source to the records of up to four other data sources, as long as those data sources share one or more dimensions as a join key.

For example, the screenshot below shows the Blend Data panel with 3 data sources:

  1. Website A, Website B, and Mobile Apps A. 
  2. The join key is the Source dimension. 
  3. The blended data source created from this includes all the records from Website A, along with any records from Website B and Mobile Apps A that share the same Source values as Website A.

You can create a blended data source from two starting points:

Option 1:  In Edit mode in your selected report go to Resource > Manage blends.

Option 2:  Select “Blend Data” option in the Data menu on the right.

Once the Blend Data section appears, select 2 or more tables (datasources). Similar to SQL you have 4 methods to join tables: Left, Right, Inner, Full, Cross.

Users can join up to 4 tables with up to 10 fields each.

Step 1: Select “Join another table”, search and select the additional data source to join tables.

Step 2: Select the relevant dimensions and metrics or create calculated metrics as needed from each data source.

Step 3: Set up the join by selecting the relevant join operator and matching dimension(s) as a Join Keys, then save.

Step 4: Name the new Data Blend and save.

 

Blended Data Definitions and Join Options

Google Sheets Connection to Salesforce

Google Sheets Connection Setup

One of the easiest ways to blend Salesforce CRM data with NetSuite data is to synchronize Salesforce data with a Google Sheet and then leverage a visualization tool like Looker Studio, which will allow the blending of this data with NetSuite data housed in a data warehouse like Big Query.

In fact, a Data Connector for Salesforce is available in the Google Workspace Marketplace free of charge.

Here are the steps to synchronize Salesforce with Google Sheets:

  1. Open a Google Sheet and go to Extensions/Add-Ons/Get Add-Ons and search for “Salesforce Connector”

  2. Select the Data Connector for Salesforce Add-On and follow instructions to synchronize data with Salesforce.

Blending BigQuery NetSuite and Salesforce Data Sheets in Looker Studio

As a first step, you’ll need to access our synchronized Google Sheets (with Salesforce data) in Looker Studio.

You can do this by:

  1. Google Account - Confirm that you have access to your Google account
  2. Google Looker Studio - Confirm you have access to Google Looker Studio by going to: https://lookerstudio.google.com/u/0/navigation/reporting
  3. By going to "Shared with me" you should see the reports we shared with you.
  4. Google Sheets dataset - Confirm you have access to GURUS BI dataset and Google Sheets dataset.
  5. In Looker Studio, click "Create" and select "Dataset"
  6. Select your Google Sheets Salesforce dataset and follow the instructions in the Blending Data Sources section above to join Salesforce data in Sheets with NetSuite data in Google BigQuery.

Other Integration Options

For more complex data integration platforms between NetSuite and Salesforce, with the NetSuite Business Intelligence solution powered by GURUS, Salesforce customers can leverage Apex and Lightning to natively integrate with Google’s BigQuery data warehouse.

Once Salesforce data is pushed to BigQuery, the GURUS BI solution will provide a pre-built NetSuite data model.

This allows the blending of both data sets via almost any data visualization tool in the marketplace, including Looker Studio, which comes standard with GURUS BI and other popular visualization tools such as Tableau Software and Microsoft Power BI.

To learn how Salesforce can integrate with Google BigQuery, check out this blog.

Another data integration option to consider is Salesforce's recently acquired data visualization tool Tableau Software that natively integrates with Salesforce data.

This data integration option allows for blending of the data sets within Tableau Software where Salesforce data will be pulled directly into Tableau and NetSuite data can easily be connected to Tableau via the GURUS’ BI for NetSuite product, connecting to an optimized NetSuite integrated data model housed in a BigQuery data warehouse.

Request More Info About BI Integration: NetSuite to Salesforce
 

About Neil Stolovitsky

Neil Stolovitsky has over 20 years of IT experience with end-user, consulting, and vendor organizations, along with extensive expertise in Pre-Sales, Business Development, Product Marketing, Software Selection, and Channel Strategies. He has published numerous blogs, white papers and articles covering Business Intelligence, Enterprise Resource Planning (ERP), Professional Services Automation (PSA), Project Portfolio Management, IT Governance, and New Product Development to a global audience. Neil currently holds the position of Product Manager with GURUS Solutions.

Recent posts

  • Profile picture for user Victoria Sapsford
    By : Victoria Sapsford 23.05.2023

    What is a Cloud Exit Strategy?

    • Popular ERP Questions
    Before implementing an ERP, it’s important to prepare for a cloud exit strategy, whether you eventually move away from the cloud or change ERP platforms.
    Read this post
  • Profile picture for user Neil Stolovitsky
    By : Neil Stolovitsky 27.04.2023

    BI Integration User Guide: NetSuite to Salesforce

    • BI for NetSuite ERP integration
    Your NetSuite to Salesforce integration has never been in better hands thanks to GURUS’ Business Intelligence for NetSuite data integration user guide.
    Read this post
  • Profile picture for user Aidan Lavoie-Whittall
    By : Aidan Lavoie-W… 20.04.2023

    NetSuite vs Epicor: Comparing ERP Systems

    • ERP Comparison
    Why NetSuite is the better choice for your business: A comparison of NetSuite and Epicor ERP Systems’ benefits, features, and functions.
    Read this post
Related tags
  • ERP Integration

News & Events

  • Press releases

    GURUS Solutions named to the Bob Scott Top 100 VARS for 2023

    Montreal, Quebec - June 28th 2022 On June 9th, 2022, GURUS Solutions was named to The Bob Scott Top 100 VARS for 2022. The
    Read more
    Published 30 January 2023
  • Press releases

    GURUS Solutions Unveils Partnership with Mavenlink

    GURUS Solutions is proud to announce its latest partnership with Mavenlink, the industry cloud for professional services
    Read more
    Published 10 March 2022
  • Press releases

    Dell sells Boomi to Francisco Partners and TPG Capital

    [Chesterbrook, PA, Round Rock, Texas, San Francisco - May 2, 2021] As of May 2nd, 2021, Dell Technologies has officially reached
    Read more
    Published 20 May 2021

Blog

  • What is a Cloud Exit Strategy
    Victoria Sapsford, 23.05.2023
     Over the years technology has gained enormous traction within the B2B and B2C sectors,
  • BI Integration: NetSuite to Salesforce
    Neil Stolovitsky, 27.04.2023
     It is not uncommon for the NetSuite customer to explore various methods to integrate their
  • NetSuite vs Epicor
    Aidan Lavoie-Whittall, 20.04.2023
     Finding the right Enterprise Resource Planning (ERP) tool can be difficult, as there are
All posts

Contact

TOLL-FREE: 1.877.664.1023
info@gurussolutions.com

Head Office

9880 Clark Street, Suite 101
Montreal, QC
H3L 2R3 Canada

Tel: 514.664.1023

Join the Team

We are always on the 'lookout' for new talent. Are you The One we are looking for?

Careers

 

Regional offices

Boston, MA: 617.807.0903
Chicago, IL: 312.588.7295
Cleveland, OH: 216.202.0264
Dallas, TX: 214.377.1221
Manchester, NH: 603.657.9458
Miami, FL:786.453.9063
Oklahoma City, OK: 405.896.8422
Ottawa, ON: 613.454.6013
Rochester, NY: 585.666.0574
San Francisco, CA: 415.449.8611

 

SEE ALL LOCATIONS

Follow us in social media

Copyright © GURUS Solutions   |   All rights reserved  |   Privacy policy