Model with Loopback translator in Teiid 8

[rokhmanov]

Is it possible to define a model with loopback translator in Teiid 8 and get a sample data using any sql cllient, like SQuirreL?

I am deploying this sample vdb:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<vdb name="DynamicPortfolio" version="1">

    <model name="LoopTest">

        <source name="Loop" translator-name="loopback-sample"/>

    </model>

</vdb>

Unfortunately the "DynamicPortfolio" does not became active.

Here is what I see in server.log:

17:11:00,160 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB DynamicPortfolio.1 model "LoopTest" metadata is currently being loaded. Start Time: 7/3/12 5:11 PM

17:11:00,183 TRACE [org.teiid.RUNTIME] (MSC service thread 1-2) Model  LoopTest in VDB  DynamicPortfolio  was being loaded from its repository

17:11:00,226 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB DynamicPortfolio.1 model "LoopTest" metadata loaded. End Time: 7/3/12 5:11 PM

17:11:00,252 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model LoopTest

17:11:00,256 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB DynamicPortfolio.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

I use Teiid 8.1.0.Alpha3

Thanks,

Andriy

[rareddy]

Andriy,

Loopback translator does not have "getMetadata" call implemented that can work Dynamic VDBs. It is designed for the Designer based models where the metadata is defined but there is no source defined.  You can use Loopback with Dynamic VDB in 8.0, but you need to define the metadata using the DDL described here https://docs.jboss.org/author/display/TEIID/DDL+Metadata

Ramesh..

[rokhmanov]

Thanks Ramesh,

As explained in wiki I defined sample metadata for Loopback translator (used FOREIGN TABLE for that purpose), it works well:

              <[CDATA[
               CREATE FOREIGN TABLE TEST (
                    intkey integer PRIMARY KEY,
                    intval integer 
               ) 
          ]]>