Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Accessing an External Database

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 2930 Views
  • ian
    Avatar
    Community Member
    7 Posts

    Accessing an External Database Link to this post

    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

  • christian
    Avatar
    Community Member
    6 Posts

    Re: Accessing an External Database Link to this post

    subscribe

  • ian
    Avatar
    Community Member
    7 Posts

    Re: Accessing an External Database Link to this post

    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.

  • ian
    Avatar
    Community Member
    7 Posts

    Re: Accessing an External Database Link to this post

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

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

  • Fuzz10
    Avatar
    Community Member
    787 Posts

    Re: Accessing an External Database Link to this post

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

    2930 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.