How to Configure Oracle ODBC Gateway for Remote Database Access

Learn how to access non-Oracle databases from Oracle Database and how to configure ODBC Gateway.
Many sites run distributed systems: two (or more) databases communicating together. If they are all Oracle, no problem - just use database links. But what if some are, for example, SQL Servers or MySQL, or any other third party product? Then you need Heterogeneous Services gateways. These can be difficult and expensive to deploy. The ODBC HS gateway may be a simple, and cheap, alternative.

Presenter: John Watson, Oracle Certified Master DBA

Download the slides and scripts used in this presentation at https://skillbuilders.com/course/conf....

Contents of this video:

00:00 - Introduction to How to Configure Oracle ODBC Gateway for Remote Database Access
00:49 - Lesson 1: What are the HS Services?
02:05 - Lesson 2: Understanding the flow is critical
03:51 - Lesson 3: Demo: Create an ODBC gateway
14:34 - Summary to How to Configure Oracle ODBC Gateway for Remote Database Access

Attend instructor-led online class with this instructor, Oracle Certified Master John Watson of SkillBuilders! https://skillbuilders.com/course/orac...

Hire John for Oracle DBA Services! For more info visit: https://skillbuilders.com/database-ad...

SkillBuilders has 25+ years of success stories! We are experts in Oracle Database, APEX Oracle Cloud and AWS.

Subscribe to our Channel and see hundreds of SkillBuilders Free Tutorials or watch on web site:
https://skillbuilders.com/free-oracle...