Can any one help me out in writing a SQl query for a view in Baan.

We are trying to create a view linking new and old baan servers.
Can we generate reports in new baan using VIEW eg- vw_vg_tfacr200.

thanks in advance
sandeep

Hi,

Can you please elaborate more on your quest?

- George

On brazilian localization. There is a module that integrate Baan and a third party financial software. This integration consists in 3 parts

Tables on Baan - Views on Database - Tables on the Third Part Software.


The communication between them is handled by a Java script that access all these systems.

Hi,

We have two baan servers (old baan and new baan server)

We have created views of the tables so that we can consolidate the data of the two servers at Oracle level.

Is there any way to write a baan query so that these views can be used and a consolidated report can be generated.

Thanks
Sandeep

If the data of both servers can be accessed from one single server with separate database definition assigned to such tables , u can easily consolidate the same in query as well as in a report .