Database wrapper - Heterogeneous service

126 views Asked by At

Problem

I have 3 databases type Oracle, Mysql, Microsoft SQL. data are the same in all databases. Is there any way to have 1 database, whatever it is, and store data on it, and have a database wrapper in front of It, that handle JDBC, ODBC connections "Oracle, Mysql, MicrosftSQL". so the wrapper layer "Heterogeneous Services" / "Database Gateway ..etc", receive oracle, Mysql ..etc queries and translate them to the database being chosen and response with the result.

Result

So instead of managing 3 types of database and backup, update ..etc. I end up managing one database type, for example, "Hive". but still accepting both JDBC, ODBC connections from different applications.

enter image description here

0

There are 0 answers