DB Connector: UX design

[syndesis-bot]

@KurtStam	2017-11-06	UX Design

At connection creation time, we need to allow the dev user to add one or more SQL statements that can be used by the citizen developer later-on when configuring the action.

[syndesis-bot]

@amysueg	2017-11-06

@kcbabo - can you provide more details around this request? There appear to be two users in play here, the developer and the citizen developer. Can you describe the flow so that we better understand how this DB Connector is intended to be used, when, and by whom?

[amysueg]

@kcbabo provided more information --When used in Integration Editor, the DB connector will have a single action "Add SQL". The UI will present a text input area for the user to enter the SQL and the backend will validate the data shape based on SQL the user entered. An error may occur if the SQL is invalid, or references fields that don't exist in the target table. The system will check for error conditions when the user selects the “Done” button. UI will provide an inline validation error on the page.

@sjcox-rh This should be pretty straightforward and is needed for TP3. I'd like to assign this one to you if you are ok with that. Thank you.

[amysueg]

Moved this task to "In Progress" like the UX design for AMQ Connector

[sjcox-rh]

Closing out this issue since the PR was merged.

PR 642