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.
asked 09 Nov '15, 07:42
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.
answered 09 Nov '15, 08:22