Figure 1: Shows the list of available tables and views in db endpoint

Using Microsoft SQL Server with App Connect

The following scenarios demonstrate how you can use Microsoft SQL Server in App Connect to perform automation tasks.

Use case scenario - Store the contact details in Salesforce when a new contact record is added to Microsoft SQL Server

• The customer support team at ABC Airlines has been tasked with tracking the new users who had signed up in their portal. Once the information is received in their database, they would want to automate a workflow that would contact the marketing department with the user's contact information to provide promotional offers. In this scenario, the database used is Microsoft SQL Server and the marketing team uses Salesforce to capture the customer details.
• IBM App Connect Microsoft SQL Server connector allows polling for any new or updated events. For the above scenario, we use a configurable polled event called New Contacts record from the Microsoft SQL Server connector.

Figure 2: A list of configurable polled events

• Figure 3 displays the overview of an event-driven flow called Sync Contacts from MsSQL to Salesforce. This flow uses a Microsoft SQL Server New Contacts record (event poller) as the trigger node and Salesforce Create Contact action node. This flow syncs contacts from the Microsoft SQL Server database to Salesforce. So every time a new contact is added to the database, the contact details are replicated in Salesforce

Figure 3: Event-driven flow to store the contact details in Salesforce when a new contact record is added to the Microsoft SQL Server

• Figure 4 displays the Salesforce Create Contact action node and how the data pulled from the database is mapped to various fields in Salesforce Contact
  

Figure 4: Salesforce action node and its data mapping

• Figure 5 displays the insertion of the contact record using an SQL query that will trigger the event-driven flow on App Connect

Figure 5: Inserting a record in Microsoft SQL Server database

• Figure 6 displays the contact details in Salesforce with the data adhering to the new contact record in the database and ready to be used by the marketing team

Figure 6: Synced Salesforce contacts with the new contact details

This scenario demonstrates how you can use IBM App Connect to automatically sync contact information between Microsoft SQL Server and Salesforce to update relevant teams as soon as the information has been retrieved.

For more information about other supported connectors in IBM App Connect, see Connectors.