1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Connect to MSSQL and XML to generate a Content Feed

Connect to MSSQL and XML to generate a Content Feed

2 posts, 0 answered
  1. John
    John avatar
    26 posts
    Registered:
    10 Sep 2012
    20 Nov 2012
    Link to this post
    Hello,

    I am brand new to Sitefinity, and I'm somewhat confused about where to
    start in regards to making a dynamic connection to an external MS SQL
    database for a content feed and a straightforward XML document within Sitefinity web pages.

    Are there widgets to complete this? If so, does an add-on have to be
    downloaded? I don't understand what tools I am suppose to use to get
    this to occur. Any assistance would be greatly appreciated.

    Thank you so much for your time and help.

    Maria
  2. Slavo
    Slavo avatar
    295 posts
    Registered:
    24 Sep 2012
    23 Nov 2012
    Link to this post
    Hi John,

    As far as I understand, you want to show content from an external DB on a Sitefinity website. There are several ways you can approach this.

    1. You can import the content into a sitefinity module using the API. Dynamic Modules in Sitefinity let you specify your own data model. Once the content is imported, you can show it anywhere on a Sitefinity page. Documentation about dynamic modules is available here:
    http://www.sitefinity.com/documentation/documentationarticles/user-guide/website-content/creating-and-using-custom-modules

    2. You can implement a custom widget which dynamically accesses the remote data and shows it immediately. The widget can then be placed on any Sitefinity page. Widgets are just normal ASP.NET cotnrols. An example of how to build one is available here:
    http://www.sitefinity.com/documentation/documentationarticles/developers-guide/how-to/how-to-create-a-newsrotator-control 

    I am not sure if the XML document you mentioned is related to showing the content from the remote DB or a separate request. If it is the latter, Sitefinity has no user interface for creating documents, but you can store it in the documents module after you've created it in any editor.

    Let me know if I can assist you further.

    Kind regards,
    Slavo
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered