10 Replies Latest reply on Dec 21, 2014 8:32 AM by Tarif Ezaz

    How to connect to and retrieve data from CSV files using Teiid?

    Tarif Ezaz Newbie

      Dear all,


      I have been trying to access CSV files for performing CRUD operations using Teiid. I have already inserted the resource adapter in standalone-teiid.xml file. Here's the file specific resource adapter.


      <resource-adapter id="file">

           <module slot="main" id="org.jboss.teiid.resource-adapter.file"/>



                <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory"






                     <config-property name="ParentDirectory">/home/tarif/testing/</config-property>


                     <config-property name="AllowParentPaths">true</config-property>





      I have saved a CSV file under the /home/tarif/testing directory. I have also deployed a virtual database for file. Here's the XML for that file:


      <vdb name="myfileVDB" version= "1">

          <model name = "filemodel">

              <source name="fileitis" translator-name="file" connection-jndi-name="java:/fileDS"/>




      When I am running the ./standalone.sh command, the VDB myfileVDB is being set to active. But when I am running a query using JDBC to show all the available tables, I can't see any name for the CSV file that I have saved inside the /home/tarif/testing directory. Should I somehow need to specify that file so that the information regarding that file becomes visible from Teiid JDBC?