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
Comparing to Teiid 8.3 instance running on a different machine, it appears
that I don't have datasources (except the ExampleDS) nor
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 ?
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
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
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.