Updates To TIBCO Scribe ® Online Connectors for Microsoft Dynamics 365 / CRM and Microsoft Common Data Service (CDS) Replication Solutions And Azure AD Multi-Factor Authentication

Updates To TIBCO Scribe ® Online Connectors for Microsoft Dynamics 365 / CRM and Microsoft Common Data Service (CDS) Replication Solutions And Azure AD Multi-Factor Authentication

book

Article ID: KB0101728

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

Description

On October 4, 2019, TIBCO Scribe ® plans to release an update to the TIBCO Scribe ® Online Connectors for Microsoft Dynamics 365 / CRM Microsoft and Common Data Service (CDS) This update affects Replication Solutions and Azure AD authentication. Review the following notes carefully.

 

Azure AD Multi-Factor Authentication

 

Support for Azure AD multi-factor authentication has been added to this release. Be aware of the following: 

 
  • Existing  Azure AD Connections will continue to work using the prior authentication method.

  • If you open the Connection dialog and Azure AD is the selected deployment, the new fields are displayed. The prior set of fields is no longer accessible.

  • To use the updated Azure AD multi-factor authentication:

    • Enable multi-factor authentication in your Dynamics 365 / CRM or Microsoft CDS organization

    • Update the information on the TIBCO Scribe Connection dialog and reauthenticate. 


Replication Solutions Net Change Filters

 

Currently, when a group of changes are written to Microsoft Dynamics 365 / CRM or CDS all at the same time, only a portion of them are returned by a subsequent query because the Microsoft Dynamics 365 / CRM date timestamp does not include milliseconds. The next time the Replication Solution runs using Net Change to filter for new and updated records, some records are not included in the Replication. 

 

For example, assume the last record written before the Replication Solution completed had a modifiedon date of 09/04/2018 10:10:20 and the next Replication started with data that had a modifiedon date of 09/04/2018 10:10:21. Any records that arrived between the end of the Replication Solution and 09/04/2018 10:10:21 are not included because milliseconds are not used as part of the filter.

 

The update to the Microsoft Dynamics 365 / CRM Connector addresses this problem by subtracting one second from the most recent modifiedon date to ensure that no records are missed, which could cause a small number of records to be reprocessed.  

 

For example, if the last record written had a modifiedon date of 09/04/2018 10:10:20, the next Replication starts with data that has a modifiedon date of 09/04/2018 10:10:19. Any records that were already processed between 09/04/2018 10:10:19 and 09/04/2018 10:10:20 are processed again. 

 

Changes To Recommended Entities For Replication Solutions

The production version of the Microsoft Dynamics 365 / CRM Connector has a preset list of Recommended Entities that can be used when configuring a Replication Solution. To improve performance and prevent errors, the list of Recommended Entities is being modified. 

 

Note: To continue replicating an entity that has been removed from  the Recommended Entities list, configure a second Replication Solution with Selected Entities and specifically choose the entities you need. Both Solutions can replicate to the same target datastore. 

 

 

Issue/Introduction

The October 4, 2019 update to the TIBCO Scribe ® Online Connectors for Microsoft Dynamics 365 / CRM and Microsoft Common Data Service (CDS) introduces some changes to Replication Solutions and adds support for multi-factor authentication.

Resolution

After the Connector update, you may see error messages for existing Microsoft Dynamics 365 / CRM Replication Solutions that are set to replicate Recommended Entities. To take care of the errors and access the new list of Recommended Entities, you must do the following: Reset metadata for your Microsoft Dynamics 365 / CRM Connection.

 
  1. Open any Replication Solutions that use Microsoft Dynamics 365 / CRM as a source and replicate Recommended Entities. 
  2. Change the Entities selection on the Solution to either All entities or Selected  entities.
  3. Allow the Solution to save and finish preparing.
  4. Change the Entities selection on the Solution back to Recommended Entities.
 

After the update, if you have not reset metadata and modified your Replication Solutions as listed above: 

 
  • Existing Replication Solutions  will continue to run with the original list of Recommended Entities unless you change from Recommended to Selected Entities or All Entities. If you go back to Recommended Entities, the new list is used.

  • New Replication Solutions will use the new Recommended Entities. Any additional entities that are required can be configured in a second Replication Solution using the Selected Entities option.

 

The entities in the list below will no longer  be included in Recommended Entities. Check the list carefully  to determine whether or not:you need any of these entities. For the ones you feel you still need, configure a separate Replication Solution and select them using the Selected Entities option.

aciviewmapper
actioncard
actioncardusersettings
adminsettingsentity
advancedsimilarityrule
annualfiscalcalendar
appconfig
appconfiginstance
appmodule
appmodulecomponent
appmoduleroles
azureserviceconnection
bookableresourcebookingexchangesyncidmapping
bulkdeleteoperation
calendarrule
callbackregistration
canvasapp
channelaccessprofile
channelaccessprofileentityaccesslevel
channelaccessprofilerule
channelaccessprofileruleitem
channelproperty
channelpropertygroup
columnmapping
complexcontrol
connector
contracttemplate
convertrule
convertruleitem
customcontrol
customcontroldefaultconfig
customcontrolresource
documenttemplate
duplicaterulecondition
dynamicproperty
dynamicpropertyassociation
dynamicpropertyinstance
dynamicpropertyoptionsetitem
emailserverprofile
emailsignature
entitlementtemplate
entitlementtemplatechannel
entitlementtemplateproducts
entityanalyticsconfig
entitydataprovider
entitydatasource
environmentvariabledefinition
environmentvariablevalue
exchangesyncidmapping
expanderevent
expiredprocess
externalparty
externalpartyitem
fieldsecurityprofile
fileattachment
fixedmonthlyfiscalcalendar
globalsearchconfiguration
goalrollupquery
hierarchyrule
hierarchysecurityconfiguration
imagedescriptor
importentitymapping
incidentknowledgebaserecord
interprocesslock
kbarticlecomment
kbarticletemplate
knowledgearticleincident
knowledgearticlescategories
knowledgebaserecord
knowledgesearchmodel
languagelocale
languageprovisioningstate
leadtoopportunitysalesprocess
localconfigstore
mailboxstatistics
mailboxtrackingcategory
mailboxtrackingfolder
mobileofflineprofile
mobileofflineprofileitem
mobileofflineprofileitemassociation
monthlyfiscalcalendar
msdyn_3dmodel
msdyn_accountpricelist
msdyn_actioncardregarding
msdyn_actioncardrolesetting
msdyn_actual
msdyn_agreement
msdyn_agreementbookingdate
msdyn_agreementbookingincident
msdyn_agreementbookingproduct
msdyn_agreementbookingservice
msdyn_agreementbookingservicetask
msdyn_agreementbookingsetup
msdyn_agreementinvoicedate
msdyn_agreementinvoiceproduct
msdyn_agreementinvoicesetup
msdyn_agreementsubstatus
msdyn_analysiscomponent
msdyn_analysisjob
msdyn_analysisresult
msdyn_analysisresultdetail
msdyn_approval
msdyn_batchjob
msdyn_bookableresourceassociation
msdyn_bookingalert
msdyn_bookingalertstatus
msdyn_bookingchange
msdyn_bookingjournal
msdyn_bookingrule
msdyn_bookingsetupmetadata
msdyn_bookingtimestamp
msdyn_bpf_2c5fe86acc8b414b8322ae571000c799
msdyn_bpf_477c16f59170487b8b4dc895c5dcd09b
msdyn_bpf_665e73aa18c247d886bfc50499c73b82
msdyn_bpf_989e9b1857e24af18787d5143b67523b
msdyn_bpf_baa0a411a239410cb8bded8b5fdd88e3
msdyn_bpf_d3d97bac8c294105840e99e37a9d1c39
msdyn_bpf_d8f9dc7f099f44db9d641dd81fbd470d
msdyn_businessclosure
msdyn_callablecontext
msdyn_callablecontext_msdyn_playbooktemplate
msdyn_characteristicreqforteammember
msdyn_clientextension
msdyn_componentlayerdatasource
msdyn_configuration
msdyn_connector
msdyn_contactpricelist
msdyn_contractlineinvoiceschedule
msdyn_contractlinescheduleofvalue
msdyn_customerasset
msdyn_customerassetcategory
msdyn_databaseversion
msdyn_dataexport
msdyn_delegation
msdyn_dimension
msdyn_dimensionfieldname
msdyn_entitlementapplication
msdyn_entityconfiguration
msdyn_entityrankingrule
msdyn_estimate
msdyn_estimateline
msdyn_expense
msdyn_expensecategory
msdyn_expensereceipt
msdyn_fact
msdyn_fieldcomputation
msdyn_fieldservicepricelistitem
msdyn_fieldservicesetting
msdyn_fieldserviceslaconfiguration
msdyn_fieldservicesystemjob
msdyn_findworkevent
msdyn_flowcardtype
msdyn_forecastdefinition
msdyn_forecastinstance
msdyn_forecastrecurrence
msdyn_geofence
msdyn_geofenceevent
msdyn_geofencingsettings
msdyn_icebreakersconfig
msdyn_incidenttype
msdyn_incidenttype_requirementgroup
msdyn_incidenttypecharacteristic
msdyn_incidenttypeproduct
msdyn_incidenttypeservice
msdyn_incidenttypeservicetask
msdyn_incidenttypessetup
msdyn_integrationjob
msdyn_integrationjobdetail
msdyn_inventoryadjustment
msdyn_inventoryadjustmentproduct
msdyn_inventoryjournal
msdyn_inventorytransfer
msdyn_invoicefrequency
msdyn_invoicefrequencydetail
msdyn_invoicelinetransaction
msdyn_iotalert
msdyn_iotdevice
msdyn_iotdevicecategory
msdyn_iotdevicecategorycommands
msdyn_iotdevicecommand
msdyn_iotdevicecommanddefinition
msdyn_iotdevicecommandparameters
msdyn_iotdevicedatahistory
msdyn_iotdeviceproperty
msdyn_iotdeviceregistrationhistory
msdyn_iotpropertydefinition
msdyn_iotprovider
msdyn_iotproviderinstance
msdyn_iotsettings
msdyn_journal
msdyn_journalline
msdyn_mlresultcache
msdyn_msdyn_customerasset_msdyn_3dmodel
msdyn_msdyn_journal_msdyn_expense
msdyn_msdyn_journal_msdyn_timeentry
msdyn_notesanalysisconfig
msdyn_opportunitylineresourcecategory
msdyn_opportunitylinetransaction
msdyn_opportunitylinetransactioncategory
msdyn_opportunitylinetransactionclassificatio
msdyn_opportunitypricelist
msdyn_orderinvoicingdate
msdyn_orderinvoicingproduct
msdyn_orderinvoicingsetup
msdyn_orderinvoicingsetupdate
msdyn_orderlineresourcecategory
msdyn_orderlinetransaction
msdyn_orderlinetransactioncategory

msdyn_organizationalunit
msdyn_organizationalunit_pricelevel
msdyn_payment
msdyn_paymentdetail
msdyn_paymentmethod
msdyn_paymentterm
msdyn_playbookactivity
msdyn_playbookactivityattribute
msdyn_playbookcategory
msdyn_playbookinstance
msdyn_playbooktemplate
msdyn_postalbum
msdyn_postalcode
msdyn_postconfig
msdyn_postruleconfig
msdyn_priority
msdyn_processnotes
msdyn_productinventory
msdyn_project
msdyn_projectapproval
msdyn_projectparameter
msdyn_projectparameterpricelist
msdyn_projectpricelist
msdyn_projecttask
msdyn_projecttaskdependency
msdyn_projecttaskstatususer
msdyn_projectteam
msdyn_projectteammembersignup
msdyn_projecttransactioncategory
msdyn_purchaseorder
msdyn_purchaseorderbill
msdyn_purchaseorderproduct
msdyn_purchaseorderreceipt
msdyn_purchaseorderreceiptproduct
msdyn_purchaseordersubstatus
msdyn_quotebookingincident
msdyn_quotebookingproduct
msdyn_quotebookingservice
msdyn_quotebookingservicetask
msdyn_quotebookingsetup
msdyn_quoteinvoicingproduct
msdyn_quoteinvoicingsetup
msdyn_quotelineanalyticsbreakdown
msdyn_quotelineinvoiceschedule
msdyn_quotelineresourcecategory
msdyn_quotelinescheduleofvalue
msdyn_quotelinetransaction
msdyn_quotelinetransactioncategory
msdyn_quotelinetransactionclassification
msdyn_quotepricelist
msdyn_relationshipinsightsunifiedconfig
msdyn_requirementcharacteristic
msdyn_requirementgroup
msdyn_requirementorganizationunit
msdyn_requirementrelationship
msdyn_requirementresourcecategory
msdyn_requirementresourcepreference
msdyn_requirementstatus
msdyn_resourceassignment
msdyn_resourceassignmentdetail
msdyn_resourcecategorymarkuppricelevel
msdyn_resourcecategorypricelevel
msdyn_resourcepaytype
msdyn_resourcerequest
msdyn_resourcerequirement
msdyn_resourcerequirement_bookableresource
msdyn_resourcerequirement_bookingheader
msdyn_resourcerequirement_systemuser
msdyn_resourcerequirementdetail
msdyn_resourceterritory
msdyn_rma
msdyn_rmaproduct
msdyn_rmareceipt
msdyn_rmareceiptproduct
msdyn_rmasubstatus
msdyn_rolecompetencyrequirement
msdyn_roleutilization
msdyn_orderlinetransactionclassification
msdyn_orderpricelist
msdyn_rtv
msdyn_rtvproduct
msdyn_rtvsubstatus
msdyn_salesinsightssettings
msdyn_scheduleboardsetting
msdyn_schedulingparameter
msdyn_servicetasktype
msdyn_shipvia
msdyn_siconfig
msdyn_solutioncomponentdatasource
msdyn_solutionhealthrule
msdyn_solutionhealthruleargument
msdyn_solutionhealthruleset
msdyn_solutionhistory
msdyn_solutionhistorydatasource
msdyn_systemuserschedulersetting
msdyn_taxcode
msdyn_taxcodedetail
msdyn_teamscollaboration
msdyn_timeentry
msdyn_timegroup
msdyn_timegroupdetail
msdyn_timeoffcalendar
msdyn_timeoffrequest
msdyn_transactioncategory
msdyn_transactioncategoryclassification
msdyn_transactioncategoryhierarchyelement
msdyn_transactioncategorypricelevel
msdyn_transactionconnection
msdyn_transactionorigin
msdyn_transactiontype
msdyn_uniquenumber
msdyn_untrackedappointment
msdyn_upgraderun
msdyn_upgradestep
msdyn_upgradeversion
msdyn_userworkhistory
msdyn_wallsavedquery
msdyn_wallsavedqueryusersettings
msdyn_warehouse
msdyn_workhourtemplate
msdyn_workorder
msdyn_workordercharacteristic
msdyn_workorderdetailsgenerationqueue
msdyn_workorderincident
msdyn_workorderproduct
msdyn_workorderresourcerestriction
msdyn_workorderservice
msdyn_workorderservicetask
msdyn_workordersubstatus
msdyn_workordertype
msdynsm_marketingsitemap
msdynsm_salessitemap
msdynsm_servicessitemap
msdynsm_settingssitemap
msfp_emailtemplate
msfp_question
msfp_questionresponse
msfp_survey
msfp_surveyinvite
msfp_surveyresponse
msfp_unsubscribedrecipient
multientitysearchentities
multiselectattributeoptionvalues
navigationsetting
newprocess
new_scribechangehistory
offlinecommanddefinition
ownermapping
personaldocumenttemplate
picklistmapping
plugintracelog
principalsyncattributemap
processstage
processtrigger
quarterlyfiscalcalendar
queue
queueitem
queuemembership
ratingmodel
ratingvalue
recordcountsnapshot
recurrencerule
relationshiprolemap
replicationbacklog
rollupfield
rollupproperties
routingrule
routingruleitem
sdkmessageresponse
semiannualfiscalcalendar
sharepointdocument
similarityrule
slakpiinstance
socialinsightsconfiguration
solution
solutioncomponentdefinition
solutionhistorydata
sqlencryptionaudit
suggestioncardtemplate
syncattributemapping
syncerror
systemusermanagermap
systemusersyncmappingprofiles
teamsyncattributemappingprofiles
teamtemplate
template
textanalyticsentitymapping
theme
timestampdatemapping
timezonelocalizedname
topic
topicmodelconfiguration
topicmodelexecutionhistory
traceassociation
tracelog
traceregarding
transformationmapping
transformationparametermapping
translationprocess
untrackedemail
userfiscalcalendar
userform
usermapping
userquery
userqueryvisualization
usersearchfacet
webresource
workflowdependency




The following entities will be included in Recommended Entities.



account
annotation
appointment
bookableresource
bookableresourcebooking
bookableresourcebookingheader
bookableresourcecategory
bookableresourcecategoryassn
bookableresourcecharacteristic
bookableresourcegroup
bookingstatus
businessunit
businessunitnewsarticle
calendar
campaign
campaignactivity
campaignresponse
cardtype
category
characteristic
competitor
competitoraddress
connection
connectionrole
contact
contract
contractdetail
customeraddress
customeropportunityrole
customerrelationship
discount
discounttype
email
entitlement
entitlementchannel
entitlementcontacts
entitlemententityallocationtypemapping
entitlementproducts
equipment
fax
feedback
goal
incident
incidentresolution
interactionforemail
internaladdress
invoice
invoicedetail
kbarticle
knowledgearticle
knowledgearticleviews
lead
leadaddress
letter
list
mailbox
metric
opportunity
opportunityclose
opportunityproduct
opportunitysalesprocess
orderclose
phonecall
phonetocaseprocess
position
post
pricelevel
processsession
product
productpricelevel
publisher
publisheraddress
quote
quoteclose
quotedetail
recurringappointmentmaster
reportcategory
reportentity
reportlink
reportvisibility
role
salesliterature
salesliteratureitem
salesorder
salesorderdetail
service
serviceappointment
sharepointdocumentlocation
sharepointsite
site
sla
slaitem
socialactivity
socialprofile
subject
systemuser
task
territory
topichistory
topicmodel
transactioncurrency
uom
uomschedule