1 / 8

Advanced SQL/ODBC Configuration Mike Bianco

Advanced SQL/ODBC Configuration Mike Bianco. Agenda: ODBC and Skyward. What is ODBC? What requires ODBC? Configuring ODBC for Skyward Maintenance of ODBC for Skyward. What is ODBC?.

cachez
Download Presentation

Advanced SQL/ODBC Configuration Mike Bianco

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. Advanced SQL/ODBC Configuration Mike Bianco

  2. Agenda: ODBC and Skyward • What is ODBC? • What requires ODBC? • Configuring ODBC for Skyward • Maintenance of ODBC for Skyward

  3. What is ODBC? • Open Database Connectivity (ODBC) provides a standard softwareAPI method for using database management systems (DBMS). The designers of ODBC aimed to make it independent of programming languages, database systems, and operating systems.

  4. What requires ODBC? • Crystal Reports / Report Viewer • Crystal Enterprise Scheduling software • Skyward PaC and Web Crystal Quick Pick Reports • Custom/3rd Party Interfaces (Special Ed, UMR/Tools4Ever, etc.) • Other 3rd Party Tools (Cognos, Microsoft Reporting Services, etc.)

  5. Maintenance of ODBC and Skyward • DBTool’s SQL Width Padding utility should be run weekly. • Update Read-Only User process should be run daily. • Update Statistics process should be run weekly.

  6. Monolith 2 Scheduled Tasks • Web product has the ability to configure Read Only user accounts for ODBC. • Monolith 2 can be setup to run scheduled tasks for Read Only User Rights, DBTool utility and Update Statistics process.

  7. Creating ODBC Users and Data Source • How do I create a Read-Only SQL User? • FAQ Tutorial: https://support.skyward.com/FAQ/View.aspx?ID=1200244 • How do I Schedule Update Read Only ODBC User Task? • FAQ Tutorial: https://support.skyward.com/FAQ/View.aspx?ID=1367341 • How to I create a Data Source DSN? • ODBC Install Guide

  8. THANK YOU FOR ATTENDING!

More Related