1 / 29

Safari Tools

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.

maina
Télécharger la présentation

Safari Tools

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Safari Tools Rich Hinz – Technology Training Officer Michael Quiner – Director for Administrative Technology

  2. Safari – So Goodie !

  3. What is Safari? • Safari Administrator • Safari Report Writer

  4. What is Safari Administrator? • Set Security Access • Create Groups • Create Users • Create Views

  5. Users and Groups • In Safari Administrator

  6. 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

  7. View Creation • In Colleague – was VWBR now RUVB

  8. View Creation • In Safari Administrator • SQL’ize files with METP

  9. View Creation • In Safari Administrator

  10. 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

  11. Report Creation • In Safari Report Writer • Select View to Use

  12. Report Creation • In Safari Report Writer • Select Fields

  13. Report Creation • In Safari Report Writer • Select grouping

  14. Report Creation • In Safari Report Writer • Select sort options

  15. Report Creation • In Safari Report Writer • Report Layout

  16. Report Creation • In Safari Report Writer • Report output

  17. ` 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?

  18. 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.

  19. 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!”

  20. 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.

  21. Expanded RU Menu

  22. Expanded RU Menu

  23. 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.

  24. Expanded RU Menu

  25. 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.

  26. Expanded RU Menu

  27. MEVS to Export to RU

  28. Questions ?? Safari - So Longie !!

More Related