Loading remote data without ODBC access

You need to use DirectConnect to access remote data sources:

• On 64-bit UNIX platforms

• On 32-bit platforms where no ODBC driver is available (for example, MS SQL Server)

This section and the following one provide examples of loading and querying data by means of DirectConnect.

For this example, assume the following:

• An Enterprise Connect Data Access (ECDA) server exists named mssql on UNIX host monroe, port 12530.

• The data is to be retrieved from an MS SQL server named 2000 on host hardscrabble, port 1433.

1. Using DirectConnect documentation, configure DirectConnect for your data source.

2. Make sure that ECDA server (mssql) is listed in the IQ interfaces file:

   mssql
   master tcp ether monroe 12530
   query tcp ether monroe 12530
   

3. Add a new user, using the user id and password for server mssql:

   isql -Udba -Psql -Stst_asiqdemo
   grant connect to chill identified by chill
   grant dba to chill
   

4. Log in as the new user to create a local table on IQ:

   isql -Uchill -Pchill -Stst_asiqdemo
   create table billing(status char(1), name varchar(20), telno int)
   

5. Insert data:

   insert into billing location ‘mssql.pubs’ { select * from billing }