3 Add the Microsoft SQL Server Adapter Connection to an Integration

When you drag the Microsoft SQL Server Adapter into the trigger or invoke area of an integration, the Adapter Endpoint Configuration Wizard appears. This wizard guides you through the configuration of the Microsoft SQL Server Adapter endpoint properties.

These topics describe the wizard pages that guide you through configuration of the Microsoft SQL Server Adapter as a trigger and invoke in an integration.

Note:

Note the following details when using the merge operation with the Microsoft SQL Server Adapter.

• The Microsoft SQL Server Adapter relies on the primary key for all operations and does not support overwriting the primary key that is defined at the database level.
• Use stored procedures to handle custom logic for the merge operation on the attributes that do not have a primary key.

Topics:

• Basic Information Page

• Stored Procedure Page

• SQL Statement Page

• Polling Properties

• Summary Page