-
1. Re: Designer - VDB from a CSV
rareddy Dec 8, 2010 4:54 PM (in response to colo)Nicolas,
Have you checked out "Dynamic VDB" in the Teiid. If your VDB does not require "view" layer, you need to use this feature. Here, the VDB is a XML file backed by a schema.
If you need to define a view layer, then current option as of Teiid 7.2 is to use Designer. Although, you can import a model from CSV file using "Metadata from Text files on file system" or use "DDL into Relational Model" importers, this only goes as far as defining a model, not a VDB. You still need to manually need to build the VDB and define the translators and connection profiles for this VDB. There is no way to define these using a CSV file nor planned.
My suggestion is take a look at the Dynamic VDB first, if that does not solve your usecase, please explain clearly your usecase and what you are trying achieve, we can try to provide some direction.
Thank you.
Ramesh..
-
2. Re: Designer - VDB from a CSV
colo Dec 9, 2010 7:15 AM (in response to rareddy)Ramesh,The use case is to consult a set of data from the csv files, as if I had a relational schema. I do not want to create a physical relational database to store data, but that it appears to be.I have checked out "Dynamic VDB" and it resolves perfectly the usecase. But now, I would to explore the Designer and I wondered if I could use a file connector like with the "Dynamic VDB". I want to build the same example but in the Designer. At first my usecase is very simple, but then the idea is add a "view" layer and then web services source model.I apologize for my english, sometimes not express myself clearly, I'm uruguayan and it's not easy to me transmit the idea.With the problem of the connector option in the bar, have any idea of the reason? I use Eclipse 3.6.1 (Helios)Thanks very much.NicolásRamesh,
The use case is to consult a set of data from the csv files, as if I had a relational schema. I do not want to create a physical relational database to store data, but that it appears to be.
I have checked out "Dynamic VDB" and it resolves perfectly the usecase. But now, I would to explore the Designer and I wondered if I could use a file connector like with the "Dynamic VDB". I want to build the same example but in the Designer. At first my usecase is very simple, but then the idea is add a "view" layer and then web services source model.
I apologize for my english, sometimes not express myself clearly, I'm uruguayan and it's not easy to me transmit the idea.
With the problem of the connector option in the tool bar, have any idea of the reason? I use Eclipse 3.6.1 (Helios)
Thanks very much.
Nicolás
-
3. Re: Designer - VDB from a CSV
rareddy Dec 9, 2010 11:29 AM (in response to colo)Nicolas,
Previously I thought you have to create the models from the CSV file, but from the above it is clear that you have the *data* in the CSV files and would like to read them like relational tables. For that I suggest reading this article. Please note that this starts out with a example of Dynamic VDB, but towards the end it explains how you can take this to Designer and create view on top it. Try this and let us know if you run into issues.
Thanks.
Ramesh..
-
4. Re: Designer - VDB from a CSV
colo Dec 13, 2010 8:40 AM (in response to colo)Thanks very much, it's works perfectly!
Nicolás