Sybase ETL Development includes an empty SQL Anywhere 11 repository, separate from the migration repositories. To access and define the ODBC data source for the empty SQL Anywhere 11 repository:
Navigate to <ETL_Development_install_directory>\etc and rename the repositoryEmpty.db to a name of your choice. For example, myRepository_ETL49.db.
Configure the ODBC data source names to define your own repository by creating a System data source that points to myRepository_ETL49.db
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 and click Finish.
Click the ODBC tab. In the Data source name field, enter myRepository_ETL49.
Click the Login tab and enter dba as the User ID and sql as the Password.
Click the Database tab and enter these values:
Start line – C:\Program Files\Sybase\ETLDevelop49\dbeng11.exe. This is the default install 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.
Database file – C:\Program Files\Sybase\ETLDevelop49\etc\repository\myRepository_ ETL49.db
Click the ODBC tab and click Test Connection to verify the connection.
Connecting to the repository in ETL Development
Navigate to Start | Programs | Sybase | Sybase ETL Development 4.9 to launch Sybase ETL Development.
Set up the repository connection in the Repository Logon window:
Click Add and enter myRepository_ETL49 as the name.
Select ODBC from the Interface list.
Select myRepository_ETL49 from the Host list.
Enter dba as the user and sql as the password.
Click Test Logon to test the connection.
Click Save.
Select Register new user and click Logon.
Enter transformer to confirm your password and click OK.
