[
https://issues.jboss.org/browse/TEIIDDES-2209?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2209:
----------------------------------------
K. this makes a little more sense than TEIIDDES-1846.
We could an an option in the DDL Importer when importing a View with no SQL AND a view
with one or more columns like *Generate Default SQL* and give an example similar to
above.
anytime view models are created (I.e. DDL import as View) allow
checkbox to make default transformation so that the model is deployable
---------------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-2209
URL:
https://issues.jboss.org/browse/TEIIDDES-2209
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Reporter: Tom Johnston
Fix For: 8.6
Attachments: order_test_ddl.txt
I have mentioned this before but now that DDL import can generate view models (the only
mechanism I can see to bring in logical/conceptual models from other tools like
PowerDesigner etc)
If the model is successful in that it brings all components it is still not a valid model
to deploy to a vdb and start work against.
My proposal is to generate SQL using the column metadata for the view itself.
For example... I've attached a simple ddl but for order_header it'd be like:
SELECT null AS Order_header_id, null AS order_header_name
The primary purpose is to make the model deploy-able immediately.
I'd also like to see this 'feature' at the Model-->Generate stubs when
right clicking the model.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)