Skip to main content

Connecting to ADW in Oracle NetSuite Analytics Warehouse

Using Oracle Autonomous Data Warehouse with NetSuite Analytics Warehouse

Introduction

The wallet is a .zip file that contains credentials necessary to connect to the Oracle Autonomous Data Warehouse (ADW) instance associated with NetSuite Analytics Warehouse (NSAW). This blog post will guide you on how to use it effectively.

Downloading the Wallet

The wallet file is downloaded from the NSAW Console, under the Warehouse tile. The wallet.zip file will be downloaded to your local computer, ready for use.

Connecting to ADW in Oracle SQL Developer

The wallet file plays a crucial role in establishing a connection to the ADW instance in Oracle SQL Developer. Here are the steps:

  1. When creating a new connection in Oracle SQL Developer, set the connection type to "Cloud Wallet".
  2. Use the wallet.zip file as the Configuration File.
  3. The wallet file, along with the ADMIN user and the password set using Reset Credentials on the same screen in NSAW, are used to access ADW.

    4. Connecting to ADW in OAC

    To create a direct connection to the ADW instance from Oracle Analytics Cloud (OAC) within NSAW, the wallet.zip file is required. Follow these steps:

    1. When creating a new connection, select "Oracle Autonomous Data Warehouse" as the connector type.
    2. Upload the wallet.zip file. The cwallet.sso file will be auto-populated from the wallet.
    3. Enter the admin password set using the Reset Credentials function in NSAW.

    Security

    The wallet file and the associated admin user/password provide access to the ADW instance, so it should be stored securely. It is important to share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users, the wallet password should be transmitted separately and securely.

    OAX_USER Connection

    After the initial connection to the ADW with the wallet using the ADMIN user, it is necessary to set the password for the OAX_USER using the following SQL command: ALTER USER OAX_USER IDENTIFIED BY <new_password>. This will ensure that all tables will be created under the OAX_USER node and not under the ADMIN node when persisting the data into the data warehouse. The connection to the ADW in OAC can then be made using the OAX_USER credentials and the same wallet file.

    Reach out to us at support@dataants.org to get help with your NetSuite Analytics Warehouse implementation or maintenance

Labels:

Comments

Post a Comment

Popular posts from this blog

NetSuite Workflows tips and tricks as an experienced Admin

NetSuite Workflows tips and tricks as an experienced Admin Summary: NetSuite Workflows allow admins to automate tasks, manage approvals, and control user interfaces. Essential elements include actions, triggers, and states. Sub-workflows can simplify complex workflows, and are reusable across multiple parent workflows. Workflows can sometimes be slow, especially with large data sets; using server-side scripts, limiting actions and states, and using scheduled scripts can optimize performance. Debugging workflows can be facilitated with the SuiteScript API and the "Show Workflow History" feature. SuiteFlow allows workflow creation without coding. Best practices include planning workflows in advance, testing in a sandbox environment, and using descriptive names for easier understanding. NetSuite Workflows Tips and Tricks for an Experienced Admin NetSuite Workflows are a powerful tool for any admin looking to improve business processes. They allow yo...
Post a Comment
Read more

Latest Features in NetSuite Analytics Warehouse 2025.1

  The Latest Features in NetSuite Analytics Warehouse (NSAW) At DataAnts , we pride ourselves on empowering NetSuite customers to harness the full potential of their data using NetSuite Analytics Warehouse (NSAW). As Oracle continuously enhances NSAW, staying up-to-date with its latest features ensures businesses can take full advantage of its powerful analytics capabilities. Here's a rundown of the most recent updates to NSAW and how they can elevate your business intelligence strategies. 1. Enhanced Data Integration Capabilities The latest update introduces improved connectors for third-party applications. Businesses can now integrate data from Salesforce, Shopify, and more directly into NSAW. This expanded integration eliminates the need for external ETL processes, reducing data silos and enabling unified reporting across platforms. 2. AI-Driven Insights NSAW now features advanced AI-powered tools that automatically identify patterns and trends within your data. These insights i...
Post a Comment
Read more

SuiteScript tips and tricks as an expert NetSuite developer

SuiteScript tips and tricks as an expert NetSuite developer Summary: This blog post provides advanced tips for NetSuite developers working with SuiteScript. It explains the benefits of SuiteScript 2.0 and 2.1, such as improved code organization and support for modern JavaScript features. It recommends using Map/Reduce scripts for large data sets and promises for asynchronous actions. The post highlights the importance of testing scripts before deployment, suggesting the use of NetSuite's Script Debugger tool and automated testing tools. The key to mastering SuiteScript, it concludes, is practice and learning from mistakes. SuiteScript Tips and Tricks for NetSuite Developers As a seasoned NetSuite developer, you already know that SuiteScript is a powerful tool for customizing your NetSuite account. However, there are always new features, best practices, and tricks to learn. In this blog post, we'll explore some tips that can make your SuiteScript de...
Post a Comment
Read more