james fenoulhet
New Member
Hello.
Could do with some advice please.
We have a live system with a replication box where we run all our reports and extracts from, using an odbc connection with the 11.4 driver. The current DB is 10.2B patch 8.
We are looking at doing a biztalk implementation at the moment and wondered if you can grab data from the live box with the ODBC driver rather than from the replication server. Reason being, replication may fall behind or collapse completely (probably rare but a risk) which would then impact pulling data.
Is it possible to do this without locking live up? Is this a supported process or a complete do not do it?
This wouldn’t be massive amounts of data so don’t think it would impact in terms of slowing the live system down, I’m more concerned about locking users out of fields. Just wanted to get some advice or recommendations on how we should get the data from live.
Thank you in advance
Could do with some advice please.
We have a live system with a replication box where we run all our reports and extracts from, using an odbc connection with the 11.4 driver. The current DB is 10.2B patch 8.
We are looking at doing a biztalk implementation at the moment and wondered if you can grab data from the live box with the ODBC driver rather than from the replication server. Reason being, replication may fall behind or collapse completely (probably rare but a risk) which would then impact pulling data.
Is it possible to do this without locking live up? Is this a supported process or a complete do not do it?
This wouldn’t be massive amounts of data so don’t think it would impact in terms of slowing the live system down, I’m more concerned about locking users out of fields. Just wanted to get some advice or recommendations on how we should get the data from live.
Thank you in advance