In SQL Server, it’s easy to set up a linked server to Oracle and get data from there. You only need a UserID and a Password. If you need to filter a lot of data, it’s recommended to do the filtering where the biggest amount of data resides, in this case that is the Oracle side. In this tip we will use the Oracle alert log as an example.
If you can’t create and populate tables there, having a database link to SQL Server becomes crucial. This also allows you to easily maintain this table and be able to use