How to Connect to NSAW ADW Using SQL Developer or VS Code

If you're looking to connect directly to your NetSuite Analytics Warehouse (NSAW) database using tools like Oracle SQL Developer or the SQL Developer extension for Visual Studio Code, you'll first need to download the Oracle Cloud Wallet. This guide walks you through the steps to download the wallet and connect using any of these tools.

---

Step 1: Downloading the Oracle Cloud Wallet from NSAW

1. Log in to your NSAW Admin Console. The URL will typically end in /ui/oax/ .
2. From the main menu under Service Administration , click Warehouse .
3. On the Warehouse page, click Download Wallet .
4. When prompted to set a password:
   • You can leave the password field blank if you don’t want to set one.
   • For this example, we’ll use a simple password like test (not recommended for production).

5. Move the downloaded .zip file to a permanent location outside your Downloads folder so your SQL tool can reference it easily.

First-Time Password Setup

If this is your first time connecting as an organization, you’ll need to set passwords for the admin and oax_user accounts.

Important: These are shared credentials across your org. If someone has already set them, do not reset them — doing so could lock out teammates.

How to Reset the Passwords

For admin :

1. In the NSAW Admin Console, go to Service Administration > Warehouse .
2. Under the ADW Wallet section, click Reset Credentials .
3. Select admin , set a password, and submit.

For oax_user :

In older releases, log in as admin and run this SQL command:

ALTER USER oax_user IDENTIFIED BY your_password_here;

In release 25.R3 and later, you can reset oax_user the same way — just choose it from the dropdown under Reset Credentials .

Once these are set, you can move on to connecting with your SQL tool of choice.

Connect with Oracle SQL Developer

1. Download SQL Developer from the Oracle Website
2. Unzip the downloaded file and move the folder to a permanent location.
3. Launch SQL Developer by running sqldeveloper.exe .
4. Open the Connections panel (View > Connections if it’s not already visible).
5. Click the green + icon to add a new connection.
6. Fill in the following fields:

• Connection Name: e.g., admin or oax_user
• Username: Your user (e.g., oax_user)
• Password: The password you set in the admin console
• Check Save Password to avoid retyping each time

7. For Connection Type , choose Cloud Wallet .
8. Under Configuration File , click Browse and select the downloaded .zip wallet file.
9. Select the _high service entry (this is the default).
10. Click Test to ensure everything is working, then click Save .
11. Open the connection and launch a worksheet.

Connect with the SQL Developer Extension for VS Code

If you prefer using Visual Studio Code, Oracle offers an official SQL Developer extension that works natively.

1. Open VS Code and go to the Extensions panel.
2. Search for Oracle SQL Developer for VS Code and install the official extension.
3. Look for the database icon (stacked cylinder) on the left sidebar and click it.
4. In the SQL Developer panel, you’ll see a Connections section.
5. Hover over Connections and click the + icon to add a new connection.
6. Fill out the connection form:

• Connection Name: e.g., admin or oax_user
• Username: e.g., oax_user
• Password: The password you set in the admin console
• Connection Type: Cloud Wallet
• Wallet Location: Browse to the downloaded .zip wallet

7. Save the connection and click to open a worksheet.