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.