Course Code: ODBC-Adm-001
Course Code ODBC-Adm-001
Number of Days 5
Course Cost $900.00 per attendee
Course Schedule Coming Soon!
Course Overview Index
You Will Learn How To
Course Benefits
Who Should Attend
Pre-Requisites
Course Content
Hands On
You Will Learn How To
Install the OpenLink Multi Tier ODBC Drivers
Establishing a connection
How to start and shut down the request broker
Advanced Configuration of the OpenLink Generic Client
Advanced Configuration of the OpenLink Request Broker
Setup security, including how to handle firewalls
Assess Database specific ODBC support
Troubleshoot ODBC issues
Course Benefits
The course provides you with the in depth knowledge and skills to administer and roll out an OpenLink based infrastructure. Throughout the course the practical exercises illustrate the "do's and don'ts" of managing the OpenLink environment.
Who should Attend
This course is valuable for system integrators, system administrators, database administrators, software developers and technical project managers who are involved in managing or evaluating the OpenLink MT ODBC drivers.
Pre-Requisites
Familiarity with RDMS concepts
SQL
General Programming Concepts
ODBC compliant application such as MS Office Applications, MS Visual Basic, PowerBuilder or Delphi.
*Note: On site courses will be targeted at the skill level of the group. Public courses require candidates to satisfy the necessary pre-requisites.
Course Content
ODBC Overview
Installing the OpenLink Product Set
Establishing Your First Connection
Starting & Shutting Down The OpenLink Request Broker
Overview of the OpenLink "Session Rules Books"
Client Configuration Options
Server Session Rules Book
Using Multiple Session Rules Books
Understanding Timeouts
Security
Troubleshooting
History Of ODBC
ODBC's Objectives
Types Of Drivers
ODBC Features (General)
OpenLink Software's Implementation
Installing The OpenLink Product Set
Client Software
Server Software*1
*1 In Public courses SCO UNIX will be used for the Server Operating System. On site courses will use the customers selected server and database.
Lab 1: Installing the OpenLink Product Set. Involves installing the client and server components.
Establishing Your First Connection
Minimum configuration on the client and server
Setting up a client data source
Other configuration options to consider (i.e. BrokerTimeout, Retry, TimeOut)
The Connection Process
Lab 2: Establishing a first connection. Involves knowing the minimum requirements to establish a connection through the MT product.
Starting & Shutting Down The OpenLink Request Broker
Starting and Shutting Down the Request Broker
Command Line Options for oplrqb
Command Line Options for oplshut
kill -1
Lab 3: Trying the various command line options.
Overview of the OpenLink "Session Rules Books"
Client Session Rules Book
Server Session Rules Book
Relationship Between the Client & Server Sessions Rules Book
Client Session Rules Book in detail
ODBC Driver Manager Setup and configuration
Lab 4: Client time out settings and Provider Type configuration
Overview
General Administration Settings
Mapping Rules Settings
Lab 5: Business Application of the Session Rules Book. Set out a number of situations which candidates should be able to resolve using the Session Rules Book.
Using Multiple Session Rules Books
Introduction
Writing Multiple Session Rules Books
Things to Watch
Examples
Lab 6: Understanding Rule Book Merging
Introduction
Connection Timeouts
Executing Complex SQL
Lab 7: Altering the connection and statement execution timeouts.
Introduction
The Security Application
OpsysLogin
Encryption
Lab 8: Using the security application and then getting them to move part or all of their installation and see what happens for example.
Introduction
Categories Of Issues
OpenLink Debugging Capabilities
Oplscan
ODBC Test
Lab 9: Look at the various options for isolating where a problem is located.
Hands On
Installing the OpenLink Product Set. Involves installing the client and server components.
Establishing a first connection. Involves knowing the minimum requirements to establish a connection through the MT product.
Trying the various command line options for the Request Broker and shutdown program.
Business Application of the Session Rules Book. Set out a number of situations which candidates should be able to resolve using the Session Rules Book.
Session Rules Book merging
Seeing the effects of using the security application.
Altering the connection and statement execution timeouts.
Troubleshooting Techniques.
Interested in registering for this course or another one like it?
Click here to let us know!
