Installing SQL Anywhere as an ETL repository

To use SQL Anywhere as an ETL repository, you must install it using its installer, which is packaged with ETL Server and ETL Development.

NoteSybase recommends that you use a SQL Anywhere repository rather than a Microsoft Access or SQLite Persistent repository if your database includes wide tables and very large columns.

  1. Install ETL Development or ETL Server.

  2. Run the SQL Anywhere 11 installer:

    Windows –

    1. Navigate to the installation directory.

    2. Unzip and extract the SQLAnywhere11.zip file.

      By default, the files are extracted to the installation directory.

    3. Navigate to the SQLAnywhere folder and double-click setup.exe.

    UNIX and Linux –

    1. Navigate to the installation directory.

    2. Unzip and extract the SQLAnywhere11.tar.gz file.

      By default, the files are extracted in the installation directory.

    3. Using a command prompt, navigate to the folder where you have extracted the file, and enter:

      ./setup
      
  3. Select the language for installation and click OK.

  4. Select Install SQL Anywhere 11.

  5. On the Welcome window, click Next.

  6. On the License Agreement window, select the geographic location where you are installing to display the agreement appropriate to your region. Read the license agreement. Select “I accept the terms of this agreement” and click Next.

  7. Enter the license key.

    • On Windows – the license key is available in the SA11_license_key.txt file in the installation directory.

    • On UNIX and Linux – the license key is available in the SA11_license_key.txt file in the installation directory.

    Click Next.

    If you have entered an incorrect license key, click Back, and reenter the key. To install an Evaluation Edition of SQL Anywhere for 60 days, click Next.

  8. Accept the default Server license information and click Next.

  9. Select the Setup type and click Next.

  10. Click Install.

  11. On successful installation, the installer displays:

    Setup has finished installing SQL Anywhere 11 on your computer.
    

    You can select to view the README file or the iAnywhere Online Resources. Click Finish to proceed.

  12. Click Finish to complete the setup.

After installing SQL Anywhere, you must configure the SQL Anywhere ODBC drivers. See “Configuring SQL Anywhere ODBC drivers for Sybase IQ 12.7”.