4 Replies Latest reply on Dec 13, 2010 8:40 AM by colo

    Designer - VDB from a CSV

    colo Newbie

      Hi,
      I'm treating to build a very simple VDB in Teiid Designer from a CSV file. I would to see the data like a relational schema, so I define a source model, then import the csv file into a relation table, and then I have to set de connection profile. These step are right?
      The problem that I have, is that I don't know how to create a file connector from a csv file, in my eclipse does not appear the connector views. Perhaps I don't find it, but it is configurated.

      Hi,

       

      I'm treating to build a very simple VDB in Teiid Designer from a CSV file. I would to see the data like a relational schema, so I define a source model, import the csv file into a relation table, and thenI have to set de connection profile. These step are right?

      The problem that I have, is that I don't know how to create a file connector from a csv file, in my eclipse does not appear the connector views or connection editor. Perhaps I don't find it, but it is configurated.

      I don't know if I doing something wrong, in this case, please tell me the way to follow.

      Thanks very much for your attention.

      Rewards.

       

      Colo

        • 1. Re: Designer - VDB from a CSV
          Ramesh Reddy Master

          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 Newbie

            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ás

            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 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
              Ramesh Reddy Master

              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 Newbie

                Thanks very much, it's works perfectly!

                 

                Nicolás