Hi all:

I new in Baan IV and Oracle.

I would like to know, how can I acces to a table that is not in Baan ? .

I mean, I want to read, insert, delete and update records in a table from Baan. This table already exist in an application that is not Baan.
So, How can I connect this table to Baan ? or Maybe, Does it exist some API to connect to a different database ?

Thanks in advanced.

Exist In which Application ?????

Why it's important the external application ?.
( It is not a comercial applications. )

The table is oracle too. I know that we can connect from an external application with Baan vía OpenWorld, or update the Baan database vía SQL.

But, How can we do this (update other database) from Baan to an external application ?.

In theory this is possible, but I do not recall anyone getting it working. At one point our Oracle DBA set up a view into another database. Then in Baan we created the table using the tools sessions. We were able to read the table, BUT every time we went to create RDD for other tables we got errors from this table. So we stopped it.

The typical method for doing something like this is to use interface programs and files. One program pushes the data from Baan and another updates the external application.

Mark

Thanks Mark.

Until now, with db.link and view, we have the same. We can read the table, and we can update and delete records that has been inserted from Baan. But we can't update the records inserted outside Baan.

Of course, we've got several interfaces with the thypical method.
But I'm sure I will improve this interfaces, if I can do this integration.
The clearest advantange is that I can manage (read and update) on line information of another application from Baan.

I know a little bit about OpenWorld ( in theory ) and I only read information in order to integrate an external application with Baan, but in the other way ??.
A real EAI is in two ways, isn`t it ?

I have only read a little about Openworld, so I probably know less than you on this topic. I would expect there should be a way to share a table between Baan and some external application, but I do not know it. I would think if you built the tables in Baan and then attached another application to those tables, you should be able to write directly to them. I have not done this myself.

Mark

Balzamaor,

Please complete your user profile with regards to the Baan software version, Database software and OS version. This will help other members when diagnosing your problem.

Refer to the links on the board -

stored procedure oracle (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6448&highlight=oracle)

Access crossing servers and instances (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6720&highlight=oracle)
I mean, I want to read, insert, delete and update records in a table from Baan. This table already exist in an application that is not Baan.
We have used to read and delete (purge tables) from the Oracle data dictionary. I have never tried to use the updates and inserts. I would prefer BaaN tools to handle the referential integrity counters/hash columns etc based on the L1/L2 drivers.

As Mark, suggested the better way is to maintain the table in BaaN and keep the Oracle-DD in sync with the BaaN Table definition.

Hi all:

We are trying to get it,... and till know we've got this:

With a db.link and a view we can, from Baan, read,insert,update and delete records in another database.

Now we have a problem. If the record is inserted outside Baan, we only can read that record, but we can't update or delete it.

Any help or sugestion ???