Forum Discussion
Oracle connection
I was able to successfully connect to Oracle but it was pretty tricky to set up (poor/minimal/complex documentation from Microsoft & Oracle). And even though I can connect, the speed/performance is p...
I know of no easy button for that. I am shocked, shocked! that Microsoft and Oracle are not skipping hand-in-hand through a field of daisies...
Shocked...
Shocked...
Cool.
So does anyone know the best (i.e., least bad) practice for setting up a Power BI/Query connection to Oracle? Because the Microsoft and Oracle documentation don't, in my opinion, lay out what that is.
What you are looking for is Ole DB. This is installed with the ODAC client you have already installed more than likely. Nobody is talking about it here because nobody knows about it without diving super deep into whitepapers.
Ole DB has the ability to take connection string properties which will drastically improve your import speed. This can be done utilizing connection string modifiers such as FetchSize and ChunkSize after building your connection string. The downer here is that you lose complete access to DirectQuery. But guess what... Microsoft and Oracle haven't made that faster either.