Using InterConnect to push data from one Oracle DB to another
Date: Thu, 19 Dec 2002 08:13:55 -0500
Message-ID: <o2h30vs0qr3itijg2sdj04jdqi5bpvs980_at_4ax.com>
[Quoted] 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).
[Quoted] 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.
- What do I do with these? [Quoted]
- Do they get automatically deployed somehow or do I have to deploy them myself to my "publish" database and my "subscribe" database? [Quoted]
- 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 - 14:13:55 CET