Troubleshooting

The Sybase ETL installer creates an initial set of data sources. If these repository data sources are lost for any reason, Sybase ETL cannot open until you restore them. To restore the initial set of ODBC data sources of the demo repository:

1. Configure the ODBC user data source:

   1. Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).

   2. Click Add.

   3. Select SQL Anywhere 11. Click Finish.

   4. Enter “DEMO_Repository” as the ODBC data source name.

   5. Click the Login tab and enter “dba” as the user ID and “sql” as the password.

   6. Click the Database tab and in the Start line field, enter “C:\Program Files\Sybase\ETLDevelop49\dbeng11.exe.” This is the default installation location.

   7. In the Database file field, enter “C:\Program Files\Sybase\ETLDevelop49\Demodata\demo_rep.db.”

   8. Return to the ODBC tab and click Test Connection to verify the connection.

2. Set up the repository connection in the Repository Logon window:

   1. Select File | Open Repository.

   2. Select Repository from the Connection list and choose:

      • Edit, or,

      • Add, and enter a name for the connection.

   3. Select ODBC from the Interface list.

   4. Select DEMO_Repository from the Host list.

   5. Click Save.

3. 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.