Oracle connector slow. Tuning Oracle ODAC driver?

Question

Hi!&nbsp;We have problem with slow connection to Oracle Database. We have an on prem Oracle database and using the Oracle connector i Power BI it processes&nbsp;about 5000 rows/second both from Power BI Desk and trough the gateway.&nbsp; Extracting the data inside&nbsp;Oracle SQL Developer it processes&nbsp;about 100 000 rows/second.&nbsp;Anyone who has solved the same problem? Is it possible to&nbsp;Tune the Oracle ODAC driver?&nbsp;RegardsFredrik

v-kkf-msft · Answer

Hi&nbsp;FredrikJ&nbsp;,
&nbsp;
Please see if these documents are helpful.
&nbsp;
Your Oracle data import in Power BI and Power Query is slow?&nbsp;
Oracle data load speed into Power BI Desktop&nbsp;
Very Slow Oracle Connection Speed&nbsp;
&nbsp;
Best Regards,Winniz

Forum Discussion

Oracle connector slow. Tuning Oracle ODAC driver?

1 Reply

Related content

Count Of Drivers

amazon redshift ODBC driver

Oracle Connector Version Compatibility in Fabric Data Factory

Oracle 32 Bit Drivers with 64 Bit

Any orgs using the built-in Oracle driver in Power BI Desktop?