If you connect to an existing repository, either you can use existing schemas and transformations, or load new schemas and define new transformations.
On the Repository menu, click Connect.
The Connect to Repository dialog box appears.
From the Host Name drop-down list, select the required host or enter the host IP address.
If there are multiple network adapters / addresses, enter the host IP address instead of the host name to avoid name resolution issues.
To improve the security when Data Exchange connects to a DDW repository, you can enable secure connection. To do so, select the Secure Connection check box.
To use the Secure Connection option, you must ensure that SQL server is configured correctly for SSL encryption. You must install the Security Certificate on the machine(s) where DDW and SQL server is installed. If the requirements for secure connection are not satisfied, then when you try to choose a repository, it will result in an error. In such a case, deselect the Secure Connection option and then choose the required repository.
Choose one of the following authentication methods:
Windows Authentication: If the Windows logon credentials are added as a user in the SQL Server Management Studio, select Windows Authentication.
SQL Server Authentication: If the logon credentials to the selected host are different from the Windows credentials, select SQL Server Authentication. Enter the login credentials in the Login User and Password fields for the selected host.
Select the required repository from the Repository Name drop-down list.
Click OK.
Note: When you try to connect to a lower version of the DDW Repository from a higher version of DDW, Data Exchange prompts you to migrate the repository to an upward compatible version. For more information about migrating the repository, refer to Migrating the Data Exchange Development Workbench Repository
The required DDW Repository is available for use.
You can click Cancel to cancel the process.
Notes:
If you delete a DDW Repository, the next time you log in, the system displays a message informing you that the DDW Repository used last time does not exist anymore. The message also prompts you to either create a new DDW Repository or connect to an existing DDW Repository.
DDW will not allow you to make a connection to the repository in the following cases:
Connecting to a repository that is already in use from another DDW instance on the same machine or another machine.
Connecting to a repository that was in use in a DDW instance that terminated abnormally. However, you can connect to this repository after a minute from the time DDW terminated.
The Data Exchange Development Workbench dialog box appears stating that the repository is already connected to a DDW instance and prompts you to connect to another repository.
To successfully connect to a large repository consisting of a large number of schemas, increase the default time-out value of the parameter StoredProcedureTimeOut in the configuration file (Data Exchange Development Workbench.exe.config), to your required time length.