Course description: Accessing UniData using ODBC
Skills taught
- Discuss why you use ODBC
- Install ODBC Client software
- Prepare UniData Accounts for ODBC access
- Use the Visual Schema Generator (VSG) to build views and subtables
- Create a Data Source Name (DSN) for connection to UniData
- Connect to a UniData server from a client Personal Computer (PC)
- Retrieve UniData data from Microsoft Access and Microsoft Excel
- Update UniData data from Microsoft Access
- Define security privileges on tables, views, and subtables
- Troubleshoot UniData ODBC
Course outline
- Introduction to UniData ODBC
- ODBC installation
- Preparing the UniData database for ODBC
- Connection to the UniData database
- Using the VSG to create views
- Creating subtables through VSG
- ODBC security
- Troubleshooting
