0
Completed

Oracle database change detection

Ryan Crossingham 6 years ago • updated by anonymous 3 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?

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

For investigation in v3.1

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.

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

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

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

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

Confirmed in 3.1 documentation.