Model Type when to use Virtual Procedure,Foreign Procedure,View,Physical

sanku_74 Jun 25, 2019 11:22 AM

Is there any guideline for defining model of different type? Like when to use VIRTUAL PROCEDURE,FOREIGN PROCEDURE and so on. What I understood for relational database we use PHYSICAL but for Rest like datasource we use VIRTUAL type. Can anyone share the guideline?

Thanks and Regards

Raja Ghosh

1. Re: Model Type when to use Virtual Procedure,Foreign Procedure,View,Physical

rareddy Jun 25, 2019 1:23 PM (in response to sanku_74)

Typically Model or Schema "type" can be "PHYSICAL" or "VIRTUAL". See DDL VDB · GitBook if omit "VIRTUAL" it means it represents physical external source like MySQL or Webservice etc. When schema type is virtual you can define any view, or virtual stored procedure, or udf functions in that schema.

Ramesh..
Actions
2. Re: Model Type when to use Virtual Procedure,Foreign Procedure,View,Physical

sanku_74 Jun 26, 2019 1:16 AM (in response to rareddy)

Thanks Ramesh for your response. So PHYSICAL is anything that comes from a physical source like relational db,file or webservice,rest service. And Virtural is something generated on top of the Physical model.Is this the correct understanding?
Actions
3. Re: Model Type when to use Virtual Procedure,Foreign Procedure,View,Physical

rareddy Jun 26, 2019 8:05 AM (in response to sanku_74)

Yes, virtual just not on top of the physical, it is an integration layer that you can build "logical" schema (tables, procedures) using any/all of the physical layer's schema objects. I suggest you read this Teiid Basics | Teiid

Then learn about different runtimes Teiid Runtimes | Teiid , note Thorntail one going away, Teiid Spring Boot is where were are focusing more. Then you can run through quick starts to understand.
Actions

Go to original post