Skip to content
The Bits That Byte
  • About
September 21, 2018 / Sitecore

xconnect.collection connectionString Values: Which One for Which Role

For those that use an XP1 build of Sitecore 9, setting the proper connectionStrings is critical for xConnect communication. One of the more confusing aspects are the connectionStrings named xconnect.collection and xconnect.collection.certificate. These may require either the xConnectCollection or xConnectCollectionSearch endpoint and matching thumbprint depending on the Sitecore Role.

  <add name="xconnect.collection" connectionString="https://Sitecore_xconnect" />
  <add name="xconnect.collection.certificate" connectionString="StoreName=My;StoreLocation=LocalMachine;FindType=FindByThumbprint;FindValue=" />

On the face of things, one would assume that you would always enter the endpoint and matching client certificate thumbprint for the https://xConnectCollection role running in xConnect. However, a careful review of the documentation unveils that this will either be the xConnectCollection or xConnectCollectionSearch endpoint if it is a CMS, CDS or other role.

Per the Sitecore 9 Update 2 Installation Guide, you will find that this endpoint on the CMS Server actually needs to be the xConnectCollectionSearch URL and matching client certificate thumbprint, while it is the xConnectCollection URL and matching client certificate thumbprint on others, such as the CDS, Processing and Reporting roles.

Client Certificate Matching by Sitecore 9 Role

Role Name Client Certificate Associated connection strings containing client thumbprint
Content Management xConnect Collection Search

xDB Reference Data

xDB Automation Operations

xDB Automation Reporting

xconnect.collection.certificate

xdb.referencedata.client.certificate

xdb.marketingautomation.reporting.client.certificate

xdb.marketingautomation.operations.client.certificate

Content Delivery xConnect Collection

xDB Reference Data

xDB Automation Operations

xconnect.collection.certificate

xdb.referencedata.client.certificate

xdb.marketingautomation.operations.client.certificate

Reporting xConnect Collection xconnect.collection.certificate
Processing xConnect Collection xconnect.collection.certificate
xConnect Collection None required* –
xConnect Collection Search None required* –
xDB Reference Data None required* –
xDB Automation Operations xConnect Collection xconnect.collection.certificate
xDB Automation Reporting None required* –

* These four roles do not require a client certificate because they do not make calls to other roles.

Post navigation

Previous Post:

When and How to Clean the Event Queue and Properties Tables

Next Post:

Sitecore 9 Administration Tools List

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Sitecore Technology MVP

Categories

  • AngularJS
  • Azure
  • CSS3
  • HTML5
  • Hyper-V
  • JavaScript
  • jQuery
  • OneDrive
  • PowerShell
  • Responsive Web Design
  • Search
  • SEO
  • SharePoint
  • Sitecore
  • SQL 2008 R2
  • SQL 2012
  • Tech Review
  • Tech Toy
  • Technical Resources
  • Uncategorized
  • Visual Studio
  • Web Content Management
  • Windows 8
  • Windows 8 App
  • Windows App
  • Windows Server 2008 R2
  • Workflow

Recent Posts

  • Sitecore Release Governance for Better Production Stability
  • 11 Tips for a More Stable Sitecore PaaS Environment
  • Sitecore Commerce 10.0.0 Bootstrap 404 Error and Other Changes
  • How to Run Cost Effective Sitecore Environments in Azure
  • Autofail: A Big Azure Autoscale Limitation and What To Do

Blogroll

  • Colins Sitecore Tech Blog
  • Sitecore Architecture – Grant's Sitecore Rants
April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Mar    
© 2021 thebitsthatbyte.com - Powered by SimplyNews