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

[Torsten Schlabach]

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