Using InterConnect to push data from one Oracle DB to another

I am attempting to setup a test envinronment to evaluate InterConnect.

I have a repository installed and operational as well as the DB adapter (OAIHUB and OAI db's as well as the Win2K services, "OAI Adapter 4.1" and "OAI Repository"). What I would like to do is to push data from one Oracle db table to another. I am not trying to do anything fancy ... no transformations or business logic need be applied.

For the tests, I created two new instances of the SCOTT/TIGER database that comes with Oracle ... want to push data from one EMP table to the other EMP table in the 2nd instance of the database (running on a database server located on another machine).

Using iStudio, I created a business object called EMPLOYEE and an event called NEW_EMPLOYEE. I have created two applications, named after instances. One is called DATA_PUBLISHER and the other is DATA_SUBSCRIBER. I created a "Published Event" under the first application and a "Subscribed Event" under the other.

Now what???

I noticed that creating those respective events created a few rows in the repository db table, OAIHUB.STOREDPROC. The values in the "BODY" column are stored procedures that where automatically generated.

1. What do I do with these?
2. Do they get automatically deployed somehow or do I have to deploy them myself to my "publish" database and my "subscribe" database?
3. The proc generated by creating the "Subscribed Event" contains the lines:

AS
dummy NUMBER;
-- fill declarations here

BEGIN
-- fill code here

dummy:= 0;
END sub_NEW_EMPLOYEE_ICF_V1;

What is up with that? Do I have to code the body of the proc myself?!? I would have thought that InterConnect and iStudio were supposed to take the coding out of enterprise integration :-/

Thanks!

• Bruce bruce dot loth at iname dot com

PS -- Yeah, yeah .. I know dblinks would be a hell of a lot easier . . . Received on Thu Dec 19 2002 - 07:13:55 CST