Re: Using InterConnect to push data from one Oracle DB to another

Bruce Loth wrote:
> 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] Versions?!? I will assume you use 4.1 (you refer to OAI), and 8.1.7(.4?) as RDBMS

>
> 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?

[Quoted] Define these... entries in the table? - nothing. Code snippets? - see below
>
> 2) Do they get automatically deployed somehow or do I have to deploy
> them myself to my "publish" database and my "subscribe" database?

[Quoted] You need to code WHAT you want to do, and HOW.

>
> 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 :-/

Nope - make it easier. Mentioned above, YOU decide HOW it's done, and WHAT is done.

You do not mention the type of connector you use; I suppose it is the Database Adapter?

[Quoted] Anyway, in short you need Oracle Applications Interconnect Users Guide, part A90225-02
- a common view (a superset of data elements both applications share) - application specific views (yes, even tho you will not use

   transformations, well you do actually, 1:1 transformations) - procedures - you already have the stubs.

You will have to code your own procedures - in your case some "fill in the blanks", as both schema's as similar.

[Quoted] I could work out your example, when you provide some mode details about versions and type of adapters.

Grtz, Frank Received on Thu Dec 19 2002 - 19:26:48 CET