This issue depends on a few variables that you do not mention in your request:
- how do you want to control exactly which resource to select from in the external database (by another attribute in the content object?)
- do you want to be able to "edit" the external attributes from eZ publish? - do you need translation or version control?
If you don't need translation or version control I would suggest to write new datatypes for each of the different type of fields from the external resource (e.g external int, external varchar etc.) use a native eZ publish attribute to control the id of the external content row.
I think some of our partners have developed something like this in the past.
In a first step, I only expect to request my database in a static way. I know the table and field names in advance, so I can hardcode them. I only need to allow a contributor to specify a value for the $X variable in the WHERE of the SELECT clause.
Actually, for the moment I only want to know how to send a request to an external database and get the result in a content object. Maybe in a second step, I will want to do it more dynamically and be able to specify more elements of the SELECT clause. What do you mean by "edit the external attribute" ? To change its value and update the external DB ? Not for the moment, my hope is just to request the external DB, get the result, and integrate this result in a EZP content object. No translation or version control either.
Thanks for your help .
HB
You must be logged in to post messages in this topic!
