The DBMS (Database Management System) is really excellent. We also use facilities to manage the data that is accessed by our users. We need to upgrade our services from Oracle to manage our data on the cloud and our own servers for synchronization. We also need a better data dictionary and business… more »
What needs improvement?
We will need to implement prototypes in our data warehouse. We will have to implement and to support some different types of files like video, audio, pictures, and non-structured data. So we are working on that. We would like better integration for data security. We will have many partners, eight or… more »
What other advice do I have?
We are in relation to the city of Montreal in Quebec. We are the leader of this major platform with several databases. Some of them come under the ownership of the city of Montreal. The technological integration will be defined by paying next February. We are working on the governance scheme of… more »
Which other solutions did I evaluate?
At the time that we were looking for a solution, we also evaluated an IBM solution and the SAP solution. The advantages of Oracle above the others is that Oracle was ahead feature-wise. We needed relational DBMS and Oracle was also chosen for other major projects in the provincial government. So we… more »