Configuring Data Ship for Sybase IQ

When Sybase IQ is the target of the data ship, you must perform these steps. Depending on the platform you are installing to, your steps might vary. These steps do not detail every step as might be required by Sybase, refer to your Sybase documentation for further details.

To configure data ship for Sybase

1. Verify or install a SQL Anywhere Database Client. You can obtain a trial version through the Sybase download site.

If you don't have SQL Anywhere Database Client and don't want to install one on your Unix system, then you can copy the client into <TDV_install_dir>/sqlanywhere<ver>, because the SQL Anywhere database client has the drivers that are needed for TDV.

2. Locate the following files in the directory where the Sybase client is installed.
— jodbc.jar
— libdbjodbc<ver>.so for Unix
— dbjodbc<ver>.dll for Windows
3. Copy the files to the locations described in the following table:

OS

Copy jodbc.jar Into

Copy dbjodbc<ver>.dll Into

Windows 64

<TDV_install_dir>\apps\common\lib

<TDV_install_dir>\apps\common\lib\win64

Windows 32

<TDV_install_dir>\apps\common\lib

<TDV_install_dir>\apps\common\lib

UNIX (32 and 64)

<TDV_install_dir>\apps\common\lib

<TDV_install_dir>\apps\common\lib

4. Stop the TDV Server.
5. For UNIX, set the global LD_LIBRARY_PATH environment variable to point at the SQL Anywhere client libraries folder. TDV uses LD_LIBRARY_PATH to find the Sybase Client library. For example, to temporarily set the variable, type: 
export LD_LIBRARY_PATH=/opt/<TDV_install_dir>/sqlanywhere<ver>/lib<ver>/
6. Create an ODBC data source following the guidelines in your Sybase documentation. The following instructions highlight some of the necessary steps depending on your platform

Platform

Instructions

UNIX

  1. Create an odbc.ini file. We recommend that you create it under <TDV_install_dir>.

  2. Create a Sybase IQ data source name (DSN) in the odbc.ini file. For work with TDV, the Driver variable is the most important setting, because it points to the SQL Anywhere client that you have installed. For example, data sources named, test1 and test2, would look similar to the following:

#####################################
SybDB@machine64:cat odbc.ini
[test1]
Driver=/opt/<TDV_install_dir>/sqlanywhere<ver>/lib<ver>/libdbodbc<ver>_r.so
host=10.5.3.73
port=2638
uid=dba
PWD=password
DatabaseName=asiqdemo
PreventNotCapable=YES
[test2]
Driver=/opt/<TDV_install_dir>/sqlanywhere<ver>/lib<ver>/libdbodbc<ver>_r.so
host=10.5.3.74
port=2638
uid=dba
PWD=password
DatabaseName=asiqdemo
PreventNotCapable=YES
######################################

Windows

  1. Start the ODBC Administrator, select Sybase > Data Access > ODBC Data Source Administrator.

  2. Click Add on the User DSN tab.

  3. Select the Sybase IQ driver and click Finish.

  4. The Configuration dialog box appears.

  5. Type the Data Source Name in the appropriate text box. Type a Description of the data source in the Description text box if necessary. Do not click OK yet.

  6. Click the Login tab. Type the username and password. If the data source is on a remote machine, type a server name and database filename (with the .DB suffix).

  1. If the data source is on your local machine, type a start line and database name (without the DB suffix).

  2. If the data source is on a remote system, click the Network tab. Click the check box for a protocol and type the options in the text box.

  3. Click OK when you have finished defining your data source.
7. On Unix, use the following commands to verify that the DSN is set up successfully: 
cd sqlanywhere<ver>/bin<ver> 
./dbping -m -c "DSN=test1"

A “Ping server successful” message means that the DSN is working. At this point any application can use the DSN to contact the Sybase IQ through the ODBC Driver.

8. On Unix, set the global ODBCINI environment variable to point at the SQL Anywhere odbc.ini file. For example, to temporarily set the variable, type: 
export ODBCINI=/opt/<TDV_install_dir>/odbc.ini
9. Set the QUERY_PLAN_AS_HTML Sybase option to off. For example, run the following SQL command: 
SET OPTION <USER_NAME>.QUERY_PLAN_AS_HTML = OFF;

This setting prevents Sybase from creating extra HTML plan files that can take up too much disk space.

10. Set the QUERY_NAME option to specify a name for each of the queries generated to help with future database cleanup.
11. Start TDV server.
12. Continue with the instructions in Finishing Data Ship Configuration for Data Sources.