[teiid-users] Simple example (reading a CSV file) needed

[Ramesh Reddy]

Torsten,

Great, glad to hear. Next step define and integrate with another source
and create a virtual layer combining both sources.

Ramesh..

On Tue, 2009-08-25 at 14:39 +0200, Torsten Schlabach wrote:
> 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 at redhat.com>
> >> An: Torsten Schlabach <TSchlabach at gmx.net>
> >> CC: teiid-users at 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.html#jdbc-import-section
> >>
> >>
> >>>> 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.html#new-relational-source-model
> >>
> >>> 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/EmbeddedDesignerExampleVideo.swf
> >>
> >>
> >> Hope this helps.
> >>
> >> Ramesh..
> >>
> >> _______________________________________________
> >> teiid-users mailing list
> >> teiid-users at lists.jboss.org
> >> https://lists.jboss.org/mailman/listinfo/teiid-users
> > _______________________________________________
> > teiid-users mailing list
> > teiid-users at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/teiid-users