-
1. Re: VDB Not Deployed
rareddy Apr 28, 2014 10:31 PM (in response to carvalho27)1 of 1 people found this helpfulAl,
When you are building the VDB, int he VDB explorer, you can define the translator names for your source models to represent what kind of sources. Make sure that are correctly defined as mssql and mysql5 before you deploy the VDB.
Ramesh..
-
2. Re: VDB Not Deployed
carvalho27 Apr 29, 2014 8:05 AM (in response to rareddy)Ramesh -
Thanks so much again !
Sql Server translator was 'sqlserver' - I changed to mssql as you
suggested although I noticed that it was named 'sqlserver' in my Teiid 8.3
environment.
Comparing to Teiid 8.3 instance running on a different machine, it appears
that I don't have datasources (except the ExampleDS) nor
translators deployed.
It's been awhile since I set up Teiid 8.3 so could use some help finding
correct documentation to define datasources and translators - both defined
in standalone-teiid.xml ?
-
3. Re: VDB Not Deployed
rareddy Apr 29, 2014 8:45 AM (in response to carvalho27)Al,
My mistake, "sqlserver" is right translator name. Just remember that for *every* source model, you need to configure with "translator" name and "jndi" name of the datasource. Also you need to create the datasource with the representative JNDI name in the server before you can deploy VDB in the server.
Now, based on how started your project in Designer and how you imported the source models, some of these tasks are automatically done for you. If you imported a old project the data source may not be there, but you can right click -> modeling-> create datasource to create a data source. Or you can manually edit the standalone-teiid.xml file and add needed XML to create the required data source.
If you forgot how Teiid works, I suggest you going through the Quick Starts and watch videos and spend some time learning how the tool works, before attempting to build your usecase. All the Teiid documentation on http://teiid.org main site at Home - Teiid 8.8 (draft) - Project Documentation Editor , the Designer Documents at Documentation - JBoss Community, Quick Starts Home - Teiid Examples - Project Documentation Editor, Videos https://www.youtube.com/playlist?list=PLrimh1JUHOFKMRo73BKbJFUERXzaCynqB
HTH
Ramesh..
-
4. Re: VDB Not Deployed
carvalho27 Apr 29, 2014 10:41 AM (in response to rareddy)Almost there -
- edited VDB translator values
- deployed datasources successfully by editing standalone-teiid.xml
Final issue seems to be that I don't see any translators ('Translators' not in the tree view - only 'Data Sources') in my Teiid Instance ??
-
Missing Translators.png 106.0 KB
-
5. Re: VDB Not Deployed
rareddy Apr 29, 2014 11:12 AM (in response to carvalho27)Al,
It is a Designer bug that I also encountered a while back. Not to throw wrench into your efforts (which I very much appreciate), I am starting to doubt Designer 8.5 Alpha support for 8.6. Last I checked Teiid Designer 8.4 worked with Teiid 8.6. There has been some work done recently to make Teiid Designer 8.5 Alpha to work with Teiid 8.7.
So, your options are
1) Move to Teiid Designer 8.4
2) Upgrade Teiid to 8.7
3) Build your VDB with your current Designer, but once you build your VDB, take the VDB and manually deploy it into the Teiid Server, and then use tools like SquirreL (JDBC Client Tool) to issue queries and test.
Ramesh..