website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
ConnectWise
Google Sheets
Aloha POS
BILL
Bloom Growth
Ceridian Dayforce
Food Delivery Service Connector
Facebook Ads
Google Analytics 4
Harvest
Hubspot
Jira
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
Workday HCM
Xero
Databases
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Analytics
Access Analytics
Snowflake Usage Analytics
FAQ (about syncing data)
How are new columns are added to the target Data Warehouse?
....
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehousing
Snowflake
Open Source DW Models
Alerts & Notifications
Integrations (Slack, etc.)
Logs & Monitoring
Security
Release Notes
April 2022
July 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Our
License
Viewpoint
Docs powered by archbee 
4min

NetSuite (Oracle NetSuite)

NetSuite is the first online financials and ERP platform with tens of thousands of customers that enables an efficient and robust feature-set to run the core of the business. With all of the financial and operational data, transactions, customer, product, and inventory information it is imperative that NetSuite customer have flexible access to all of the current and historical data available to key data workers in their organization that can help you make better decisions to increase revenue, save costs, etc. and you're going to need a way to synchronize that data to a warehouse in order to democratize access to enrich the NetSuite data with other operational or marketing information. And that's where our NetSuite connector comes in.



NetSuite Connector Pre-Requisites

Connecting to NetSuite, you need to make sure that:

  • You'll need your Account Id (the id of your store provided to you by NetSuite)
  • You'll need the ability to sign in to your NetSuite account (usually a user with admin role privileges)

Instructions (Basic Connection Setup)

DataLakeHouse.io securely connects to your NetSuite account instance and does not store your password or credentials.

Using the form please complete the following basic steps:

  1. Enter a Name or Alias for this connection that is unique in the 'Name/Alias' field
  2. Enter a unique target schema name for your cloud warehouse destination in the 'Target Schema Prefix' where you wish to land the data
  3. Enter your NetSuite account name in the Account Name field
  4. Click the 'Authorize Your Account' button which will transport the page to the NetSuite login, where you will enter your NetSuite account credentials.  Once your credentials are accepted you will be automatically redirect back to this DataLakeHouse.io portal and you should be able to see a successful connection of your source.

If any issues occur with the NetSuite authorization, simply return to the sources page in DataLakeHouse.io, edit this source and click the 'Authorize Your Account' or 'Re-Authorize Your Account' button. If any issues persist please contact our support team via the DataLakeHouse Support Portal.

Updated 03 Mar 2023
Did this page help you?
Yes
No
UP NEXT
Change Log & Notes
Docs powered by archbee 
TABLE OF CONTENTS
NetSuite Connector Pre-Requisites
Instructions (Basic Connection Setup)