current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I need to transfer data on a daily basis from a SQL Server 2008 R2 database to Oracle Business intelligence. What's the best practice? Db link? External table? Odbc?

share|improve this question
    
If you have OBIEE you probably have some ETL suite that populates it. It will have connectors for SQL Server for sure. –  spaghettidba Jan 29 at 8:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.