Bookshelf Home | Contents | Index | Search | PDF

Siebel Connector for PeopleSoft > Database Wizard > Example >

Relevant Tables

---

The first step in integration using the EAI Database Wizard is to identify the relevant tables in the external database that will be integrated with the Siebel application. This example involves a sample database with a couple of tables. Figure 6 shows the relationship between these tables.

Figure 6. Table Relationships

As the figure above indicates, the external database has two tables—Department and Employee. The department table has three fields—Dept_Id, Name, and Location. Of these fields, Dept_Id is the primary key. The Employee table is a child of the Department table, and this relationship is established through the foreign key Dept_Id in the Department and Employee tables. Other than this field, Employee table also contains Emp_Id, which is the Primary Key for that table and First_Name, Last_Name, and Salary fields. The following sections explain how these tables and fields become integration components and integration component fields, respectively. The accompanying example shows how this integration object facilitates various database operations on these tables in the external database. If you create these tables in an external database and follow along, you can use the following SQL script:

drop table Department;

create table Department

(

Dept_Id int,

Name varchar(5),

Location varchar(50)

);

drop table Employee;

create table Employee

(

Dept_Id int,

Emp_Id int,

First_Name varchar(25),

Last_Name varchar(25),

salary int

);

The "drop table" lines are added in order to be able to run the above query over and over again. Please make appropriate changes to the above script to make it run on the database of your choice. For example, the datatype varchar used above needs to be changed to varchar2 on an Oracle database. Similarly, you may want to change the datatype for the field salary to something that supports fractional currency.

Bookshelf Home | Contents | Index | Search | PDF