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

If you need direct database access to your NetSuite Analytics Warehouse (NSAW), connecting through tools like Oracle SQL Developer or the SQL Developer extension in Visual Studio Code is a reliable approach. 

Before you can connect, you must download the Oracle Cloud Wallet from your NSAW Admin Console. This blog walks you step-by-step through downloading the wallet, setting credentials (if required), and connecting using either SQL Developer or VS Code. 

Why You Need the Oracle Cloud Wallet 

The Oracle Cloud Wallet contains the secure credentials and configuration files required to establish a connection to your Autonomous Data Warehouse (ADW) instance inside NSAW. Without it, your SQL tools cannot authenticate or connect securely. 

Download the Oracle Cloud Wallet from NSAW 

Start by accessing your NSAW Admin Console. 

1. Log in to your NSAW Admin Console (URL typically ends with /ui/oax/). 

2. Navigate to Service Administration.

3. Click on Warehouse. 

4. Select Download Wallet. 

During the download process, you may be prompted to set a password: 

• You can leave it blank if preferred. 

• For testing environments, you may use a simple password (not recommended for production). 

Once downloaded, move the .zip wallet file to a permanent directory outside your Downloads folder. This ensures your SQL tool can reliably reference the file. 

First-Time Setup: Configuring User Passwords 

If this is your organization’s first database connection attempt, you may need to configure passwords for shared database users: 

• admin 

• oax_user 

Important: These credentials are shared across your organization. If they have already been configured, do not reset them unless necessary. 

How to Reset Credentials (If required) 

Resetting the Admin User 

1. Go to Service Administration → Warehouse in the NSAW Admin Console. 

2. Under the ADW Wallet section, click Reset Credentials. 

3. Select admin, assign a password, and submit. 

Resetting the oax_user 

For older NSAW releases: 

• Log in as admin and run: 

For release 25.R3 and later: 

• Use the Reset Credentials option. 

• Select oax_user and set the password directly from the console. 

Once credentials are properly configured, you’re ready to connect. 

Connecting to NSAW Using Oracle SQL Developer 

Oracle SQL Developer is one of the most common tools used for direct ADW connections. 

Install SQL Developer 

1. Download Oracle SQL Developer from Oracle’s website. 

2. Unzip the file. 

3. Move it to a permanent folder. 

4. Launch using sqldeveloper.exe. 

Create a New Connection 

1. Open the Connections panel (View → Connections if hidden). 

2. Click the green + icon to create a new connection. 

3. Enter the following details: 

• Connection Name: admin or oax_user 

• Username: oax_user (or admin) 

• Password: Your configured password 

• Enable Save Password if desired 

• Connection Type: Cloud Wallet 

• Configuration File: Browse to the downloaded wallet .zip file 

• Select the _high service option (recommended default) 

4. Click Test to verify the connection. 

5. Click Save. 

6. Open the connection and launch a worksheet to start querying. 

Connecting to NSAW Using VS Code 

If you prefer working in Visual Studio Code, Oracle provides an official SQL Developer extension. 

Install the SQL Developer Extension 

1. Open Visual Studio Code. 

2. Go to the Extensions panel. 

3. Search for Oracle SQL Developer for VS Code. 

4. Install the official Oracle extension. 

Create a Connection in VS Code 

1. Click the database icon in the left sidebar. 

2. In the SQL Developer panel, find the Connections section. 

3. Click the + icon to add a new connection. 

Enter the following details: 

• Connection Name: admin or oax_user 

• Username: oax_user 

• Password: Your configured password 

• Connection Type: Cloud Wallet 

• Wallet Location: Browse to your downloaded wallet .zip file 

Save the connection and open a worksheet to begin querying your NSAW database. 

Best Practices for a Smooth Connection 

• Store your wallet file securely. 

• Avoid resetting shared credentials unnecessarily. 

• Use strong passwords in production environments. 

• Select the _high service for most standard analytics workloads. 

• Keep a backup of the wallet in a secure location. 

Final Thoughts 

Connecting to NSAW ADW through SQL Developer or VS Code is straightforward once the Oracle Cloud Wallet is downloaded and credentials are configured correctly. 

With secure authentication in place, you can run queries, build reports, and perform advanced analytics directly against your NetSuite Analytics Warehouse database.