[jbosstools-issues] [JBoss JIRA] (JBDS-2852) Database/source/connection Usability

[Barry LaFond (JIRA)]

    [ https://issues.jboss.org/browse/JBDS-2852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12946377#comment-12946377 ] 

Barry LaFond commented on JBDS-2852:
------------------------------------

Teiid Designer utilizes DTP by:
* relying on the Connection Profile data persistence for basic data source properties
* DTP's JDBC connection framework for data preview (query execution, SQL Editor and SQL results display)

However we've found that to our data sources typically include a finer definition of the source metadata. For instance, out JDBC importer is typically used to pull partial or selected tables, views and procedures from within a schema. In Teiid Designer, we persist this additional information within the source model metadata.  This additional metadata should probably JDBC sources tyipcally require   define a data source 
* 
                
> Database/source/connection Usability
> ------------------------------------
>
>                 Key: JBDS-2852
>                 URL: https://issues.jboss.org/browse/JBDS-2852
>             Project: Developer Studio (JBoss Developer Studio)
>          Issue Type: Epic
>      Security Level: Public(Everyone can see) 
>          Components: integration, requirements
>            Reporter: Burr Sutter
>              Labels: QE_JBDS80_needinfo
>
> Connecting to a database from within JBDS/Eclipse is a multi-step, multi-screen, potentially error-prone challenge.    
> Forge is involved as it can generate entities from schema
> Datasources are needed in/on AS/Wildfly/EAP in order for the project deploy
> Persistence.xml may needed to be tweaked for the datasource
> End-user would like to navigate the schema in the DTP/Hibernate Tools, interactively review the data and there was once a feature for viewing an ORM diagram that I seem to have forgotten how it is displayed.
> What happens when a project that needs a database connection is imported into the IDE? 
> This was partially addressed with
> https://issues.jboss.org/browse/JBIDE-15263
> Let's see if we can continue to improve the workflow by reducing steps, making it more obvious what steps are required (e.g. hey developer, get the mysql driver .jar), auto generating the -ds.xml, with a decent explanation for the end-user to follow.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira