Importing schemas and source models in Teiid designer

[mdahlman]

Hi all,

I'm new to Teiid Designer; I have run into what is likely a very simple problem, but it's preventing me from getting very far.

I went through the quickstart tutorial (http://www.jboss.org/teiid/quickstart.html), but I got stuck. The steps were like this:

1. Switch to the Designer Perspective. OK.
2. Create new "Model Project". No problem.
3. Import the Derby database's "account" schema into a source model. Uh oh. I don't see what context menu I need. There's one called "Schema"... but I don't see how to use it.
   
4. Manually create the source model for the "Text File". Hmm... I am missing something simple somewhere.

Presumably the author didn't mention the menu choices or toolbar icon because it's so obvious... but just don't see it.

To be precise, I'm looking at this page:

http://docs.jboss.org/teiid/6.1/quick-start-guide/en-US/html/designer.html

You can see in the screenshot that the model appears to be working well. The menu I need is no doubt right there. Likewise, I successfully created the portfolio tables in MySQL and (as shown in the image) I created a connection pointing to them. But I don't see how to read in the table definitions. The same goes for the text file. I can create a table with appropriately named columns... but somehow I don't see how to link it to my text file.

Any help in getting this working would be much appreciated.

Regards,

Matt

[blafond]

Matthew,

The "Import" schema action you are looking for is located within the generic Eclipse's Import action. The main import dialog will contain Teiid Designer's import action contributions.

Details can be found in Teiid Designer's documentation at: http://docs.jboss.org/teiid/designer/6.0/user-guide/importers-chapter.html/

More specifically, importing schema from JDBC is found at:  http://docs.jboss.org/teiid/designer/6.0/user-guide/importers-chapter.html#jdbc-import-section

Barry LaFond

Teiid Designer Project Lead

[e-mail]

[rareddy]

Matthew,

You can also refer to this video, which shows the steps involved with the Quick Start example.

http://docs.jboss.org/teiid/6.2/quick-start-guide/en-US/html/images/EmbeddedDesignerExampleVideo.swf

Ramesh..

[mdahlman]

Ramesh,

Thaks a lot for this. I was looking for that video since the page I list above mentions the existence of such a video. But it doesn't include a link to it. How did you find this?

The video is a great help. I still have not succeeded in finishing the tutorial, but I'll start another thread with the new blocking issue.

-Matt

[mdahlman]

Barry,

Thanks, this is very helpful. FYI: your link includes a slash at the end which yields a 404 error. Removing the slash is easy enough... it just took me a bit to realize what was going on. ;-)

-Matt

[rareddy]

Matt,

I am the one to blame for this -:) The quick start example is written using the "doc book", even though the link is there to show the video, while rendering the page to html it ignores to put the embedded video. In next version, I will just list the link as text then it may show up with out any issues.

Ramesh..