Looks like the Oracle is returning more metadata then expected. You can limit the metadata returned by adding the following filters in the -vdb.xml file under the model element defined for the oracle.
See here for the -vdb.xml format. https://docs.jboss.org/author/display/TEIID/VDB+Definition
Also, take look at Teiid Designer after you finish with Quick Start, which provides tooling for developing the Teiid VDB.
That helped a lot. I could resolve the Oracle error.
Now I have two issues:
1. This is more of an observation. I configured my VDB to use oracle and a CSV file. Then I used Teiid jdbc driver to connect to my VDB using Squirell. I could see the tables and schema for oracle but against CSV file I could only see stored procedures and no tables were seen. I had hoped to see a table against my CSV file. Comments??
2. I am having trouble adding a SQL server datasource.I get the following error for SQL server. I tried searching but could not find any document that talks about configuring datasources of different types. I can connect from Squirell using the same connection string that I used with teiid configuration file.
Error Code:TEIID31097 Message:TEIID31097 Connection Factory (no data source found) provided is null; Can not proceed with metadata load.
Do you know of any document that talks about setting datasources for different data types.
Message was edited by: Akash Sharma
1) See this for CSV file tables https://community.jboss.org/docs/DOC-15673 there is more work you need to to show the tables. Teiid Designer does provide a wizard to help with these table creations.
2) In your -vdb.xml file, under the model that defined for SQLServer, you have not defined "connection-jndi-name" on "source" element. It should look like
<source name="accounts" translator-name="sqlserver" connection-jndi-name="java:/sqlServerDS"/>