Triggering IBM Transformation Extender from an Oracle database table
This demonstration shows how to setup row based triggering for inserts/updates on an Oracle database table so that an ITX map executes for every committed event.
SQL scripts used in this demo:
DROP TABLE Groups;
CREATE TABLE Groups(
userid numeric(10) not null,
ugroup varchar(20) not null,
name varchar2(50) not null,
active varchar2(1),
CONSTRAINT supplier_pk PRIMARY KEY (userid)
);
INSERT INTO Groups VALUES (1,'ORANGE','Paul','N');
INSERT INTO Groups VALUES (2,'ORANGE','Charlotte','N');
INSERT INTO Groups VALUES (3,'ORANGE','Meghan','N');
INSERT INTO Groups VALUES (4,'BLUE','Steve','N');
INSERT INTO Groups VALUES (5,'BLUE','Jane','N');
INSERT INTO Groups VALUES (6,'BLUE','Fred','N');
INSERT INTO Groups VALUES (7,'GREEN','Raoul','N');
INSERT INTO Groups VALUES (8,'GREEN','Jinto','N');
INSERT INTO Groups VALUES (9,'GREEN','Sinita','N');
commit;
UPDATE Groups SET Active='Y' WHERE Name='Paul';
commit;
UPDATE Groups SET Active='Y' WHERE Name='Jane';
commit;
INSERT INTO Groups VALUES (10,'PURPLE','Dave','N');
INSERT INTO Groups VALUES (11,'PURPLE','Steve','N');
commit;