Oct 19, 2023
Oracle NetSuite is the leading integrated cloud business software suite, including business accounting, ERP, CRM and ecommerce software.
The schema information shows all report types you can use to extract data from Oracle NetSuite.
Follow our setup guide to connect Oracle NetSuite to Improvado.
Step 1. Click the Data Sources in the left navigation bar.
Categories on the Data sources page group all available platforms. Use a search to find the required one.
Step 2. Click on the Oracle NetSuite tile.
Step 3. To authorize your account, you need to fill in the required fields below following steps 3.1 - 3.9:
Step 3.1. Login into your Oracle NetSuite account.
Step 3.2. Go to Setup > Company > Company Information.
Step 3.3. Copy your Account ID (Realm) and Account Name.
Step 3.4. Enable features.
Step 3.5. Create Integration (obtain Consumer Key and Consumer Secret).
Step 3.6. Setup Role.
Important: Please edit these params again when you rename or customize any Object in Oracle NetSuite for ```improvado-integration-role``` to reflect such changes.
Step 3.7. Setup User.
Step 3.8. Create Access Token for the role.
Step 3.9. Enter copied values into the Improvado authorization form.
Also, you can find the additional information here: Oracle NetSuite Applications Suite - SuiteTalk REST Web Services API Guide.
Step 4. After completing the connection process, the Oracle NetSuite connection will appear in your Connected sources list.
Step 5. When the connection status is Active, and the account status column shows a number of accounts, you can move on to data extraction.
Step 6. To extract data from the connected sources, check the instruction on how to set up data extraction.