Transcript Safari Report Writer - Hunt for the Big Game

Safari Tools
Rich Hinz – Technology Training Officer
Michael Quiner – Director for Administrative
Technology
Safari – So Goodie !
What is Safari?
Safari Administrator
Safari Report Writer
What is Safari Administrator?
Set Security Access
Create Groups
Create Users
Create Views
Users and Groups
In Safari Administrator
What is a View?
A subset of fields from a file
View field names can be anything
Must be SQL compliant
BUT…
Users will eventually learn colleague names
Users might get confused
View Creation
In Colleague – was VWBR now RUVB
View Creation
In Safari Administrator
SQL’ize files with METP
View Creation
In Safari Administrator
What is Safari Report Writer?
A Report Building Utility
Uses Views
Created in Colleague OR
Created in Safari Administrator (Preferred)
Uses ODBC and SQL’ized file
Report Creation
In Safari Report Writer
Select View to Use
Report Creation
In Safari Report Writer
Select Fields
Report Creation
In Safari Report Writer
Select grouping
Report Creation
In Safari Report Writer
Select sort options
Report Creation
In Safari Report Writer
Report Layout
Report Creation
In Safari Report Writer
Report output
When should we use the RUVB process to
create a native database view and when should
we use Safari Administrator to create a Safari
view?
`
What Happened to SureView?
Previously known as SureView, the
Reporting Utilities module’s focus is to
assist Datatel Clients in the translation of
data from Colleague into distributed
information for SQL-based reporting,
including ODBC access.
SureView to RU
07/31/2001 – End of Programming Support
10/31/2001 – End of Full Tech Support
12/31/2001 – End of Limited Tech Support
06/01/2001 – Start of Annoying Attitude
“ Both SureView and RU can be used, but
it is not recommended!”
RU Functions
Set up parameters and dictionaries for
UniData SQL-based reporting.
Load table and view definitions, including all
relevant metadata, to the Safari dictionary.
Specify and generate database SQL Views. ?
• Optionally create new files as snapshots of data at
a point in time, based on View specifications.
• Other utilities to support using read-only SQLbased products to retrieve data from your UniData
database.
Expanded RU Menu
Expanded RU Menu
RU Enhancements
Moved utilities from TOOL to the UT.
All Envision applications and the Colleague runtime CDD to feed metadata for SQL-based views.
(Great DVF/PFDE vrs. RDVF Debate )
Load Safari automatically based on a parameter.
Load multiple Safari RECORDS to logically
normalize the data for use in Safari Views.
Expanded RU Menu
RU Enhancements
Moved utilities from TOOL to the UT.
All Envision applications and the Colleague runtime CDD to feed metadata for SQL-based views.
(Great DVF/PFDE vrs. RDVF Debate )
Load Safari automatically based on a parameter.
Load multiple Safari RECORDS to logically
normalize the data for use in Safari Views.
Remove the restriction to require those using RU
to be logged in as "datatel”.
Better performance with SQL-based reporting
against the UniData database, including STAR
joins.
Expanded RU Menu
MEVS to Export to RU
Questions ??
Safari - So Longie !!