topic Re: PRODUCT ISSUE: "Update Rows" option is not available with Oracle DB? in Alteryx Server Discussions

PRODUCT ISSUE: "Update Rows" option is not available with Oracle DB?

PaulFields2 — Thu, 13 Jan 2022 17:50:12 GMT

I have a fairly extensive workflow with two layers of batch macros that make use of In-DB nodes in order to dynamically adjust my database connection strings based on the DB (Dev / Test / Prod) that I need to use. Previously I had used batch macros with standard Input and Output connections, which worked fine on my local machine but errored out on Server.

So I re-did the whole thing (7 DB connections) using the In-DB nodes. However, I just noted that the "Update Rows" option in the Write Data In-DB node does not appear to be supported with (.oci) connections to Oracle Databases. Please let me know if am mistaken here, but if I'm correct this appears to be a key functional deficiency.

This is a big deal for me as I have 25 workflows that together have nearly 100 unique DB connections that all need to be manually adjusted when moving between environments. I had hoped the Control Param / Action Node / In-DB connection using (.indbc) files was the solution, but the gap I've noted above just put the kybosh on the whole thing.

Please confirm this limitation in the Write Data In-DB and if so, advise when this feature can be added.

Re: PRODUCT ISSUE: "Update Rows" option is not available with Oracle DB?

PaulFields2 — Thu, 13 Jan 2022 17:52:49 GMT

Meant to include this. I noted that a previous post describes the same issue and Nick C. at Alteryx was going to look into this. No update from Nick after that.

Re: PRODUCT ISSUE: "Update Rows" option is not available with Oracle DB?

mathieuf — Tue, 18 Jan 2022 09:47:24 GMT

Hi @PaulFields2,

Here is an extract from the documentation: https://help.alteryx.com/20213/designer/write-data-db-tool

Update/Delete is currently only supported for SQL Server ODBC connections.

Please use the Idea section of the community to raise yours.

I can see this one is already existing, so you can vote to increase visibility. I did it as well to support this!

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Update-Delete-Rows-available-for-more-database/idi-p/779911