3 Replies Latest reply on Oct 9, 2019 9:22 AM by rareddy

How to get metadata for View in db?

i3draven Oct 9, 2019 8:27 AM

Hi, All
Can you help me with teiid-spring-boot and teiid-odata?

1. We have vertica db and jdbc connection for it.

2. teiid-spring-boot project with teiid-odata

How we can get metadata for vertica Views? Now we have only for tables.

Properties for connection

spring.datasource.vertica.jdbc-url=jdbc:vertica://local:5433/test?SearchPath=bi

spring.datasource.vertica.username=user

spring.datasource.vertica.password=password

spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver

spring.datasource.vertica.platform=vertica

spring.datasource.vertica.importer.SchemaName=bi

spring.datasource.vertica.importer.DatabaseTimeZone=UTC

spring.datasource.vertica.importer.UseFullSchemaName=false

spring.teiid.model.package=com.test.model

1. Re: How to get metadata for View in db?

rareddy Oct 9, 2019 8:34 AM (in response to i3draven)

If you are looking OData metadata, once you start the application considering on localhost, use the address "http://localhost:8080/odata/vertica/$metadata" or simply http://localhost:8080/odata/vertica/$metadata the second only applicable when there is a single source.
Actions
2. Re: How to get metadata for View in db?

i3draven Oct 9, 2019 9:03 AM (in response to rareddy)

I checked both

http://localhost:8080/odata/vertica/$metadata
http://localhost:8080/odata/$metadata

We have tables and views in db

But only tables found in metadata (Edm)

<?xml version="1.0" encoding="UTF-8"?>
<edmx:Edmx Version="4.0"
xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
<edmx:Reference Uri="http://localhost:8080/static/org.teiid.v1.xml">
    <edmx:Include Namespace="org.teiid.v1" Alias="teiid"></edmx:Include>
</edmx:Reference>
<edmx:Reference Uri="http://localhost:8080/static/org.apache.olingo.v1.xml">
    <edmx:Include Namespace="org.apache.olingo.v1" Alias="olingo-extensions"></edmx:Include>
</edmx:Reference>
<edmx:DataServices>
    <Schema
      xmlns="http://docs.oasis-open.org/odata/ns/edm" Namespace="spring.1.0.0.vertica" Alias="vertica">
      <EntityType Name="account">

......and more tables, no views
Actions
3. Re: How to get metadata for View in db?

rareddy Oct 9, 2019 9:22 AM (in response to i3draven)

To be exposed through OData the tables or view MUST have a primary key defined on them, without it will ignore those.
Actions

Go to original post