Try Now
More in this section

Forums / Developing with Sitefinity / Getting Data into Sitefinity (The Best Way)

Getting Data into Sitefinity (The Best Way)

2 posts, 0 answered
  1. David
    David avatar
    114 posts
    19 Jul 2012
    21 May 2015
    Link to this post

    Currently this is how we get data on to our website:

    We use SSIS to get data from a web service provided by our Software Provider.  We httprequest and login, get a token, and then download XML files.  We then process the XML files to download the property images from their URLS.

    Once in the database we then transform the data into the correct format for the website we SSIS to copy the data to an access database and then this is FTP to our web server each night.

     How should I do this in Sitefinity?

    1. Can I add some kind of script task in SSIS to connect to Sitefinity and then update a custom module?  I would need to refresh the custom module each day at least by deleting all data and then recreating it from the database.

    2. Should I bypass SSIS and somehow create a custom feed that can login directly to our Software Providers webservice to consume the XML and process the data in the feed and add this data to a custom module? 

    I've no idea where to begin with either approach, or whether there is a better way to do this.  Any help much appreciated.

  2. Victor
    Victor avatar
    94 posts
    15 Jun 2011
    21 May 2015 in reply to David
    Link to this post

    Best way?  I don't know about the "best", but this is what we do.

    Create a custom webservice (.asmx) and put all the import code there.  The custom modules all have documentation in the backend to create/edit & update each data type.

    Then we simply add the webservice task right to the SSIS package.  

     Hope this gets you going in the right direction.

2 posts, 0 answered