Hi, I have created a remote server in ASA 9, and all seems fine with the connection. But How do I query this remote server?
shows me a list of all the tables, but how do I query an individual table? I have tried various combinations but everythings throws up an error. |
You will usually create a so-called proxy table for each remote table/view you want to access, cf. that doc topic Creating proxy tables (SQL) . Furthermore, you can "directly" access remote tables by using the FORWARD TO statement - but then you are not able to easily connect local and remote data. Please note that both links go to the v12.0.1 doc set but should apply to ASA 9 as well. |