Teiid Spring Boot, concerns regarding VDB being deprecated

0
votes

I am working for my new project wherein I am required to interact with multiple data sources and execute join queries, I created VDB using Teiid Designer and deployed it on JBoss AS 15.0.1 and pulled data using separate Java / Spring Boot Application and it worked well.

I have been seriously considering Teiid as it fits the bill for me, however, I have read about Teiid Designer / VDB being deprecated / not supported in the future and hence I am concerned.

I have few queries and I will list it down here:

  1. What would you suggest if VDB will not be supported in future, I was considering Teiid Spring Boot, but I was not able to run a single sample scenario successfully with 2 Data Sources using Teiid Spring Boot.
  2. As i said that i have created and deployed my VDB and used another Java / Spring Boot application to pull data using VDB at the run time, so my question is, while this approach works fine for a test scenario, is this the best practice? or in other words is there a better way of doing things that's more efficient.

Can someone kindly address my concerns, thanks in advance!

thank you, purnima das

1
spring-bootteiid

1 Answers

0
votes

Sorry to hear that you are having trouble with Teiid. I suspect those are due to some spring boot nuances in terms of how the startup is being wired.

1) First of all Teiid project is not going away, the WildFly based installation is still supported and VDB based deployment is still is a valid path. You can still use this.

2) We are not contributing anymore to the Eclipse-based Teiid Designer. You can still use the old version, the VDB generated is still valid, may not have any new language features.

3) Teiid Spring Boot is not a replacement of Teiid. It is a layer above to simplify the java development of bringing together the data sources more native way to a java developer.

4) Teiid Spring Boot supports two modes

  • Entity based View definition (non-vdb mode, using annotations, still tech preview). see example here.
  • A VDB based deployment. That means you can take the VDB from the previous steps. The difference is the VDB supported is a DDL based VDB, not a Binary VDB generated from a Teiid Designer. You can use Teiid Designer to export to an XML version of a VDB, then use another tool we provide to convert to a DDL based one. See example here with this model.

5) Teiid Spring Boot is more focused on cloud-based developments. In your case, you can embed with your Java application such that it does not require a separate process and connect to the external process to access data, i.e. it will be much faster as there one less step of moving data.

6) As per tooling, we are working on VSCode plugin that helps develop a DDL based VDB, but we are not there yet. Also we are part of the Syndesis project.