Effiecient way of data Transfer From one data base to another
we have a requirement to transfer the data from our application core data base to another one to have a report kind of visibility for monitoring. We are using Bix to transfer the data in batch mode for every hour. As the records in the data tables will be updated every minute , is there any efficient way to transfer the data so that the data will be pulled and available for reporting all the time.
thanks for your post. I would like to know, if there is any feature in bix job to make it run all the time rather than running in batch mode.Right now, bix job itself take some time to strat the job, is there nay feature to enhance it?