[rakeshsagar]

Hi Ramesh,

I am using a Dynamic VDB and using the VDB which I have attached to the earlier posts.

Thanks

Rakesh

[rareddy]

Rakesh,

I have just tested with H2 database and the same VDB attached on this thread, on the latest Teiid 8.6 CR1 version, and I do not see the the issues are mentioning.

1) Can you using Squirrel connect to the VDB and issue the same "select * from Accounts.ACCOUNTS"? did those results came fine?

2) Is SquirreL showing the primary key information?

3) If yes for both above, then http://localhost:8080/odata/DynamicPortfolio.1/$metadata shows the ACCOUNTS table? If the table is not in metadata, turn on DEBUG, OData code prints if a table is skipped in metadata load and reason why? Then fix that issue.

Do not use your modified version of Teiid for your testing.

Ramesh..

[rakeshsagar]

Hi Ramesh,

I tried with 8.6 Beta downloaded from teiid site.

I will try with Teiid 8.6 CR1 and follow the steps you have mentioned and update you.

Thanks

Rakesh.

[rareddy]

There is no difference between 8.6 Beta and CR1 on this functionality