Work at a service company. In the company we have hundreds of Oracle and SQL-Server databases of all clients. These banks contain information on the equity items in that company as well as other business and financial information. As the work is performed the employees through the internal system feeds the various tables, such as: project steps, execution history, issuing invoices, tickets, schedules, etc. Our goal is to create an area on the internet where the customer can log in and consult the information available to him.
I imagine a table with username and password where the system validates and verifies to which bases of which servers it has access. If he has access to a single base the system already connects that base and he starts to consult his information regarding the execution of his work. If there is more than one base the system asks which base it wants to access and it follows equally.
As I recently used ASP.NET MVC 4 to build an application with RAZOR and found it quite productive I ask you, can I develop this new project using ASP.NET MVC 4? It would be cool because the client could access information, including the cell phone.
I can not imagine what the model would look like. Well, in theory, I would just have one table as the entryway and then the system connects to some other base and I'll do select there. Can I create the model based on a database and switch the connection back and forth at will?
Or should I replicate the columns that will be queried in other tables in the same database as the login table and trigger them in the original banks?
Do you know of a link that would give me a good idea how to do this?
If you're confused, I'm available for more information.
Thank you.