Note: All requested values can be shared using the spreadsheet included with your welcome email.
Instructions are included in the spreadsheet.

Hyperlinks are included for most steps. These will take you to the relevant pages in your Azure portal.

🔧Azure Environment Setup Overview (Managed Data Warehouse)

This guide walks you through setting up your Azure environment so ZoneReporting can securely transfer data from NetSuite to your managed data warehouse. 

✅What You Will Do:

1. Register a Client Application
   Create an enterprise application that allows secure data transfer between NetSuite and your managed data warehouse.

Prerequisites:

• This document will cover the Azure setup for Managed Data Warehouse
• Ensure that the user completing the setup is using an account that has Office 365 or Azure tenant administrator privileges.

1. Create Client Application

1. 1. Navigate to https://portal.azure.com
      
      • From the home screen, click on App registrations. If you don't see this option, type 'App registrations' into the search bar.
        
        
        
        
   2. From this screen, we’ll register an app that enables data to flow from NetSuite to an Azure Blob Storage container.
      
      • Click on + New Registration
        
        
        
        
   3. On the Register an Application screen, complete the following three steps:
      
      • In the Name field, enter a name for the app — we recommend something like ZoneReporting.
      • In the Redirect URI section, select 'Web' from the dropdown menu, then enter http://localhost in the provided field.
        
        
        
        
   4. Click Register
   5. Copy and paste the Application (client) ID and the Directory (tenant) ID values into your Azure setup checklist. 
      
      
      
      
   6. In the left-hand menu, click Certificates & Secrets, then select + New client secret. Name it appropriately and set the expiration — we recommend 24 months, or follow your organization's policy.
      
      
      
      
   7. Click Add
   8. Copy and paste the secret Value into your Azure setup checklist.  
      • IMPORTANT: Copy the secret Value, not the Secret ID.
        
        
        
        
   9. Once you navigate away from this screen, the secret value cannot be retrieved. If you lose it, you’ll need to generate a new secret.

Note: If you lose the secret value, you can create a new one by repeating the steps above.

Please use the spreadsheet included with your welcome email to share the requested values with your ZoneReporting implementation team. Instructions for secure sharing are include with your welcome email.