We am looking at going down the route of using a CMS to drive the website for the company that I work with and Umbraco seems to tick a lot of boxes, but I wondered if the following is possible with Umbraco.
Our HR department run all our employee data (name, department, email, telephone, etc) from an internal SQL Server. Currently this database is syncronised with another SQL server (nightly) and this second server is used to drive employee information on our intranet. We would like a second syncronisation (which can be set up by our HR) to populate the Umbraco database. From there we would develop some code to pull the employee data out and on to the page.
Firstly, is this possible (I assume it is but wanted to check) and secondly can this 3rd party data be loaded into the same Umbraco database (thus using a single connection) or would it have to be loaded into a seperate one?
3rd party data question
We am looking at going down the route of using a CMS to drive the website for the company that I work with and Umbraco seems to tick a lot of boxes, but I wondered if the following is possible with Umbraco.
Our HR department run all our employee data (name, department, email, telephone, etc) from an internal SQL Server. Currently this database is syncronised with another SQL server (nightly) and this second server is used to drive employee information on our intranet. We would like a second syncronisation (which can be set up by our HR) to populate the Umbraco database. From there we would develop some code to pull the employee data out and on to the page.
Firstly, is this possible (I assume it is but wanted to check) and secondly can this 3rd party data be loaded into the same Umbraco database (thus using a single connection) or would it have to be loaded into a seperate one?
Many thanks in advance
is working on a reply...