To load the SQL Server schema
On the Schema menu, click Load.
The Load Schema to Repository dialog box appears.
Select Data Manager Type as SQL Server from the drop-down list.
Enter the host name or the host IP address in the Host Name field.
If there are multiple network adapters / addresses, enter the host IP address instead of the host name to avoid name resolution issues. When a host name is used, Data Exchange acquires the first available IP address from Domain Name System (DNS) when the Administrative Service starts.
Choose one of the following authentication methods:
Windows Authentication: If the Windows logon credentials are added as a user account 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 SQL Server.
Note: Select "Remember Me" to save your credentials for automatic login the next time you load the schema.
Select the schema from the Schema Name drop-down list.
(Optional) Click Verify Connection to ensure that a connection can be established with the database.
If the connection is successful, a success notification appears. If the connection fails, an error message appears.
Click OK.
After the schema is loaded successfully, a status message is shown in the DDW status bar. The time taken to load a schema depends on its size.
You can click Cancel to cancel the process.
Note: Data Exchange supports SQL Server memory optimized tables as a transformation target. For more information on support for SQL Server memory optimized tables in Data Exchange, refer to the Runtime Administration and Operations Help.