3.3 Demonstration Requirements

Case study requirements.

The case studies assume these requirements have been met:

• The gateway demonstration tables and stored procedures are installed in the SQL Server database
• The Oracle database has an account named SCOTT with a password of TIGER
• The Oracle database has a database link called GTWLINK (set up as public or private to the user SCOTT) which connects the gateway to a SQL Server database as SCOTT with password TIGER2

  For example, you can create the database link as follows:

  SQL> CREATE DATABASE LINK GTWLINK CONNECT TO SCOTT
    2    IDENTIFIED BY TIGER2 USING 'GTWSID';
  

• Oracle Net Services is configured correctly and running