Sitecore 9 in Azure

This post will contain a list of notes made during a provisioning of Sitecore 9 with a number of modules.

Versions used:

• Experience Platform 9.0.1 rev. 171219
• Powershell Extensions 4.7.2
• Experience Accelerator 1.6 rev. 180103

Later we will include Commerce 9.0 Update-1

Databases:

• core-db
• master-db
• web-db
• reporting-db
• processing-pools-db
• processing-tasks-db
• marketing-automation-db
• messaging-db (Rebus message bus)
• xdb-collection-shardmapmanager-db (Microsoft Shard Map Manager)
• reference-data-db
• experience-forms-db
• exm-master-db
• xdb-collection-shard0-db
• xdb-collection-shard1-db

Azure search indexes

• sitecore-master-index
• sitecore-core-index
• sitecore-web-index
• sitecore-marketingdefinitions-master
• sitecore-marketingdefinitions-web
• xdb (analytics index)

API keys

• reporting.apikey (key needs to be 32 random characters)

XP "services"

The following list contains parts of the XP platform, that are not provisioned as Sitecore instances/websites

xconnect.collection

Type: asp.net 4.x site, provisioned as App Service
Connections:

• xdb.processing.pools -> processing-pools-db
• xdb.marketingautomation -> marketing-automation-db
• messaging -> messaging-db
• collection -> xdb-collection-shardmapmanager-db

xconnect.collection-search

Type: asp.net 4.x site, provisioned as App Service
Connections:

• xdb.processing.pools -> processing-pools-db
• xdb.marketingautomation -> marketing-automation-db
• messaging -> messaging-db
• collection -> xdb-collection-shardmapmanager-db
• collection.search -> xdb

xconnect.collection-search IndexWorker

Type: Windows service or Azure WebJob
Is located inside the App_Data\jobs folder in the xconnect.collection-search package.

Don't forget the license.xml file
Connections: same as xconnect.collection-search, inherited from the App Service in Azure

reference-data

Type: asp.net 4.x site, provisioned as App Service
Connections:

• xdb.referencedata -> reference-data-db

marketing-automation

Type: ASP.NET 4.x site, provisioned as App Service
Connections:

• messaging -> messaging-db
• xdb.marketingautomation -> marketing-automation-db
• xdb.referencedata -> reference-data-db
• xconnect.collection -> xconnect.collection service via https
• xconnect.collection.certificate -> xconnect.collection service certificate ID

marketing-automation AutomationEngine

Type: Windows service or Azure WebJob
Is located inside the App_Data\jobs folder in the marketing-automation package.
Requires the license.xml file
Connections: same as marketing-automation, inherited from the App Service in Azure

marketing-automation-reporting

Type: ASP.NET 4.x site, provisioned as App Service
Connections:

• xdb.marketingautomation -> marketing-automation-db

Sitecore roles

The following list of sites are all old-school Sitecore websites/instances.

CM

Connections:

• core -> core-db
• master -> master-db
• web -> web-db
• messaging -> messaging-db
• xconnect.collection -> xconnect.collection-search !!! service url via https
• xconnect.collection.certificate -> xconnect.collection-search certificate ID
• xdb.referencedata -> reference-data-db
• xdb.referencedata.client -> reference-data service url via https
• xdb.referencedata.client.certificate -> reference-data service certificate ID
• reporting.apikey -> reporting.apikey defined
• xdb.marketingautomation.reporting.client -> marketing-automation-reporting service url via https
• xdb.marketingautomation.reporting.client.certificate -> marketing-automation-reporting service certificate ID
• xdb.marketingautomation.operations.client -> marketing-automation service url via https
• xdb.marketingautomation.operations.client.certificate -> marketing-automation service certificate ID
• experienceforms -> experience-forms-db
• EXM.CryptographicKey - N/A
• EXM.AuthenticationKey - N/A
• cloud.search -> Azure search host url

Please note that the xconnect.collection connection string name has been reused on CM to point to the xconnect.collection-search service

CD

Connections:

• core -> core-db
• web -> web-db
• messaging -> messaging-db
• xconnect.collection -> xconnect.collection service url via https
• xconnect.collection.certificate -> xconnect.collection certificate ID
• xdb.referencedata.client -> reference-data service url via https
• xdb.referencedata.client.certificate -> reference-data service certificate ID
• reporting.apikey -> reporting.apikey defined
• xdb.marketingautomation.operations.client -> marketing-automation service url via https
• xdb.marketingautomation.operations.client.certificate -> marketing-automation service certificate ID
• experienceforms -> experience-forms-db
• EXM.CryptographicKey - N/A
• EXM.AuthenticationKey - N/A
• redis.sessions -> Redis cache host url
• cloud.search -> Azure search host url

PRC

Connections:

• core -> core-db
• master -> master-db
• web -> web-db
• xconnect.collection -> xconnect.collection service url via https
• xconnect.collection.certificate -> xconnect.collection certificate ID
• xdb.referencedata -> reference-data-db
• xdb.processing.pools -> processing-pools-db
• reporting.apikey -> reporting.apikey defined
• reporting -> reporting-db
• xdb.processing.tasks -> processing-tasks-db
• EXM.CryptographicKey - N/A
• EXM.AuthenticationKey - N/A

REP

Connections:

• core -> core-db
• master -> master-db
• web -> web-db
• reporting.apikey -> reporting.apikey defined
• reporting -> reporting-db
• EXM.CryptographicKey - N/A
• EXM.AuthenticationKey - N/A

DDS

Not installed in this deployment (yet)

Changes to the CM config:

   <sitecore>
        <reporting>
            <remote>
                <httpTransportFactory>
                    <param desc="serviceUrl">[URL TO REPORTING SERVER]</param>
                </httpTransportFactory>
            </remote>
        </reporting>
        <processing>
            <remote>
                <httpTransportFactory>
                    <param desc="serviceUrl">[URL TO PROCESSING SERVER]</param>
                </httpTransportFactory>
            </remote>
        </processing>
   </sitecore>