This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
multiple-databases [2016/01/22 15:35] dmtolpeko [Default Connection] |
multiple-databases [2016/01/22 15:37] (current) dmtolpeko [Map Database Objects to Use Other Connections] |
||
---|---|---|---|
Line 30: | Line 30: | ||
===== Map Database Objects to Use Other Connections ===== | ===== Map Database Objects to Use Other Connections ===== | ||
- | Once you configured multiple connection profiles you can use [[map-object|MAP OBJECT]] statement to map a table or view to the specified connection. Then when accessing in SQL statements PL/HQL will use appropriate connection for the object: | + | Once you configured multiple connection profiles you can use [[map-object|MAP OBJECT]] statement to map a table or view to the specified connection. Then when accessing in SQL statements HPL/SQL will use appropriate connection for the object: |
For example, you can run SELECT in Hive, but log messages to MySQL: | For example, you can run SELECT in Hive, but log messages to MySQL: |