Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

connection to Oracle Expand / Collapse
Author
Message
Posted Monday, May 6, 2013 5:59 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:41 PM
Points: 1,770, Visits: 3,202
We have a big vendor application and oracle is the database server. We are not allowed to write direct view, functions on the oralce database, so we planned to use SQL server to connect to Oracle.
We know there is an option of linked server, but we are concerned if it will affect performance of oracle server and will it create concurrency or lock, or bandiwith issues. We will create views and function on the linked server, and most of time it is used for nightly data extracts. so maybe it won't cause issues, but without experiencing of using it, we are not sure. Or any other method, for example using replication or SSIS to pull data to SQL?
Any recommendations? Thanks
Post #1449942
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse