Datum: Mon, 24 Aug 2009 12:23:43 -0500 Von: Ramesh Reddy <rareddy(a)redhat.com&gt; An: Torsten Schlabach <TSchlabach(a)gmx.net&gt; CC: teiid-users(a)lists.jboss.org Betreff: Re: [teiid-users] Simple example (reading a CSV file) needed

On Mon, 2009-08-24 at 12:17 +0200, Torsten Schlabach wrote: > Where in the Designer would I have to create those two files? Looking at the examples in the designer, I cannot spot any files which look like that. These are simple text files, you can create them using any text editor either using eclipse or some other external editor. > > 3. Import the Derby database's "account" schema into a source model. > > How would I do that??? If go to File -> Import -> Import from JDBC once the wizard comes up follow it to define the connection and importing metadata http://docs.jboss.org/teiid/designer/6.0/user-guide/importers-chapter.htm... > > > 4. Manually create the source model for the "Text File". Create a Table > called "Price" with "stock" and "price" as column names > > Again, how would I do that? I don't see anything called "Source Model" in my designer. > see http://docs.jboss.org/teiid/designer/6.0/user-guide/newmodels-chapter.htm... > Also for the remaining steps, I just cannot find the elements in my designer which the steps talk about. > > Any hints are welcome! > There is video, for which a link is missing. Watch this http://docs.jboss.org/teiid/6.1/quick-start-guide/en-US/html/images/Embed... Hope this helps. Ramesh.. _______________________________________________ teiid-users mailing list teiid-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-users

Hi! I was able to solve my problem. > 1. Despite having a Connector connected to my model, I don't get this > "Running man" icon enabled to try and see my data from my CSV file. It shows up as soon as I click on the table element in the diagram. Makes sense as if I don't select any table, which table would I want to preview? (Clapping on forehead.) I can also execute the VDB now and execute select statements against my CSV file. Thank you for your help. Regards, Torsten P.S.: I have a tiny problem left, but to make it clearer, I will open a separate thread. Torsten Schlabach schrieb: > Hi Ramesh! > > Thanks for your hints, especially for the missing link to the video. This indeed helped me a lot. > > I am not stuck with 2 problems, no idea if they are related or not: > > 1. Despite having a Connector connected to my model, I don't get this "Running man" icon enabled to try and see my data from my CSV file. > 2. When I try and execute the VDB and try to make a SELECT * from from my virtual table which is a CSV file, I am stuck with this expection: > > Caused by: org.teiid.connector.api.ConnectorException: Error trying to obtain connector metadata properties for sample.NewBaseTable. Group properties are not specified in the descriptor file. > > What are those "group properties" mentioned there? > > Regards, > Torsten > > -------- Original-Nachricht -------- >> Datum: Mon, 24 Aug 2009 12:23:43 -0500 >> Von: Ramesh Reddy <rareddy(a)redhat.com&gt; >> An: Torsten Schlabach <TSchlabach(a)gmx.net&gt; >> CC: teiid-users(a)lists.jboss.org >> Betreff: Re: [teiid-users] Simple example (reading a CSV file) needed > >> On Mon, 2009-08-24 at 12:17 +0200, Torsten Schlabach wrote: >>> Where in the Designer would I have to create those two files? Looking at >> the examples in the designer, I cannot spot any files which look like >> that. >> These are simple text files, you can create them using any text editor >> either using eclipse or some other external editor. >> >> >>>> 3. Import the Derby database's "account" schema into a source model. >>> How would I do that??? >> If go to File -> Import -> Import from JDBC >> once the wizard comes up follow it to define the connection and >> importing metadata >> http://docs.jboss.org/teiid/designer/6.0/user-guide/importers-chapter.htm... >> >> >>>> 4. Manually create the source model for the "Text File". Create a >> Table >>> called "Price" with "stock" and "price" as column names >>> >>> Again, how would I do that? I don't see anything called "Source Model" >> in my designer. >> see >> http://docs.jboss.org/teiid/designer/6.0/user-guide/newmodels-chapter.htm... >> >>> Also for the remaining steps, I just cannot find the elements in my >> designer which the steps talk about. >>> Any hints are welcome! >>> >> There is video, for which a link is missing. Watch this >> http://docs.jboss.org/teiid/6.1/quick-start-guide/en-US/html/images/Embed... >> >> >> Hope this helps. >> >> Ramesh.. >> >> _______________________________________________ >> teiid-users mailing list >> teiid-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/teiid-users > _______________________________________________ > teiid-users mailing list > teiid-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/teiid-users