Sven Pauwels on 07 Feb 2019 19:40:39
Just like Native SQL Queries are supported in Dataflows we need to have this for Oracle also. It will increase the performance of the dataflow.
Administrator on 14 Oct 2021 21:38:50
The ability to write native queries using the Oracle Database connector exists today within the Connector settings configuration for dataflows.
- Comments (1)
RE: Dataflows from Native Oracle Query
Currently on Desktop you can click on the cog icon near "Source" and edit your SQL query, but the same function is not available for Dataflows.
The current workaround is copying everything from Advanced Editor to desktop, editing the query and copying it back to the Dataflow.
Allowing editing of native SQL queries on dataflows would make it a lot easier!