Tables on a remote IQ Server can be made available to another IQ Server using Proxy Tables.

1. Configure the remote IQ Server for proxy access on the local IQ Server.

(DBA)> create server REMOTE_IQ class 'asajdbc' using 'remote_iq.my_domain.com:4000/REMOTE_IQ'

This SQL statement puts an entry into the SYSSERVERS table.

2.  Configure EXTERNLOGIN for users and/or "table owners".

For example, on the remote IQ Server there is a table called MY_TABLE owned by my_user. A user must be created on the local IQ Server with sp_iqaddlogin and mapped to my_user on the remote IQ Server, using a CREATE EXTERNLOGIN statement and giving the user's password for the remote IQ Server. The user names can be different, but it seems simpler to use the same user names.

(DBA)> CREATE EXTERNLOGIN my_user TO REMOTE_IQ REMOTE LOGIN my_user IDENTIFIED BY my_remote_password

3.  The Proxy Table must be made available using a CREATE EXISTING TABLE statement.

DBA> create existing table my_user.MY_TABLE at 'REMOTE_IQ..my_user.MY_TABLE'

The table names can be different, but normally customers want the same table name.

4. Use the usual GRANT statements to allow local users access to the table contents.