Workflow to Create and Add a Microsoft SQL Server Adapter Connection to an Integration

You follow a very simple workflow to create a connection with an adapter and include the connection in an integration in Oracle Integration.

Step	Description	More Information
1	Create the adapter connections for the applications you want to integrate. The connections can be reused in multiple integrations and are typically created by the administrator.	Create a Microsoft SQL Server Adapter Connection
2	Create the integration. When you do this, you add source and target connections to the integration.	Create Integrations and Add the Microsoft SQL Server Adapter Connection to an Integration
3	Map data between the source connection data structure and the target connection data structure.	Map Data in Using Integrations in Oracle Integration Generation 2
4	Specify the primary business identifier to track a field across an integration flow during runtime.	Assign Business Identifiers in Using Integrations in Oracle Integration Generation 2
5	(Optional) Create lookups that map the different values used by those applications to identify the same type of object (such as gender codes or country codes).	Manage Lookups in Using Integrations in Oracle Integration Generation 2
6	Activate the integration.	Manage Integrations in Using Integrations in Oracle Integration Generation 2
7	Monitor the integration on the dashboard.	Monitor Integrations in Using Integrations in Oracle Integration Generation 2
8	Track payload fields in messages during runtime.	Assign Business Identifiers for Tracking Fields in Messages and Manage Business Identifiers for Tracking Fields in Messages in Using Integrations in Oracle Integration Generation 2
9	Manage errors at the integration level, connection level, or specific integration instance level.	Manage Errors in Using Integrations in Oracle Integration Generation 2