I want to create a Graph Obect (which will have fields for titles, x-axis heading, y-axis heading... etc) that uses an external database to pull the data.

Can I simply mix in some normal php database calls into my model?

I will probably make an ExternalDatabase class (similar to ExternalAuthenticator)... but just wondered if anyone had tried this before, and what caveats I should be aware of.

Also, does MS Sql Server work as the primary db for SS? I read that there was some work going on with PDO.

Regards,
Ian

subscribe

To answer the second part of my post about MS Sql Server... it seems that SS does support mssql. I found some info at http://doc.silverstripe.com/doku.php?id=database-support.

I'm still curious about any suggestions for pulling data from an external database.

For all those others interested... this post looks like a valuable place to start:

http://www.silverstripe.com/extending-hacking-silverstripe-forum/flat/120

Subscribe ..

Did you find a proper way of achieving what you want ? I'm going to need this in the near future as well (connecting to another external database to fetch data for use in Silverstripe)....