Create a query using 2 different database providers
Is it possible now, or planes for a future release to support multiple connections on a query builder instance?
I would like to join data from 2 different database running on 2 different servers (one on SQL Server and another one on PostgreSql for example)
Thanks!
It is possible to mix metadata from different databases in a single Metadata Container, but you have to decide which server will be executing the result SQL query and set the syntax provider according to this choice because Active Query Builder does not execute queries, it only helps to build them. I know that MS SQL Server can link ODBC datasources to run queries against the linked and native data. Also, there are some virtualization platforms like TEIID.
How to show metadata from several databases or database servers?