5 Replies Latest reply on Feb 19, 2014 8:43 AM by rareddy

    OData browser?

    gioppoluca
    gioppoluca Feb 18, 2014 10:01 AM

      Hi TEIID people, can you advise an OData browser the WORKS with TEIID?

      I'm trying OData browser, Tableau, Linqpad but on one manage to get data out of TEIID, I'm on version 8.4 of TEIID is it better to upgrade to a later one?

      Thanks

      Luca

        • 1. Re: OData browser?
          rareddy
          rareddy Feb 18, 2014 10:38 AM (in response to gioppoluca)

          Luca,

           

          You can use any browser. I downloaded a REST Client plugin for testing POST/PUT/DELETE. You can also use CURL. The best I liked for far is SOAP-UI, they have introduced REST support in their latest versions.

           

          HTH

           

          Ramesh..

            • Actions
          • 2. Re: OData browser?
            gioppoluca
            gioppoluca Feb 18, 2014 2:01 PM (in response to rareddy)

            I know that is possible to use a browser, but I'd like to use these tools for browsing odata and they to not work with TEIID.

            Is the fact that they do not maange to read odata from TEIID due to the not complete compliance with version 3 of specification?

            Or the other option is that I am doing something wrong, in this case can you shed an example?

            Thanks

            Luca

              • Actions
            • 3. Re: OData browser?
              rareddy
              rareddy Feb 18, 2014 2:09 PM (in response to gioppoluca)

              Ok. Yes, Teiid OData is only v2 compatible. v3 support is not available yet as  odata4j framework we used does not yet support it.

                • Actions
              • 4. Re: OData browser?
                gioppoluca
                gioppoluca Feb 18, 2014 7:02 PM (in response to rareddy)

                Here is the error from Linqpad that should work with the lib (at least is what they say on theyr website)

                MetadataException: Schema specificato non valido. Errori:

                (0,0) : errore 0075: Parte della chiave: 'SchemaName' per il tipo Columns non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'SchemaName' per il tipo KeyColumns non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'SchemaName' per il tipo Keys non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'SchemaName' per il tipo ProcedureParams non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'SchemaName' per il tipo Procedures non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'VDBName' per il tipo Schemas non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'Name' per il tipo Schemas non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'VDBName' per il tipo Tables non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'SchemaName' per il tipo Tables non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'resourcePath' per il tipo VDBResources non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'oid' per il tipo matpg_datatype non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'name' per il tipo matpg_datatype non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'attname' per il tipo matpg_relatt non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'relname' per il tipo matpg_relatt non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'nspname' per il tipo matpg_relatt non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'oid' per il tipo pg_attribute non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'oid' per il tipo pg_class non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'oid' per il tipo pg_index non valida. Tutte le parti della chiave devono essere non nullable.

                (0,0) : errore 0075: Parte della chiave: 'oid' per il tipo pg_proc non valida. Tutte le parti della chiave devono essere non nullable.

                 

                And this is the result of the http://localhost:8080/odata/ricettivitaVDB/$metadata

                 

                <edmx:Edmx Version="1.0"><edmx:DataServices m:DataServiceVersion="2.0"><Schema Namespace="ricettivita"><ComplexType Name="getTextFiles_Result"><Property Name="file" Type="Edm.Binary" Nullable="true"/><Property Name="filePath" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/></ComplexType><EntityContainer Name="ricettivita" m:IsDefaultEntityContainer="false"><FunctionImport Name="getTextFiles" ReturnType="Collection(ricettivita.getTextFiles_Result)" m:HttpMethod="GET"><Parameter Name="pathAndExt" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="ricettivita_rest"><ComplexType Name="getRicettivita_NewProcedureResult"><Property Name="ricettivita" Type="Edm.Binary" Nullable="true"/></ComplexType><EntityContainer Name="ricettivita_rest" m:IsDefaultEntityContainer="false"><FunctionImport Name="getRicettivita" ReturnType="Collection(ricettivita_rest.getRicettivita_NewProcedureResult)" m:HttpMethod="GET"/></EntityContainer></Schema><Schema Namespace="ricettivita_view"><EntityType Name="ricettivita_csvView"><Key><PropertyRef Name="Denominazione_struttura"/></Key><Property Name="Settore_Alberghiero_Extralberghiero" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="CAP" Type="Edm.String" Nullable="false" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Comune" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Provincia" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Denominazione_struttura" Type="Edm.String" Nullable="false" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Indirizzo_completo" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Qualifica" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Stelle" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Telefono" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Fax" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="e_mail" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Camere" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Letti" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Bagni" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/></EntityType><EntityContainer Name="ricettivita_view" m:IsDefaultEntityContainer="false"><EntitySet Name="ricettivita_csvView" EntityType="ricettivita_view.ricettivita_csvView"/></EntityContainer></Schema><Schema Namespace="SYS"><EntityType Name="Columns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Length" Type="Edm.Int32" Nullable="false"/><Property Name="IsLengthFixed" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsSelect" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCurrency" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="MinRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="MaxRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="DistinctCount" Type="Edm.Int32" Nullable="true"/><Property Name="NullCount" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="Format" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DefaultValue" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="CharOctetLength" Type="Edm.Int32" Nullable="true"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Columns_FK0" FromRole="Columns" ToRole="Tables"/><NavigationProperty Name="DataTypes" Relationship="SYS.Columns_FK1" FromRole="Columns" ToRole="DataTypes"/></EntityType><EntityType Name="DataTypes"><Key><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="IsStandard" Type="Edm.Boolean" Nullable="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="true"/><Property Name="TypeName" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="true"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="RuntimeType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="BaseType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK1" FromRole="DataTypes" ToRole="Columns"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK1" FromRole="DataTypes" ToRole="ProcedureParams"/></EntityType><EntityType Name="KeyColumns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.KeyColumns_FK0" FromRole="KeyColumns" ToRole="Tables"/></EntityType><EntityType Name="Keys"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsIndexed" Type="Edm.Boolean" Nullable="false"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Keys_FK0" FromRole="Keys" ToRole="Tables"/></EntityType><EntityType Name="ProcedureParams"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ProcedureName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Optional" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.ProcedureParams_FK0" FromRole="ProcedureParams" ToRole="Procedures"/><NavigationProperty Name="DataTypes" Relationship="SYS.ProcedureParams_FK1" FromRole="ProcedureParams" ToRole="DataTypes"/></EntityType><EntityType Name="Procedures"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ReturnsResults" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK0" FromRole="Procedures" ToRole="ProcedureParams"/><NavigationProperty Name="Schemas" Relationship="SYS.Procedures_FK0" FromRole="Procedures" ToRole="Schemas"/></EntityType><EntityType Name="Properties"><Key><PropertyRef Name="UID"/><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Value" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><Property Name="ClobValue" Type="Edm.Binary" Nullable="true"/></EntityType><EntityType Name="Schemas"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="PrimaryMetamodelURI" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.Procedures_FK0" FromRole="Schemas" ToRole="Procedures"/><NavigationProperty Name="Tables" Relationship="SYS.Tables_FK0" FromRole="Schemas" ToRole="Tables"/></EntityType><EntityType Name="Tables"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="false"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsSystem" Type="Edm.Boolean" Nullable="true"/><Property Name="IsMaterialized" Type="Edm.Boolean" Nullable="false"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK0" FromRole="Tables" ToRole="Columns"/><NavigationProperty Name="KeyColumns" Relationship="SYS.KeyColumns_FK0" FromRole="Tables" ToRole="KeyColumns"/><NavigationProperty Name="Keys" Relationship="SYS.Keys_FK0" FromRole="Tables" ToRole="Keys"/><NavigationProperty Name="Schemas" Relationship="SYS.Tables_FK0" FromRole="Tables" ToRole="Schemas"/></EntityType><EntityType Name="VirtualDatabases"><Key><PropertyRef Name="Name"/><PropertyRef Name="Version"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Version" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/></EntityType><ComplexType Name="getXMLSchemas_RSParam"><Property Name="schema" Type="Edm.Binary" Nullable="true"/></ComplexType><Association Name="Columns_FK0"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Columns_FK1"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="KeyColumns_FK0"><End Type="SYS.KeyColumns" Multiplicity="*" Role="KeyColumns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="KeyColumns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Keys_FK0"><End Type="SYS.Keys" Multiplicity="*" Role="Keys"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Keys"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK0"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.Procedures" Multiplicity="0..1" Role="Procedures"/><ReferentialConstraint><Principal Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK1"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="Procedures_FK0"><End Type="SYS.Procedures" Multiplicity="*" Role="Procedures"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><Association Name="Tables_FK0"><End Type="SYS.Tables" Multiplicity="*" Role="Tables"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><EntityContainer Name="SYS" m:IsDefaultEntityContainer="false"><EntitySet Name="Columns" EntityType="SYS.Columns"/><EntitySet Name="DataTypes" EntityType="SYS.DataTypes"/><EntitySet Name="KeyColumns" EntityType="SYS.KeyColumns"/><EntitySet Name="Keys" EntityType="SYS.Keys"/><EntitySet Name="ProcedureParams" EntityType="SYS.ProcedureParams"/><EntitySet Name="Procedures" EntityType="SYS.Procedures"/><EntitySet Name="Properties" EntityType="SYS.Properties"/><EntitySet Name="Schemas" EntityType="SYS.Schemas"/><EntitySet Name="Tables" EntityType="SYS.Tables"/><EntitySet Name="VirtualDatabases" EntityType="SYS.VirtualDatabases"/><AssociationSet Name="Columns_FK0" Association="SYS.Columns_FK0"><End EntitySet="Columns" Role="Columns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Columns_FK1" Association="SYS.Columns_FK1"><End EntitySet="Columns" Role="Columns"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="KeyColumns_FK0" Association="SYS.KeyColumns_FK0"><End EntitySet="KeyColumns" Role="KeyColumns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Keys_FK0" Association="SYS.Keys_FK0"><End EntitySet="Keys" Role="Keys"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="ProcedureParams_FK0" Association="SYS.ProcedureParams_FK0"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="Procedures" Role="Procedures"/></AssociationSet><AssociationSet Name="ProcedureParams_FK1" Association="SYS.ProcedureParams_FK1"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="Procedures_FK0" Association="SYS.Procedures_FK0"><End EntitySet="Procedures" Role="Procedures"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><AssociationSet Name="Tables_FK0" Association="SYS.Tables_FK0"><End EntitySet="Tables" Role="Tables"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><FunctionImport Name="getXMLSchemas" ReturnType="Collection(SYS.getXMLSchemas_RSParam)" m:HttpMethod="GET"><Parameter Name="document" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="SYSADMIN"><EntityType Name="MatViews"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetSchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetName" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Valid" Type="Edm.Boolean" Nullable="true"/><Property Name="LoadState" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Updated" Type="Edm.DateTime" Nullable="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="Triggers"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TriggerType" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="TriggerEvent" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Status" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Body" Type="Edm.Binary" Nullable="true"/><Property Name="TableUID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/></EntityType><EntityType Name="VDBResources"><Key><PropertyRef Name="resourcePath"/></Key><Property Name="resourcePath" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="contents" Type="Edm.Binary" Nullable="true"/></EntityType><ComplexType Name="matViewStatus_RSParam"><Property Name="TargetSchemaName" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="TargetName" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Valid" Type="Edm.Boolean" Nullable="true"/><Property Name="LoadState" Type="Edm.String" Nullable="true" MaxLength="25" FixedLength="false" Unicode="true"/><Property Name="Updated" Type="Edm.DateTime" Nullable="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="true"/><Property Name="LoadNumber" Type="Edm.Int32" Nullable="true"/><Property Name="OnErrorAction" Type="Edm.String" Nullable="true" MaxLength="25" FixedLength="false" Unicode="true"/></ComplexType><EntityContainer Name="SYSADMIN" m:IsDefaultEntityContainer="false"><EntitySet Name="MatViews" EntityType="SYSADMIN.MatViews"/><EntitySet Name="Triggers" EntityType="SYSADMIN.Triggers"/><EntitySet Name="VDBResources" EntityType="SYSADMIN.VDBResources"/><FunctionImport Name="isLoggable" m:HttpMethod="POST"><Parameter Name="loggable" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="loadMatView" ReturnType="Edm.Int32" m:HttpMethod="GET"><Parameter Name="schemaName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="viewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="invalidate" Type="Edm.Boolean" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="logMsg" m:HttpMethod="POST"><Parameter Name="logged" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="msg" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="matViewStatus" ReturnType="Collection(SYSADMIN.matViewStatus_RSParam)" m:HttpMethod="GET"><Parameter Name="schemaName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="viewName" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatView" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Invalidate" Type="Edm.Boolean" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatViewRow" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Key" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="setColumnStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="columnName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="distinctCount" Type="Edm.Int64" Mode="In" Nullable="true"/><Parameter Name="nullCount" Type="Edm.Int64" Mode="In" Nullable="true"/><Parameter Name="max" Type="Edm.String" Mode="In" Nullable="true"/><Parameter Name="min" Type="Edm.String" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setProperty" m:HttpMethod="POST"><Parameter Name="OldValue" Type="Edm.Binary" Nullable="false"/><Parameter Name="UID" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Name" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Value" Type="Edm.Binary" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setTableStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="cardinality" Type="Edm.Int64" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="updateMatView" ReturnType="Edm.Int32" m:HttpMethod="GET"><Parameter Name="schemaName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="viewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="refreshCriteria" Type="Edm.String" Mode="In" Nullable="true"/></FunctionImport></EntityContainer></Schema><Schema Namespace="pg_catalog"><EntityType Name="matpg_datatype"><Key><PropertyRef Name="oid"/><PropertyRef Name="name"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="typname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="name" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="uid" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="typlen" Type="Edm.Int16" Nullable="true"/></EntityType><EntityType Name="matpg_relatt"><Key><PropertyRef Name="attname"/><PropertyRef Name="relname"/><PropertyRef Name="nspname"/></Key><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="nspname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="autoinc" Type="Edm.Boolean" Nullable="true"/><Property Name="typoid" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="pg_attribute"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="atttypid" Type="Edm.Int32" Nullable="true"/><Property Name="attlen" Type="Edm.Int16" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="atttypmod" Type="Edm.Int32" Nullable="true"/><Property Name="attnotnull" Type="Edm.Boolean" Nullable="true"/><Property Name="attisdropped" Type="Edm.Boolean" Nullable="true"/><Property Name="atthasdef" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_class"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relnamespace" Type="Edm.Int32" Nullable="true"/><Property Name="relkind" Type="Edm.String" Nullable="true"/><Property Name="relam" Type="Edm.Int32" Nullable="true"/><Property Name="reltuples" Type="Edm.Single" Nullable="true"/><Property Name="relpages" Type="Edm.Int32" Nullable="true"/><Property Name="relhasrules" Type="Edm.Boolean" Nullable="true"/><Property Name="relhasoids" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_index"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="indexrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indnatts" Type="Edm.Int16" Nullable="true"/><Property Name="indisclustered" Type="Edm.Boolean" Nullable="true"/><Property Name="indisunique" Type="Edm.Boolean" Nullable="true"/><Property Name="indisprimary" Type="Edm.Boolean" Nullable="true"/><Property Name="indkey" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="indexprs" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="indpred" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/></EntityType><EntityType Name="pg_proc"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="proname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="proretset" Type="Edm.Boolean" Nullable="true"/><Property Name="prorettype" Type="Edm.Int32" Nullable="true"/><Property Name="pronargs" Type="Edm.Int16" Nullable="true"/><Property Name="proargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="proargnames" Type="Edm.Binary" Nullable="true"/><Property Name="proargmodes" Type="Edm.Binary" Nullable="true"/><Property Name="proallargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="pronamespace" Type="Edm.Int32" Nullable="true"/></EntityType><EntityContainer Name="pg_catalog" m:IsDefaultEntityContainer="false"><EntitySet Name="matpg_datatype" EntityType="pg_catalog.matpg_datatype"/><EntitySet Name="matpg_relatt" EntityType="pg_catalog.matpg_relatt"/><EntitySet Name="pg_attribute" EntityType="pg_catalog.pg_attribute"/><EntitySet Name="pg_class" EntityType="pg_catalog.pg_class"/><EntitySet Name="pg_index" EntityType="pg_catalog.pg_index"/><EntitySet Name="pg_proc" EntityType="pg_catalog.pg_proc"/></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>

                  • Actions
                • 5. Re: OData browser?
                  rareddy
                  rareddy Feb 19, 2014 8:43 AM (in response to gioppoluca)

                  Are you using VDB import to stack VDBS? It is complaining about system models here. Can you provide sample VDB to test it locally?

                    • Actions