The Autonomous Data Warehouse Wallet contains certificate keys for accessing your Autonomous Data Warehouse instance.

Administrator credentials allow you to access and manage your Autonomous Data Warehouse. You can reset the ADMIN user's credentials, but if you reset the password, that might affect other users who log in as ADMIN.

1. Sign in to NetSuite Analytics Warehouse.
2. In Oracle NetSuite Analytics Warehouse Console, click Warehouse.
3. On the Warehouse page, under Reset Autonomous Data Warehouse Credentials, click Reset Credentials.
4. In Reset Credentials, select ADMIN in Username, provide and confirm the new password, and click Update.
   
   

   

   
   

The Autonomous Data Warehouse Wallet contains certificate keys for accessing your Autonomous Data Warehouse instance.

1. Sign in to NetSuite Analytics Warehouse.
2. Click Warehouse on the Console.
3. On the Warehouse page, under ADW Wallet, click Download Wallet.
4. In the Set Wallet Password dialog, provide a password to encrypt the keys inside the wallet, then click Download.
   For more information about wallet contents, see About Autonomous Data Warehouse Wallet and Administrator Credentials.

   Note:

   Wallet files, along with the database user ID and password, provide access to data in your Autonomous Data Warehouse. Store wallet files and the wallet password in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), then transmit the wallet password separately and securely.

You need to locate the URL for Database Actions to be able to reset the OAX_USER's password.

1. Unzip the downloaded wallet file, and open the README file in a text editor.
2. Find and copy the URL ending with /sql-developer listed in the Database Actions section of the README file.
3. Paste the URL in a browser, then sign in to the Database Actions web page.

You need to reset the password for the OAX_USER before creating a connection to an Autonomous Data Warehouse.

1. Sign in to NetSuite Analytics Warehouse.
2. In Oracle NetSuite Analytics Warehouse Console, click Warehouse.
3. On the Warehouse page, under Reset Autonomous Data Warehouse Credentials, click Reset Credentials.
4. In Reset Credentials, select OAX_USER in Username, provide and confirm the new password, and click Update.
   
   

   

   
   

Verify proper configuration of your Autonomous Data Warehouse connection by running a sample query.

1. Sign in to Database Actions as OAX_USER.
2. On the Development tab, click the SQL label to open SQL Developer Web. Select All Objects in the Objects dropdown.
   You should see all objects for OAX USER in the Navigator.
3. Run this query to verify proper configuration:

   select * from DW_NS_ACCOUNT_D

Verify proper configuration of your Autonomous Data Warehouse connection by running a sample query.

1. Sign in to Database Actions as ADMIN.
2. On the Development tab, click the SQL label to open SQL Developer Web.
3. Run this query to verify proper configuration:

   select sum(bytes)/1024/1024/1024/1024 as USED_STORAGE_TB from dba_segments
         where owner not in ('SSB', 'SH');

You can connect to an Autonomous Data Warehouse with Oracle Analytics Cloud.

1. Sign in to your NetSuite Analytics Warehouse instance.
2. Click Go to Home Page.
3. Click Navigator and then Data.
4. Click the Connections tab.
5. On the Oracle Analytics page, click Create, click Connection, then click Oracle Autonomous Data Warehouse.
6. Enter these values and then click Save:
   1. Connection Name: ADW - OAX_USER
   2. Description: ADW - OAX_USER
   3. Client Credentials: Click Select, then browse to select the wallet.zip file.
   4. Username: OAX_USER (default)
   5. Password: The OAX_USER password.
   6. Service Name: Select <service name>-low. Using low prevents pipeline conflicts.
7. In the Connections tab, click the ellipsis icon to the right of the name of the connection you just created to open the Actions menu and click Inspect.
8. Click Access and then Roles.
9. Type ServiceAdmin in the Search By Name field, then click to add it.
10. Click the Full Control radio button for the ServiceAdmin user.
11. Click Save and then Close.

Verify proper configuration of your Oracle Analytics Cloud connection to the Autonomous Data Warehouse by creating a basic dataset.

You can use the SQL Developer desktop client to connect to Autonomous Data Warehouse. However, this connection method is optional, and using Database Actions (SQL Developer Web) is the preferred method.

1. Launch SQL Developer.
2. In the Connections pane, click New Connection.
3. Create an SQL Developer connection for the ADMIN user by setting the following values in the New/Select Database Connection dialog:
   1. Define a Name for the connection, such as PROD_ADMIN.
   2. Set the Username to ADMIN.
   3. Enter the password for the ADMIN user.
   4. Set the Connection Type to Cloud Wallet.
   5. For the Configuration file, click Browse and select the wallet.zip file.
   6. Service: Select <service name>-low. Using low prevents pipeline conflicts.
   7. When connecting with a virtual private network (VPN), enter details in the Proxy tab.
   8. Click Test to validate the connection.
   9. Click Save.
   10. Click Connect.
4. Run this query to verify proper configuration:

   select sum(bytes)/1024/1024/1024/1024 as USED_STORAGE_TB from dba_segments
         where owner not in ('SSB', 'SH');

You can use the SQL Developer desktop client to connect to Autonomous Data Warehouse.

1. Launch SQL Developer.
2. In the Connections pane, click New Connection.
3. Create an SQL Developer connection for OAX_USER. Set the following values in the New/Select Database Connection dialog:
   1. Define a Name for the connection, such as PROD_OAX_USER.
   2. Set the Username to OAX_USER.
   3. Enter the password for OAX_USER.
   4. Set the Connection Type to Cloud Wallet.
   5. For the Configuration file, click Browse and select the wallet.zip file.
   6. Service Name: Select <service name>-low. Using low prevents pipeline conflicts.
   7. When connecting with a virtual private network (VPN), enter details in the Proxy tab.
   8. Click Test.
   9. Click Save.
   10. Click Connect.
4. Expand Synonyms to see all of the prebuilt synonyms for OAX_USER.
5. Run this query to verify proper configuration:

   SELECT * FROM DW_CUSTOMER_LOCATION_D