Verifying Data in Oracle Analytics

Steps to verify if the data has been copied from your NoSQL table to the Autonomous Database in ADW.

Verify the data in the Oracle Autonomous Database

After executing the Oracle NoSQL Database Analytics Integrator to copy the data from your NoSQL table to the Autonomous Database in ADW, you can verify that the NoSQL table data has been copied correctly by executing the following steps from the Oracle Cloud Console:

• Select Oracle Database from the menu on the left side of the display.
• Select Autonomous Data Warehouse.
  
  
  Description of the illustration oci-orcldb.png
  
  
• Select the Compartment in which the database is located.
• Click on the link with the display name you entered when creating the database.
  
  
  Description of the illustration adb-displayname.png
  
  
• Click Service Console.
  
  
  Description of the illustration adb-serviceconsole.png
  
  
• Select Development from the menu on the left side of the display.
  
  
  Description of the illustration adb-dbactions.png
  
  
• Select Database Actions and login to the database; for example,
  • Username: ADMIN
  • Password: <password-set-during-database-creation>
  
  
  
  Description of the illustration dbactions-login.png
  
  
• Select the item SQL.
  
  
  Description of the illustration dbactions-sqlsheet.png
  
  

From the Navigator tab of the window on the left of the display, first, verify that the table you created appears in the list of tables contained in the database. If it does, then from the Worksheet* window execute the SQL query,

SELECT * FROM <table-name>;

Verify that the expected contents of the table are displayed in the window in the center bottom of the display, under the window Query Result.

Verify the data in Oracle Analytics

After verifying that the Oracle NoSQL Database Analytics Integrator successfully copied the data from the example table in the NoSQL Cloud Service to a corresponding table in the database you created in Autonomous Data Warehouse, you can then connect Oracle Analytics to that database and verify that Oracle Analytics can access and analyze the data in that table. In the section below, Oracle Analytics Desktop is used to demonstrate how this can be done. But if you have access to an Oracle Analytics Cloud instance, you should be able to verify the data using similar functions.

Download Oracle Analytics Desktop:

Oracle Analytics Desktop provides standalone data exploration and visualization in a per-user desktop download. Oracle Analytics Desktop is the tool for quick exploration of sample data from multiple sources or for analysis and investigation of your own local datasets.

You can download the Oracle Analytics Desktop here.

After executing the Oracle Analytics application in your environment, you can invoke the graphical user interface to create a connection to the database in Autonomous Data Warehouse and access the database in Autonomous Data Warehouse.

Create a Connection to the Database in Autonomous Data Warehouse:

• Open the GUI for Oracle Analytics Desktop and click Create.
• Click Connection and then choose Oracle Autonomous Data Warehouse.
  
  
  Description of the illustration analytics_utility_conn.png
  
  
  
  
  Description of the illustration anal_uti_db_type.png
  
  
• In the pop-up window that appears, enter the following information:
  • Connection Name: <name of the database>
  • Client Credentials: <path-to-wallet.zip>
  • Username: ADMIN
  • Password: <password-set-during-database-creation>
  
  
  
  Description of the illustration anal_util_conn_det.png
  
  
• Click on Save.

Note:

For Client Credentials, when you enter the path to the wallet zip file, the tool will extract the file cwallet.sso and replace what you entered with that file’s name. Finally, once you enter the Connection Name, the tool will automatically enter a value for Service Name that is based on what was entered for Connection Name.

Access the Database in Autonomous Data Warehouse

After creating the connection to the database in ADW, you can then connect to that database from the Oracle Analytics GUI:

• Click on Data.
• Click on the icon with the connection name.
  
  
  Description of the illustration anal_util_selectdb.png
  
  
• Click ADMIN.
• Scroll down the list of tables and select the table you copied from NoSQL Database Cloud Service.
  
  
  Description of the illustration anal_util_viewtable.png
  
  
• Click Add to Data Set. Verify the data displayed is what you expect.

Your data is now ready to be analyzed using all of the facilities provided by Oracle Analytics.

---

Title and Copyright Information

Verifying Data in Oracle Analytics

Copyright ©2022,

Oracle and/or its affiliates.