4 Replies Latest reply on Nov 25, 2014 9:46 AM by Stéphane Curet

    4D Database and Teiid

    Stéphane Curet Newbie

      Hello,

       

      I would like to use Teiid with a 4D database.

      Did you know it-is possible, easy, and how to do it ?

       

      Thank you very much for your answers.

       

      Cheers,

       

      Stéphane

        • 1. Re: 4D Database and Teiid
          Ramesh Reddy Master

          Stephane,

           

          Well there is not much information on 4D.com. Looks like it does support SQL. Does it have a JDBC driver? What is the access mechanism they recommend for client applications?

           

          If they have a JDBC driver, you can try using the "jdbc-ansi" or "jdbc-simple" translators to integrate data in it with other sources in Teiid. At worst you may need to write translator and resource-adapter for it, however you may need their JAVA API for it. If they have a ODBC driver, you can try using JDBC-ODBC bridge for access. Check out the Developer's Guide on how develop a new translator and resource-adapter. There are plenty of examples as all the Teiid code is open.

           

          Ramesh..

          • 2. Re: 4D Database and Teiid
            Stéphane Curet Newbie

            Ramesh,

             

            Thank you very much for your answer and your help.

            Unfortunately, 4D doesn't have a jdbc driver !

            They recommand to use http request.

             

            Is-it easy to do a http request test with teiid ? How could i do ?

             

            Cheers,

             

            Stéphane

            • 3. Re: 4D Database and Teiid
              Ramesh Reddy Master

              Yes, you can make HTTP calls through Teiid. You can use "web-service" resource adapter and try to use "web-service" translator or develop your own translator extending the web-service translator but wrapped with nice api to make calls. Check Developer's Guide as to how to develop translator.

              • 4. Re: 4D Database and Teiid
                Stéphane Curet Newbie

                Ramesh,

                 

                Thank you very much.

                I will follow that.

                 

                Cheers,

                 

                Stéphane