Querying Remote Data Using DirectConnect and Proxy Table from UNIX

Query data using DirectConnect.

This example shows how to access MS SQL Server data. For this example, assume the following:

An SAP Sybase IQ server on host myhostname, port 7594.
An Adaptive Server server on host myhostname, port 4101.
An Enterprise Connect Data Access (ECDA) server exists named mssql on host myhostname, port 12530.
The data is to be retrieved from an MS SQL server named 2000 on host myhostname, port 1433.

Setting Up Adaptive Server to Query MS SQL Server
Set up Adaptive Server and Component Integration Services (CIS) to query MS SQL Server through DirectConnect.
Setting up SAP Sybase IQ to Connect to the Adaptive Server Server
Follow these steps to query Adaptive Server data.

Parent topic: Querying Data Without Native Classes

Created December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com