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?
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.
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |