Create a query using 2 different database providers

Pinned Answered

Comments

1 comment

  • Official comment
    Avatar
    Sergey Smagin (Product manager)

    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?

    Comment actions Permalink

Please sign in to leave a comment.