Direct Query on Oracle DB


Hi All,

I am working on a project where i need to connect to very large volumes of data.

I could not use the import for such big tables. I am trying to connect using Direct query and build data model. please can you share me any quick link to the tutorial with tips and tricks on how and when to use direct query.



Need more specifics on what you are looking for. I would suggest trying to use direct query and build your data model. If you run into a snag along the way, then put a question here in the forum so that we can better assist.




It also might be helpful to build an intermediate layer. Might be overkill but an SSIS where you can aggregate.

While I never tried it the “mixed” mode or whatever its called that lets you direct query some tables (Giant fact tables) and direct import others also seems seems promising.