[
https://issues.jboss.org/browse/TEIIDDES-2775?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2775:
----------------------------------------
This use case involves providing a user the ability to convert Functions defined in the
Function Metamodel type to virtual model UDFs (procedures)
* The mapping is pretty straight forward in terms of parameter definition and properties
(category, java class, java method, etc.)
* There may be some issues with allowable datatypes that might have changed since Teiid
Designer 7.7 release
* Thinking an internal utility would convert the legacy functions into our non-EMF
relational metamodel used in all "New Child > xxxxx" dialogs.
* A check-box list of functions would be presented so the user can pick/choose what
functions to convert
* User would need to select an existing Virtual Model as the container for the new
UDF's or provide a unique name for a new Virtual Model
* UDFs are now defined as Virtual Procedures but referenced in SQL only by their method
name
Other issues....
* Virtual Models may have model imports to Function model due to use in transformations
* VDBs will have function models in them.
** Either require use to rebuild their VDB, or synchronize the VDB after migrating
functions, then remove old Function model
* ??
Provide automated way to convert a old functional model into
relational model
-----------------------------------------------------------------------------
Key: TEIIDDES-2775
URL:
https://issues.jboss.org/browse/TEIIDDES-2775
Project: Teiid Designer
Issue Type: Feature Request
Components: Migration, Modeling, Patch Release, Usability
Affects Versions: 9.0.3
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Blocker
Fix For: 9.0.6, 10.0.1
The primary stipulation is that it will no longer be supported from a design time
perspective the ability to create the function model. Consider offering option of an
automated utility of some kind for this migration. There is a manual workaround, but for
the user and usability, we should do this for them.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)