Technical difference between using the oracle connector vs using a dataflow connection to oracle?

Question

Hi,&nbsp;Every week we get the error (cannot find gateway) when it tries to connect to the oracle server it starts on saturday and seems to resolve itself by Tuesday.&nbsp; However the dataflows that connect to oracle seem to work fine with no errors and can find the gateway.&nbsp;What reason could it be that the oracle using the connector cant find the gateway during those days but the dataflow can?&nbsp;We are using DEC 2023 gateway.&nbsp;Thanks

gilbertq · Answer

Hi&nbsp;jak8282&nbsp;
&nbsp;
That certainly is unusual that your data flows still continue to work. What I would suggest doing is upgrading new gateway to the latest version as well as also ensuring that your gateway server can successfully connect to the Oracle server over the weekend. If that store fails, I will chat your Oracle DBA to help troubleshoot the issue.

jak8282 · Answer

Yeah we are going to try and access the event logs - if it was failure to conenct though - why would the dataflows refresh okay? Yeah we are in discussion with the Oracle DBA

Forum Discussion

Related content

technically strong

Technical Design Document

Shared Semantic Model - Connectivity Issue from different tenants

Different schema into different destination

Understanding different connection methods to a lakehouse