Using Single Sign-On with NetSuite Analytics Warehouse
You can use single sign-on (SSO) to go from NetSuite to your Analytics Warehouse instance without entering your login credentials. To enable users do this, you need to:
-
Have an account with an SSO service that uses Security Assertion Markup Language (SAML) or OpenID Connect (OIDC).
The NetSuite Analytics Warehouse SSO currently supports these identity providers (IdP):
-
For SAML SSO: Azure, Okta.
-
For OIDC SSO: Azure, Okta, NetSuite.
-
-
Have the NSAW Administrator role assigned.
-
Have set up the initial data transfer.
All users who access the Analytics Warehouse with SSO need to be added to the SSO network (SAML or OIDC) first. If you want to let external users log in to the Analytics Warehouse with their own credentials, you need to ask Technical Support before setting up SSO. For more information about contacting Technical Support, see Technical Support.
Setting up SAML SSO for NetSuite Analytics Warehouse
You can enable users to access their Analytics Warehouse instance with SAML SSO. For more information about SAML SSO, see SAML Single Sign-on.
To set up SAML SSO for NetSuite Analytics Warehouse:
-
Get the metadata file from your IdP.
-
Verify that the users exist both in your IdP and in NetSuite Analytics Warehouse with the same email address. For more information, see Managing Users, Groups, and Access.
-
Enable SAML SSO in NetSuite. The process for enabling SAML SSO in NetSuite depends on your IdP.
-
Go to Setup > Integration > Configuration and click Log in to NetSuite Analytics Warehouse.
-
Click Authentication.
-
Select Enable SSO.
-
Select SAML as the IdP type.
-
Upload the IdP metadata file you saved in step 1.
-
Click Save.
-
Log in to NetSuite with the SSO user and role through the IdP.
Setting up OIDC SSO for NetSuite Analytics Warehouse
You can enable users to access their instance of NetSuite Analytics Warehouse with OIDC SSO. For more information about OIDC SSO, see OpenID Connect (OIDC) Single Sign-on.
To do this, you need to:
-
Create an integration record.
-
Set up OIDC SSO for NetSuite Analytics Warehouse.
-
Set up and enable the roles.
Only users assigned the Administrator role can complete these steps. Also, only users assigned the NSAW Administrator role can set up OIDC SSO.
To create an integration record:
-
Go to Setup > Integration > Configuration and click Log in to NetSuite Analytics Warehouse.
Note:Be sure that you see the login page. If you're automatically logged in to your Analytics Warehouse instance, you need to sign out to see the NetSuite Analytics Warehouse Login page and complete the following step.
-
Copy the login page URL from https:// up until oraclecloud.com, then add /oauth2/v1/social/callback at the end (for example, https://idcs-39681a0d2c9d40e486d5cbfec8e8aaab.identity.oraclecloud.com/oauth2/v1/social/callback). Save this URL for later and keep this tab open.
-
Go to Setup > Integration > Manage Integrations > New. For more information, see Creating an Integration Record.
-
Enter a name for the integration record.
-
Clear the TBA: Authorization Flow and Token-based Authentication boxes.
-
In the Redirect URI field, paste the URL you have created in step 2.
-
Click Save.
Important:Don't close the integration record page until you've completed all steps in this section. You need information from this page to finish the setup.
To set up OIDC SSO for NetSuite Analytics Warehouse:
-
Open a new tab. Go to Setup > Integration > Configuration and click Log in to NetSuite Analytics Warehouse.
-
Click Authentication.
-
Select Enable SSO.
-
Select OIDC (OpenID Connect) as the IdP type.
-
In the Authentication System Settings section, enter the following information:
-
Go to the integration record page. Copy the Consumer Key / Client ID and paste it in the Client ID field.
-
Go to the integration record page. Copy the Consumer Secret / Client Secret and paste it in the Client Secret field.
-
In another tab, open NetSuite, go to Setup > Integration > NetSuite as OIDC Provider Setup, and copy the Metadata URL. Then go back to the NetSuite Analytics Warehouse tab and paste it in the Discovery service URL field.
-
-
Click Save.
To set up and enable the roles:
-
In NetSuite, go to Setup > Users/Roles > Manage roles.
-
Create a new role or find the one you want to enable OIDC SSO for, then click Customize or Edit. For more information, see Customizing and Creating Roles.
-
Go to the Permissions subtab and select the Setup sublist.
-
Add the following permissions to the role:
-
REST Web Services
-
Login using OAuth 2.0 Access Tokens
-
-
Click Save.
-
Assign this role to the employees you want to give OIDC SSO access to. For more information, see Assigning Roles to an Employee.
-
Go to Setup > Integration > NetSuite as OIDC Provider Setup.
-
Click the integration record you have created previously.
-
Click the Entities tab. In the Employees box, select the employees you want to give SSO access to and move them to the Selected Employees box.
-
Click the Roles tab. In the Roles box, select the roles you set up earlier and move them to the Selected Roles box.
-
Click Save.