1. UNIFYNow Forum
  2. Ideas
0
Completed

Oracle database change detection

Ryan Crossingham 12 years ago • updated by anonymous 8 years ago • 7

I was speaking to Bob during the week regarding Oracle DB change detection for Event Broker. He told me that currently the only way to to achieve this is by using SQL link on the Oracle server to present the Oracle DB similar to MS SQL.

Are we able to look into Oracle database change detection?

Patrick Johannessen 12 years ago

Ryan: In future follow PRDGRP, PUBEB is for end customers.

For investigation in v3.1

Adam van Vliet 11 years ago

Tony, could you please take a look at this one?

Don't use the built in ADO.NET Oracle providers, as they have been deprecated. (http://msdn.microsoft.com/en-us/library/77d8yct7.aspx).

Take a look at http://www.oracle.com/technetwork/topics/dotnet/index-085163.html. Need to make sure that is suitable, as well as how it is made use of, eg: whether it'll be deployed with the installer; or whether it is gac'd and just referenced.

Please feed any information discovered on Oracle .NET controls into IDB-534.

Thanks.

Adam van Vliet 11 years ago

I have linked IDB-534 as it should be done first to avoid using the deprecated Oracle providers.

Adam van Vliet 11 years ago

Please reduce the estimate for this issue to 2 days if the Framework data providers are suitable.

Tony Sheehy 11 years ago

Reassigned for confirmation of completion, an Oracle DB instance has been installed on prdgrp-test2.

Tony Sheehy 11 years ago

This change detection process will need to be documented in 3.1 space

Tony Sheehy 11 years ago

Confirmed in 3.1 documentation.

Customer support service by UserEcho