Inserting Report Details Into Another Database

[asrinath]

Hello All,

Is it possible through Actuate to insert into another database the records generated by the report. I mean having 2 connections in the same report, one for getting records and the other for inserting records. Both Db's are SQL Server.

TIA

 

[bcaslow]

It is possible, but it wouldn't be easy, or fun. The basic problem you face is Actuate -- while capable of doing any SQL statement (such as Insert or Update) -- is a reporting tool, not a data loading tool. Also, you may likely run into some issues regarding two connections with SQL Server. If memory serves me correctly, what you would have to do is pull the records to 'generate' the report, store the data in a buffer so you can lose your retrieval connection, establish a new connection, the loop through the buffer to insert each record/piece of data into the database.