Verify that ETL Development has been successfully installed.
Starting Sybase ETL Development
In Windows, select Start | Programs | Sybase | Sybase ETL Development 4.9 | Sybase ETL Development.
The Welcome window displays. To prevent this window from displaying every time the application starts, unselect Show on Startup, and click Close.
The repository login window appears, showing these default values:
Connection – Repository
Client – transformer
Client user name – TRANSFORMER
Password – transformer
These values are automatically set the first time you log in. On subsequent logins, you might need to select or enter this information.
Click Logon. If you can successfully log in to ETL Development, the installation is successful.
The installer creates an initial set of data sources.
If these repository data sources are lost for any reason, ETL Development
cannot open until you restore them following the procedures below.
Restoring the initial
set of ODBC data sources of the demo repository
Configure the ODBC user data source.
Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).
To administer data sources on a 64-bit machine, run odbcad32.exe, from C:\WINDOWS\SysWOW64.
Click Add.
Select SQL Anywhere 11 from the list. Click Finish.
Enter DEMO_Repository as the ODBC data source name.
Click the Login tab and enter “dba” as the user ID and “sql” as the password.
Click the Database tab and in the Start line field, enter “C:\Program Files\Sybase\ETLDevelop49\dbeng11.exe.” This is the default installation location.
ETL Development runs dbeng11.exe for
configuring the ETL repository. dbeng11.exe is a single user database
and cannot be accessed from other machines. To access the repository
from another machine, specify dbsrv11.exe instead
of dbeng11.exe in the Start line field.
Edit the Database file field.
If the application is installed for a single user in the default location, enter “C:\Program Files\Sybase\ ETLDevelop49\Demodata\demo_rep.db”
If the application is installed for all users:
For Windows XP or 2003 – enter “C:\Documents and Settings\<login user>\Application Data\SYBASE\Sybase ETL Development\<product version>\Demodata\demo_rep.db”
For Windows 2008 or Vista – enter “C:\Users\<login user>\AppData\Roaming\SYBASE\Sybase ETL Development\<product version>\Demodata\demo_rep.db”
Go back to the ODBC tab and click Test Connection to verify the connection.
Set up the repository connection in the Repository Logon window:
Select File | Open Repository.
Select Repository from the Connection list and choose:
Edit or,
Add, and enter a name for the connection.
Select ODBC from the Interface list.
Select DEMO_Repository from the Host list.
Click Save.
Configure the additional ODBC user data sources required by the projects in the demo repository:
Driver – SQL Anywhere 11
Name – ETLDEMO_DWH; database – demo_dwh.db
Name – ETLDEMO_GER; database – demo_ger.db
Name – ETLDEMO_US; database – demo_us.db
The database files for these user data sources are also located in the Demodata folder of the installation directory, when installed for a single user, or in the user data directory, when installed for all users.
