In ETL 4.9, Sybase SQL Anywhere is the only supported repository. SQL Anywhere 11, which is the recommended version for use as an ETL repository, is installed and configured as a repository with the installation of ETL Development. It is also packaged with ETL Server and can be installed manually.
If you are using a non SQL Anywhere repository from an earlier version of ETL, you must migrate your existing ETL repository to SQL Anywhere 11. See “Migrating an existing repository to SQL Anywhere”.
Each SQL Anywhere database can support only one ETL
repository. You may encounter errors if multiple schemas within
a SQL Anywhere database contain multiple sets of repository tables.
Install ETL Server.
Run the SQL Anywhere 11 installer:
Windows –
Navigate to the installation directory.
Unzip and extract the SQLAnywhere11.zip file.
By default, the files are extracted to the installation directory.
Navigate to the SQLAnywhere folder and double-click setup.exe.
UNIX and Linux –
Navigate to the installation directory.
Unzip and extract the SQLAnywhere11.tar.gz file.
For example:
gunzip SQLAnywhere11.tar.gz tar -xvf SQLAnywhere11.tar
By default, the files are extracted in the installation directory.
Using a command prompt, navigate to the folder where you have extracted the file, and enter:
./setup
When installing SQL Anywhere on Solaris, make sure to include /bin before /usr/ucb/bin in
the PATH variable.
Select the language for installation and click OK.
Select Install SQL Anywhere 11.
On the Welcome window, click Next.
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.
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.
Accept the default Server license information and click Next.
Select the Setup type and click Next.
Click Install.
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.
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 for UNIX and Linux”.
See the SQL Anywhere documentation installed by the SQL Anywhere installer, for information on how to set up a repository database.
