How to manage MySQL database in Azure?

Best heterogeneous database connection practice?

• I am a student, major in database management. On my 5th  semester, we are required to create a system using heterogeneous  database. We must use at least 4 different database. My choice would be  MySQL, MS SQL Server, Oracle and PostgreSQL since these are among the  most popular and matured database.         The problem is that so far, no group has ever manage to connect to 4  different database. I have heard that using Java hibernate spring could  connect to different database, but I am trying to connect to different  database on the database level, not on the application level. Using  something like Oracle's database link. But as far as I know, MySQL does  not have this feature. If in the industry, what are the common ways to deal with  heterogeneous database? Or is there any standard library for me to do  this? I hope to get some guide on how should I deal with heterogeneous  database using the industry standard

• Answer:

  The heterogeneous database connection is only theoretically feasible, but unfeasible in practice because of the extremely poor performance and stability. Sometimes the connection even cannot be established.   In the level of application program, Java doesn’t provide the standard class library for structured data computing. Neither can Hibernate perform any heterogeneous operations except mapping the database table to a Java object. I recommend esProc, which is a programming language designed and positioned as an intermediate layer between the database and the application program. esProc is programmed in Java too. This means it provides for Java the class library for structured data computing. It can connect to all the databases you mentioned in the question, and work with datasources like db2, nosql, hdfs, txt and excel and so on. Besides, It can perform common operations like group, filter and join, and can process big data as well. Please refer to @http://blog.raqsoft.com/?p=840