safari tools l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Safari Tools PowerPoint Presentation
Download Presentation
Safari Tools

Loading in 2 Seconds...

play fullscreen
1 / 29

Safari Tools - PowerPoint PPT Presentation


  • 131 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Safari Tools' - maina


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
safari tools

Safari Tools

Rich Hinz – Technology Training Officer

Michael Quiner – Director for Administrative Technology

what is safari
What is Safari?
  • Safari Administrator
  • Safari Report Writer
what is safari administrator
What is Safari Administrator?
  • Set Security Access
  • Create Groups
  • Create Users
  • Create Views
users and groups
Users and Groups
  • In Safari Administrator
what is a view
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
View Creation
  • In Colleague – was VWBR now RUVB
view creation8
View Creation
  • In Safari Administrator
    • SQL’ize files with METP
view creation9
View Creation
  • In Safari Administrator
what is safari report writer
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
Report Creation
  • In Safari Report Writer
    • Select View to Use
report creation12
Report Creation
  • In Safari Report Writer
    • Select Fields
report creation13
Report Creation
  • In Safari Report Writer
    • Select grouping
report creation14
Report Creation
  • In Safari Report Writer
    • Select sort options
report creation15
Report Creation
  • In Safari Report Writer
    • Report Layout
report creation16
Report Creation
  • In Safari Report Writer
    • Report output
slide17

`

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
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
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
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 SQL-based products to retrieve data from your UniData database.
ru enhancements
RU Enhancements
  • Moved utilities from TOOL to the UT.
  • All Envision applications and the Colleague run-time 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.
ru enhancements26
RU Enhancements
  • Moved utilities from TOOL to the UT.
  • All Envision applications and the Colleague run-time 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.