 |
 |
 |
 |
Key Benefits
- Can save costs of interfaces
- Data from foreign dbms is always up to date
- Joins tables from different database instances of different vendors for statistic analysis
- Optimized data stock usage
Joining tables within one database instance is a routine feature used in any database application within relational database systems. Tables within the same database instance are joined, even links to tables from other database instances can be joined, if the database system offers this feature (e.g. Oracle, Db2, MSSQL). However joining tables starts to become complicated whenever you want to combine tables from databases of different vendors.
With the help of Alligator DataBase Connectivity (ADBC) you can for example join tables in an Oracle database with the tables of a different database vendor (MySQL or MSSQL) – of course without transferring the data of the MySQL or MSSQL table permanently to Oracle.
The link to the MySQL table can be created as followes: CREATE TABLE oratab AS SELECT * FROM mysql.tab
Developing cost-intensive interfaces is obsolete and the data is accessible from MySQL and Oracle at the same time. You can even use the MySQL table in JOINs with Oracle tables.
