Avatar Data Warehouse Update 24

Product Requirements / Recommendations

Avatar Data Warehouse required
Avatar PM required
RADplus required
Avatar Cal-PM

Recommended Update Level

RADplus 2023 Update 4

Product Update Form Description

Avatar Data Warehouse is prepared for future functionality.

Included Updates

2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 11.1, 12, 13, 13.1, 14, 15, 16, 17, 18, 19, 20, 21, 23

Required Updates

None

Details

NEW1 CHANGED0 FIXED0

New (1)

AV-84659 Details \| User Acceptance Tests Avatar Data Warehouse - IRIS "Avatar Data Warehouse" has been updated to support "IRIS" integration. Please Note: Full functionality requires "Avatar Data Warehouse Middleware v2023.1.001_iris" and "RADplus 2023 Update 4" Value Added: Supports the ability to run Data Warehouse processing on "IRIS" systems	Topics • Data Warehouse

Acceptance Tests

AV-84659 Summary | Details

Avatar Data Warehouse - IRIS

Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:

Scenario 1: Data Warehouse Processing (IRIS)- Table row validations

Specific Setup:

Have Avatar database server set up that is running on "IRIS" based system that's configured with the parent namespace and one or more child namespaces
Have a server installed with the latest released version of "Avatar Data Warehouse Middleware" for "IRIS".
Netsmart has been configured the middleware to initiate the data warehouse process
Have a "Microsoft SQL Server" where table data processed by the data warehouse process will be stored
Have a database program that can query the data in the tables stored on the data warehouse server. For example program "DBeaver Universal Database Manager" or "Crystal Reports"
In form "User Definition", a user had been created [AvatarDW] as the designated data warehouse user.
[AvatarDW] has been assigned permissions to tables determined to be included in the data warehouse process, that includes tables selected in parent namespace and in any child namespaces
In form "Data Warehouse Transient Comparison Configuration", the designated data warehouse user [AvatarDW] has the designated tables selected in previous selected in "Mark Tables for Full Load" section
Have a report or query that will display data in the "SYSTEM.dss_inc_error_log" table
Have a report or query that will display data in the "SYSTEM.dss_inc_full_load_history" table
Netsmart has run "Data Warehouse Middleware" process on the middleware server, in the parent namespace and each child namespace

Steps

Generate the report to display data in the "SYSTEM.dss_inc_error_log" table
Validate there are no results indicating the data warehouse middleware process has completed successfully
Generate the report to display data in the "SYSTEM.dss_inc_full_load_history" table
Validate the expected data rows are present on the report for the parent and child namespace tables selected for data warehouse processing in the setup
Validate each row has "Insert" populated in the "Type" field
Open the program to query data on the 'SQL' database server and connect to the database
Run at query to display rows filed the "dss_completion_flag" table.
Validate the expected tables are present on the results, for the parent and child namespace tables selected for data warehouse processing, in the setup
Validate the "dss_status" field for each row is set to "1", indicating the table was loaded successfully
From the database "Table" tree list, select tables form the parent and child namespaces
Click to display the rows in the table
Validate all data rows are displayed, as expected

Topics

• Data Warehouse