1 .Build a dataware house
The DBMS is a relational database that is hosted in Azure. Azure SQL is based on Microsoft SQL
server with some limitations. These restrictions do not affect this task when Azure SQL
meets all requirements necessary to perform the task.
2 .Transferring data from [url removed, login to view] ([url removed, login to view])
By using Figs its open APIs, the candidate should bring out all the information provided by the system
and who is available. The solution must connect to Fikens endpoints and authenticate themselves according to
described procedure documentation. The data will then be retrieved and transferred to the data warehouse. This important to note that this transfer task will have to be run frequently, so that the data in data warehouse at any time reflects the actual numbers in Figs. In practice this means that the system must
could handle scenarios
Fetch new data that does not exist in the data warehouse
Updating the data that already exists in the data warehouse, if them have been altered in Figs
Removing data that exists in the data warehouse if those have been deleted in Figs.
The data in the data warehouse should be presented on a separate website. It aims to provide the end user opportunity to immerse themselves in the data found in the data [url removed, login to view] shows that a customer like to be
interested in a high-level and more detailed picture on the lower level in the data.
The website must take advantage of modern web technologies. Websites should be designed for HTML5 and
also an option to use. When using client-side framework encouraged to use Angular
1.5 / 2.0