Sybase ETL Development is the GUI tool used for ETL development and deployment. This tool is available only on Windows and is packaged separately from DI Suite.
Use the installer provided with Sybase ETL Development to install this tool. After installation, configure this tool to work with the ETL Server installed using the DI Suite installer.
Before installing Sybase ETL Development:
Obtain the Sybase ETL Development license from the SPDC. For information on how to obtain licenses from the SPDC, see the Sybase Software Asset Management User’s Guide.
Verify the installation directory name does not have non-ASCII characters or spaces.
Installing Sybase ETL Development
Launch the ETL Development installer using the ETL Development installation media.
The setup program should start automatically. If it does not, select Start | Run and browse to setup.exe.
Alternatively, if you are installing from the SPDC, go to the directory where you have extracted all the files and double-click the setup program to run the installer. For information on how to install from the SPDC, see “Installing from the SPDC”.
The Welcome window displays. Click Next to proceed.
Specify the language to use for installation. Click OK. The Welcome window displays. Click Next to proceed.
Read the License Agreement. Select “I accept the agreement” and click Next.
The installer prompts you to close all other applications, specifically Grid Nodes, before proceeding. Click Next.
To terminate the GridNode.exe process, open the Windows
Task Manager and click the Processes tab. Select GrideNode.exe from
the list of processes and click End Process.
Provide the installation directory. Click Browse to select a directory, click Next to accept the default directory, or enter a new directory to be created. Sybase recommends that you use only alphanumeric characters for the installation path.
Specify the Start Menu folder in which you want to create a program shortcut. To install in the default folder, click Next. Otherwise, click Browse to specify a new folder.
If you are installing using an Administrator account, select the Install for All Users option. This allows you to launch the application on user accounts with restricted access rights.
When started the first time on a user account, all files requiring write privileges are copied to the user directory, typically C:\Documents and Settings\<username>\Application Data\SYBASE\Sybase ETL Development\42.
Depending on whether you have selected or deselected the Install for all users option, log files are located in the \log subdirectory of either the user or the installation directory.
Select the check boxes for any additional setup tasks you want to perform. Click Next.
The installation summary window displays. Review the information, and click Install.
Once installation is complete, the installer displays a Readme file. View the contents of the file and click Next.
Unselect the Launch ETL Development option. You must apply the ETL Development license before you launch the tool. For information on applying the ETL Development license, see “Activating the ETL Development license”.
Click Finish.
Activating the ETL Development
license
Copy the licenses you have obtained from the SPDC into the %SYBASE%\ETLDevelop42\licenses directory, where %SYBASE% is the installation directory for ETL Development. Double-click the Sybase ETL Development icon or select it from the Sybase product group on the Windows Start menu. The ETL Development window appears.
If you have not obtained the license yet from the SPDC, you can launch and use ETL Development using the 30-day trial license. To activate the 30-day trial license:
Launch the ETL Development tool. A SySAM license window appears.
Click Continue to start the 30-day trial period. The ETL Development window appears.
If you obtain the ETL Development license within the 30-day trial period:
Apply the ETL Development license by copying it into the %SYBASE%\ETLDevelop42\licenses directory, where %SYBASE% is the installation directory for ETL Development.
Close ETL Development and launch it again.
If you do not obtain the ETL Development license from
the SPDC and before the trial license expires, the Sybase ETL Development
SySAM license window prompts you for a valid SySAM license at every
launch of the tool within the trial period. When the trial period
ends, ETL Development stops working.
Configuring Sybase ETL Development to use with
the Sybase ETL Server
To enable ETL Development to execute data transformation jobs:
Select the ETL Server installed using the DI Suite installer as the default GRID engine for project execution. See Chapter 2, Section “Customizing preferences” in the Sybase ETL 4.2 User’s Guide.
Set the GRID environment as described in “Sybase ETL”.
