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) a netsuiteservice account or non administrator account for testing and connecting to dlh io note this connection uses the netsuite rest web services configuration, so when testing it is best to create a service account and assign it the appropriate role(s) or use another user who will act as the user connecting to your netsuite account for this integration per the netsuite documentation regarding oauth 2 0 access a user assigned a role with the oauth 2 0 authorized applications management permission cannot access restlets, rest web services, and suiteanalytics connect using oauth 2 0 to use oauth 2 0 for access, the user must be assigned a role with the log in using oauth 2 0 access tokens permission this is because if you have the administrator role assigned to you, your user includes the authorized applications management permission as one of your roles, which would conflict or be not perissable per the instructions from netsuite netsuite setup steps for oauth rest api access these instructions being provided are specific to the dlh io netsuite connector while it is recommended to also use the netsuite suiteanalytics connector, this connector we believe provides additional or more streamline data replication though a reduced number of tables will be replicated to your target due to the limited number of available entities available using this integration approach which behind the scenses uses the netsuite rest api for netsuite web services here is the list of available rest api entities available per the netsuite documentation these steps below are required to configure your netsuite account environment to successfully integrate with dlh io (again, these steps have similarities to, but are mainly different from the netsuite suiteanalytics connector setup) configure your netsuite account for suitecloud and oauth 2 0 begin configuring setup from the main header menu and click on the path setup > company > enable features in order to access the suiteanalytics enablement area click on the suitecloud tab check the box for client suitescript in the suitescript section click on i agree to accept the terms of service that opens check the server suitescript option in the suitescript section click on i agree to accept the terms of service that opens under the suitetalk (web services) section check the checkboxes for soap web services rest web services under manage authenctication, check the checkbox for oauth 2 0 save the setup enable features page by clicking the save button at the bottom or the top of the enable features page (optional) if using the dlh io standard netsuite (oracle netsuite) docid\ wygqqfsbdfs8mq7cz6euf connector you will also check the checkbox for oauth 2 0, which allows different entities to be retrieved (optional for this connector) click the save button which is visibile when you scroll to the bottom of the page create an integration for netsuite rest api oauth 2 0 access navigate to create a new integration by accessing the main header and selecting setup > integration > manage integrations > new in the create new integration page you will need to update the following items by updating the following form fields with the values name = datalakehouse io integration rest api description = integrate dlh io with netsuite rest api state = enabled note = optional, for your records authentication area oauth 2 0 section authorization code grant = check the checkbox rest web services = check the checkbox suiteanalytics connect = check the checkbox redirect uri = https //app datalakehouse io/dashboard/oauth redirect https //app datalakehouse io/dashboard/oauth redirect you must enter the appropriate value for redirect which is an endpoint on datalakehouse io so that the integration configuration will complete and use the appropriate setup once you create the source connector in dlh io oauth 2 0 consent policy = always ask click the save button to save the integration the client credentials area will appear above the save button area and underneath the user credentials section towards the bottom of the page please copy these as they will be used in your connection settings for dlh io note these keys, and secrets will not be visible once you leave this page so, please copy them somewhere to be safely stored and used when creating the connector if you somehow miss this opportunity, revisit the integration you just created and click the 'reset credentials' button at the top of the page user role & permissions required for integration access a new role is highly recommended to be created in order to assign the necessary permissions for oauth2 integration when the dlh io connection is first created and authenticated you are redirected back to your netsuite account and have the ability to select the role which you will access the netsuite rest api through, and that role needs to have the appropriate access however, you could use an existing role we recommend creating a new role which will be specific to the datalakehouse io and netsuite integration navigate to setup > users/roles > manage roles > new in the name field, enter a unique name for the role, ex dlh ns role scroll down the page to find the permissions tab click the setup sub tab from the permissions dropdown select the following and click the add button to add these permissions rest web services soap web services log in using oauth 2 0 access tokens click the save button to save the new role you created next, we need to specify which user will connect to suiteanalytics when configured in dlh io, so navigate to setup > users/roles > manage users click the name of the user which you've identified to be the user profile that will connect to netsuite suiteanalytics in the resulting page click the edit button scroll down to the bottom and click on the access sub tab click the roles sub tab from the dropdown select the data warehouse integrator role click add click the save button to save the changes for the user optional/alternative, updating an existing role with permissions note if updating any existing role to add these permissions necessary for the oauth 2 0 access, find the role, click to edit the role, then in the sub tab click on permissions > setup then below you will be able to add the new permission as follows 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 enter a name or alias for this connection that is unique in the ' name/alias ' field enter a unique target schema name for your cloud warehouse destination in the ' target schema prefix ' where you wish to land the data enter your netsuite account name in the account id field enter your netsuite account name in the cliend id field enter your netsuite account name in the client secret field 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 usually and it is recommended to select a non administrator role, so selecting the option to choose another role , and then selecting the appropriate role from the list by clicking choose role will then allow you to click the allow button once authenticated and returned to dlh io you may access the connection and click on the schema tab ensure that the list of entities/tables appears if not you may click the reload schema button please note, reload of the schema may take 2 10 minutes to complete depending on how large of an instance is your account done issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com