We are using Baan IVc
Database tbase6.1
OS Solaris 2.6

Currently we are transfering data to SQL Server using Safari ODBC,every day we are running schedule at night. This is for the purpose there are few reports/application which we are not able to do it in Baan (example Vendor Rating, Assembly Target Completion Report etc.) But for all the application we are using One day old data.

Is there any other way by which I can transfer data/replicate data as and when it get update in Baan. For Some application which are on SQL server are required live data.

Shrikant

quite tricky with tbase.
What you could do is something like the following:
if the tables you want to replicate have ascending primary keys (like orno or something), write a program that sleeps for a certain time, then looks up a control table (individual new table) for the last key that was exported. Then the program looks whether there are "bigger" keys in the table in question. If yes, it will write the data to a seq. file and then insert the exported keys into the control table and sleep again.
You will have to pay attention to some sync-issues and range of keys, but this is solvable.
For synchronizing, you can use another seq.file. If your program works, it should create a file "stop.sig" and erase it, before "it goes to bed" again. If it wakes up and there is such a file, it must sleep again.

The program that wants to import the seq. file into a db must look whether there is no file called "stop.sig", create it, then read the data file and before it terminates delete the "stop.sig".

good luck

Norbert

If you use safari anyway to copy the data, why do you not directly use safari to run your reports on tbase?

By the way, be carefull with safari and performance, if you do. Safari tends to create a lot of full table scans, but this might not matter so much with tbase, as it does with oracle.

Regards

Markus

Another option is to put Audit On the specific tables. But this will definetly have a negative impact on the performance.

Maxime.

Will it be possible if I change to any other database ?

Like We are thinking to migrate from tbase to oracle


Shrikant

Sure, once you switch to a database, you have a lot of options.

- You can directly access your data via any ODBC/OLEDB tool
- You can use snapshots to create copies of tables
- You can use triggers to update other tables, whenerver your source table changes.
- You can use Oracle transparent gateway to write data to sql server.

The options are very broad.

Markus

Mr. Markus Schmitz,

Thanks , We can use both places oracle i.e at Baan Backend and in place of SQL Server.

What I heard about Oracle for Baan that we can not see or connect database from out side i.e. without using Baan.

If it is not like that I can use snapshot replication and carryout my work.

Thanks once again.

Shrikant