PUG Challenge Americas

SQL for a Progress DBA

A lot of businesses run Open Edge applications provided by a third party vendor. These same businesses then want to access the data stored in the database via ODBC or JDBC to generate reports. Care and feeding of the SQL92 engine can sometimes get lost or ignored. In this session we will pull together a number of tips, tricks and best practices on how to care for the SQL92 side of the database.

  • Setup of ODBC
  • Security and Authorization
  • Performance
  • DBA Housekeeping
  • Migration and Upgrade Considerations
  • Best Practices Discussion

The target audience member will be responsible for an Open Edge database but needs some clarity on the SQL side of things.

> Session Slides
Schema Update
Progress SQL Parameter Tool

 

This session is sponsored by

Speakers