80 likes | 250 Vues
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?.
E N D
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? • 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.
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.)
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.
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.
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