Chapter 3 Defining rules and queries 65
Using the adapter rule helper utilities
X To populate SQL field information for multiple external data tables
1 From the Integration Engine console, click Configuration > Database Field Menus.
The Database Field Menus Console window appears.
The DB2 tab appears by default.
2 Click the SQL Server tab.
The SQL Adapter Rule Helper Utility window appears.
Figure 3-3: SQL Adapter Rule Helper Utility window
3
In the Server Name field, type the name of your SQL Server.
4 In the Database Name field, type the name of your SQL Server database.
5 Complete one of the following actions:
Type your user name in the Login Name field and the password in the Password
field.
If you use Windows authentication for your database, click the Enable Windows
Authentication check box. If you select this option, you do not need to type a
login name or password.
6 Click Save.
7 In the Limit tables and views for owner field, complete one of the following
actions:
Leave this field blank to have Integration Engine retrieve all tables and views.
Type a user (owner) name in this field to retrieve only the tables and views
owned by that user.
