Salesforce Integrations

USE Case #1 - Salesforce to Kentico  - All contacts in Salesforce synched down to Kentico. 

[CII_User_Profiles_for_Kentico]  used to be populated by iMIS


[LAST_FIRST]
,[LAST_NAME]
,[FIRST_NAME]
,[MIDDLE_NAME]
,[DESIGNATION]
,[PREFIX]
,[INFORMAL]
,[FULL_NAME]
,[EMAIL]
,[WORK_PHONE]
,[MemberTitle]
,[ID]
,[COMPANY]
,[CO_ID]
,[MainCompany]
,[MAIN_CO_ID]
,[EffectiveDate]
,[ExpirationDate]  - no longer needed. Kentico will manage the logins. 
,[IsDisabled]
,[UserId]
,[MEMBER_TYPE]
,[CATEGORY]
,[MemberClass]
FROM [CII_iMIS].[dbo].[CII_User_Profiles_for_Kentico]