4D Database and Teiid

[stephuniv]

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

[rareddy]

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..

[stephuniv]

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

[rareddy]

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.

[stephuniv]

Ramesh,

Thank you very much.

I will follow that.

Cheers,

Stéphane