Let Oomnitza be your single source of truth!
You'll get complete visibility of your users as data from NetSuite is automatically transformed into consumable information and actionable insights.
Connect Oomnitza and NetSuite in minutes
Get the information and insights that you need to reduce costs and the time that you spend on administration tasks such as:
- Configurable dashboards and list views of key user information
- Configurable reports to share information about users with your colleagues and management
- Workflows that can be easily created such as
- Workflows for deleting NetSuite users
- Workflows for getting a NetSuite user's details and updating NetSuite users
- Workflows for getting a SaaS user's role and deactivating SaaS users in Oomnitza
Contents
Useful links
REST Web Services Prerequisites and Setup
Setting up REST Web Services with OAuth 2.0 in your NetSuite Account
Before you start
To stream NetSuite user data into Oomnitza, you add OAuth 2.0 credentials to the credentials vault in Oomnitza.
Configure NetSuite
Before you create the integration with Oomnitza, complete the following tasks in NetSuite:
Create OAuth 2.0 client app
-
-
As administrator, log in to your NetSuite account .
- From the menu, click Setup > Integration > Manage Integrations > New.
- Make the following changes:
- Enter the name of the OAuth 2.0 client.
- Set State to enabled.
- Set the Authorization Code Grant to true.
- Set REST Web Services to true.
- Enter the callback URL:
https://generic-oauth2-proxy.oomnitza.com/oauth2/redirect_url
- Save your changes.
-
Remember
Copy your consumer Key (client ID) and consumer secret (client secret). You'll need this information to add your credentials to Oomnitza.
Enable SuiteCloud features
- From the menu, click Setup > Company > Enable features > and click the Analytics tab.
- In the SuiteAnalytics section, select SUITEANALYTICS WORKBOOK.
- Click the SuiteCloud tab and enable the following services:
- In the SuiteScript section, enable CLIENT SUITESCRIPT and SERVER SUITESCRIPT.
- In the SuiteTalk (Web Services) section, enable REST Web Services.
- In the Manage Authentication section, enable OAUTH 2.0.
Enable analytics
- From the menu, click Setup > Company > Enable features.
- Click the Analytics tab.
- In the SuiteAnalytics section, enable SUITEANALYTICS WORKBOOK.
Enable role permissions
- Click Setup > Users/Roles > Manage roles.
- On the Manage Roles page, select your role and then click Edit.
- Scroll down, and click the Permissions > Reports and then add SuiteAnalytics Workbook.
- Select Permissions > Setup > Add Custom Fields(View), Custom Record Types(View), and enable the following permissions:
- Log in using OAuth 2.0 Access Tokens
- REST Web Services
- Log in using Access Tokens
Add your NetSuite subdomain (account ID) as a global variable
To save time when you create workflows, you can enter the subdomain of your NetSuite instance as a global variable.
- Click Configuration > General > Global Settings.
- Click Add new variable (+).
- Enter Netsuite.Subdomain as the key.
- Enter your NetSuite account ID as the subdomain. Let's say the URL to your instance is
https:// 123456 .app.netsuite.com
. In this example, your account ID is 123456. - Click SAVE.
Add credentials to the vault in Oomnitza
To add your NetSuite credentials to Oomnitza, you'll need the following information:
- Your NetSuite client ID and secret.
- Your NetSuite account ID .
- Log into Oomnitza.
- Click Configuration > Security > Credentials, and then click Add new credential (+).
- On the INFORMATION tab, complete these actions:
- Add the name of the credential such as NetSuite Users.
- Add the name of the owner.
- On the AUTHORIZATION tab, complete these actions:
- As authorization type, select 0Auth 2.0.
- From the SaaS list, select NetSuite.
- Enter your client ID.
- Enter your client secret.
- Enter your subdomain.
- Click Authenticate.
- Click CREATE.
NetSuite Restriction
The authorization token that you get from NetSuite expires in seven days. When the NetSuite token expires, you get an invalid_grant error when the integration is run. To resolve this issue, open the credentials that you added, click the AUTHORIZATION tab, click REFRESH, and click Save. Then, run the integration manually.
Next
You use the credentials that you added to create and customize your NetSuite integrations with Oomnitza.
Create the user integration
Info and connect details
- Click Configuration > Integrations and then click Integrations List View
.
- On the Integrations page, scroll down to the Extended section for User Integrations.
- Click NEW INTEGRATION.
- In the New User Integration sidebar, click NetSuite.
- Click APPLY next to NetSuite User Load and then click NEXT twice.
Connect page
Best practice
To ensure that only live user records are streamed from NetSuite to Oomnitza, choose Update only as your integration preference. When you run the integration, you can check the error logs to see which user records weren't uploaded and why they weren't uploaded. You can then decide whether to upload the user records that were skipped by changing your integration preference to create and upload. See Access error logs.
- Enter a descriptive name for the integration such as NetSuite Users. That'll be the name of the user integration that is shown on the Integrations page.
- From the User Selection list, select User plus SaaS User or User only.
- If you select User plus SaaS User and you have multiple instances of the same SaaS application, select the application from the SaaS Selection list. If you have a single instance of the SaaS application, skip this step.
- From the installation type list, select Cloud.
- From the Credentials list, select the credentials for NetSuite.
- From the Integration Preferences list, select Update only.
- Enter the name of the user of the integration.
- Enter your subdomain.
- Click Next.
Custom NetSuite to Oomnitza mappings
The following NetSuite fields can be mapped to Oomnitza:
Access to NetSuite
Connector Sync Time
Created at
Email
Entity Id
First Name
Hire Date
Id
Is Inactive
Is Job Manager
Is Job Resource
Is Sales Representative
Is Support Representative
Last Name
Middle Name
Require Password Change
Termination by Death
Updated at
Was Employee Center has Access
Was Full User has Access
Was Inactive
Was Retail User has Access
Want to map more fields to Oomnitza?
Contact Support, or see Mapping extended connectors.
Mappings
Map the NetSuite fields to Oomnitza fields and create custom mappings to get the user information that you need.
Complete these actions:
- Click SMART MAPPINGS.
- Complete these steps to map NetSuite fields to Oomnitza.
-
- Click the down arrow on the field that you want to map.
- Select Add new Oomnitza users field.
- Change the name of the field.
- Click CREATE.
-
- To create workflows, you must map the ID field to NetSuite User ID. To do this, complete these steps:
- Click the down arrow on the Id field.
- Select Add new Oomnitza users field.
- Change the name of the field to NetSuite User ID.
- Click CREATE.
- Assign an Oomnitza role to the users such as Employee.
- Assign a sync key to one of the fields such as the Email field.
- Click NEXT.
Schedule
Remember
Because NetSuite tokens expire in seven days, refresh your token before you run the integration. See NetSuite restriction.
By default, NetSuite user data is streamed to Oomnitza once every day.
You can configure the schedule to meet your needs such as changing the interval or changing the time so that the data is streamed when your system isn't busy.
- Configure your schedule.
- Click FINISH.
Result
A new tile is created for the integration on the Integrations page.
What to do next
If you want to see what information is collected now, click the tile on the Integrations page and click RUN.
Figure: Mock-up for illustration purposes
If you want to change the integration settings, you can click a navigation link on the page, such as 4 Mappings, and edit the settings.
Create workflows
Use API presets to create workflows
To reduce your workload and automate complex and repetitive tasks, you can use the following API presets:
- Click Configuration > Workflows > SaaS Users.
- Click Add (+). The Begin and End blocks are automatically added to the sandbox.
- Enter the name and a description of the workflow.
- Edit the Begin block by choosing a schedule and adding the rules that will trigger the workflow. For example, add the rule Name equals NetSuite, and a rule to trigger the workflow.
- Click the Blocks tab, and drag and drop the API block onto the canvas.
- Click the Edit button.
- Enter NetSuite in the search field and and choose one of the following presets:
- NetSuite Delete Users.
- NetSuite Get User Details
- NetSuite Update User
- Click SAVE.
- Connect the blocks.
- Validate, launch, and save your workflow.
Information required for API workflows
For NetSuite Delete User and Get User Details, you must select your NetSuite credentials and enter your NetSuite subdomain.
For NetSuite Update User, you must select your NetSuite credentials, enter your NetSuite subdomain, and provide the following information:
Field | Values |
Is Inactive | true or false |
Is Job Manager | true or false |
Is Job Resource | true or false |
Is Sales Representative | true or false |
Is Support Representative | true or false |
Middle Name | User's middle name |
Require Password Change | true or false |
Send Email | true or false |
Termination by Death | true or false |
YYYY-MM-DD | Date, which must be in the format specified. |
Use the SaaS User Role Retrieval block to create workflows
- Click Configuration > Workflows > SaaS Users.
- Click Add workflow (+). The Begin and End blocks are automatically added to the canvas.
- Enter the name of the workflow and a description.
- Edit the Begin block.
- Create a schedule for running the workflow.
- Use a rule to identify the SaaS software
- Add rules to trigger the workflow . For example, you can add a rule to deactivate users who haven't logged in for a number of days.
- Click SAVE.
- From the Integrations section, drag and drop the SaaS User Role Retrieval block onto the canvas.
- Edit the SaaS User Role Retrieval block.
- To find the preset, type NetSuite.
- Click the right arrow (>) next to NetSuite User Role.
- Select your NetSuite credentials and enter your NetSuite subdomain.
- Connect the workflows.
- Validate, save, and launch the workflow.
Unleash the power of Oomnitza
To get valuable actionable insights that help you manage your assets, learn how to:
- Configure dashboards for your users and software
- Configure custom reports about your users and software
- Create workflows to automate tasks
Comments
0 comments
Please sign in to leave a comment.