-
1. Re: 4D Database and Teiid
rareddy Nov 21, 2014 10:52 AM (in response to stephuniv)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
stephuniv Nov 25, 2014 4:15 AM (in response to rareddy)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
rareddy Nov 25, 2014 9:28 AM (in response to stephuniv)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
stephuniv Nov 25, 2014 9:46 AM (in response to rareddy)Ramesh,
Thank you very much.
I will follow that.
Cheers,
Stéphane