Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Designer 2023.1 Output tool refuses to allow custom map to Oracle table

MSicz
5 - Atom

I cannot get Workflow Designer's Output tool to allow custom map to an Oracle table.   Yes, I've tried using several connection methods (OCI, ODBC, etc.).   When the connection is set up, the DCM just prompts for a table name; no table browser (like the Input tool & it's SQL builder does).  Yes, I've tried putting schema.table_name, verified the spelling is correct, verified the output option is append.

I just don't see anything I've set wrong... the tool only allows map by name; custom is always greyed out.   Ideas?

1 REPLY 1
MSicz
5 - Atom

Just discovered if I delete the Output tool item and recreate without using the DCM, instead just use ODBC connection, I get prompted for user, password, then table name.  It creates and ODBC DSN-based entry and then the mapping dialog shows all the in-db column names and allows custom map.   

Still seems like a bug with the DCM and OCI... it should allow custom map regardless of the path to the Oracle table.

Labels
Top Solution Authors