VERIFIED SOLUTION i

How to locate database connection string in EngageOne Delivery Audit

EngageOne Delivery Audit saves the database connection information in ClientBus.config and DataManager.config file.

Default location of ClientBus.config and DataManager.config files is 'C:\Program Files (x86)\PitneyBowes\EngageOne\Delivery Audit\Data Manager Web Services'

The first line 'DbConnectionString' contains the Database connection string in both the files.

Following are the contents from ClientBus.config file:
<!-- ClientBus.config.xml -->
<appSettings>
    <add key="DbConnectionString" value="server=<Server_Name_or_IP>;database=EODA_ClientBus_Database_Name>;trusted_connection=true"></add>
    <add key="BridgeCheckServiceUri" value="http://mail360hub.g1.com:8877/bus/bridge/check"></add>
    <add key="RepositoryPath" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\bus-repository\"></add>
    <add key="BridgeCycleTimeSpan" value="01:00:00"></add>
</appSettings>

Following are the contents from DataManager.config file:

<appSettings>
  <add key="DbConnectionString" value="server=<Server_Name_or_IP>;database=<EODA_Data_Manager_Database_Name>;trusted_connection=true" />
  <add key="dmSubscriberId" value="Data Manager" />
  <add key="licenseFile" value="" />
  <add key="accessKeys" value="03-9994993844-IMD" />
  <add key="temporaryDirectory" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\Temp\" />
  <add key="dmServiceHostName" value="<Server_Name_or_IP>" />
  <add key="dmServicePort" value="8884" />
  <add key="idServerServiceHostName" value="<Server_Name_or_IP>" />
  <add key="idServerServicePort" value="8887" />
  <add key="rptMgrServiceHostName" value="<Server_Name_or_IP>" />
  <add key="rptMgrServicePort" value="8886" />
  <add key="diagnosticUtilityServiceHostName" value="<Server_Name_or_IP>" />
  <add key="diagnosticUtilityServicePort" value="8888" />
  <add key="createJobWSCommandTimeoutSecs" value="30" />
  <add key="ifMatchesTextDoNotReturnWordMatchesForJob" value="false" />
  <add key="inputFileQueueName" value="mail360-messagereceiver-inputfiles" />
  <add key="inputFileStatusNotificationFlag" value="1" />
  <add key="inputFileStatusNotificationMailFromAddress" value="" />
  <add key="inputFileStatusNotificationMailToAddress" value="" />
  <add key="emailServerHost" value="" />
  <add key="emailServerPort" value="25" />
  <add key="emailEnableSSL" value="TRUE" />
  <add key="emailUsername" value="" />
  <add key="emailPassword" value="" />
  <add key="allowIncompleteJob" value="false" />
  <add key="scanInterval" value="1" />
  <add key="jobsArchiveFolder" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\jobs-archive\" />
  <add key="jobsHotFolderInputFileSourceName" value="jobs" />
  <add key="mrdfArchiveFolder" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\mrdf-archive\" />
  <add key="mrdfHotFolderInputFileSourceName" value="mrdf" />
  <add key="mrdfUnprocessedFolder" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\mrdf-unprocessed\" />
  <add key="mpdfHotFolderInputFileSourceName" value="mpdf" />
  <add key="mpdfArchiveFolder" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\mpdf-archive\" />
  <add key="mpdfUnprocessedFolder" value="C:\PitneyBowes\EngageOne\Delivery Audit Data\Data Manager\mpdf-unprocessed\" />
  <add key="hubMailerIdNotifierQueryTimeoutSecs" value="600" />
  <add key="hubMailerIdNotifierJobMailingDateLookbackDays" value="7" />
  <add key="cleanupHubMailerIdNotiferTempFile" value="TRUE" />
  <add key="cleanupUsageReportingTempFile" value="TRUE" />
  <add key="HubMailerIdNotifierDailyRunHour" value="1" />
  <add key="HubMailerIdNotifierDailyRunMinute" value="0" />
  <add key="AqDashboardAggregatorDailyRunHour" value="2" />
  <add key="AqDashboardAggregatorDailyRunMinute" value="0" />
  <add key="DataManagerUsageReportingDailyRunMinute" value="0" />
  <add key="DataManagerUsageReportingDailyRunHour" value="3" />
  <add key="DataManagerE2VaultExtractDailyRunHour" value="21" />
  <add key="DataManagerE2VaultExtractDailyRunMinute" value="00" />
  <add key="ssrs2005VirtualDirectory" value="reportserver" />
  <add key="ssrs2005HostName" value="<Server_Name_or_IP>" />
  <add key="ssrs2005Port" value="80" />
  <add key="ssrsRepositoryPath" value="/mail360" />
  <add key="transportSecurityEnabled" value="true" />
  <add key="ssrs2005UrlScheme" value="https" />
  <add key="serviceAuthorizationEnabled" value="true" />
  <add key="clientCertificateStoreName" value="TrustedPeople" />
  <add key="clientCertificateStoreLocation" value="LocalMachine" />
  <add key="clientCertificateFindType" value="FindBySubjectName" />
  <add key="clientSignatureHashAlgorithmName" value="SHA1" />
  <add key="shouldFindValidClientCertificatesOnly" value="true" />
  <add key="passwordLengthMinimum" value="8" />
  <add key="passwordLengthMaximum" value="2147483647" />
  <add key="passwordContainNumeric" value="true" />
  <add key="passwordContainLowercase" value="true" />
  <add key="passwordContainUppercase" value="true" />
  <add key="passwordContainSpecialLetter" value="true" />
  <add key="ClientSettingsProvider.ServiceUri" value="" />
  <add key="accessTokenLifetimeSeconds" value="7201" />
  <add key="keyStoreFilePath" value="C:\Program Files (x86)\PitneyBowes\EngageOne\Delivery Audit\Data Manager Web Services\keystore.xml" />
  <add key="keyStoreShouldUseMachineProtection" value="True" />
  <add key="diagnosticServiceNotificationMailFromAddress" value="" />
  <add key="diagnosticServiceNotificationMailToAddress" value="" />
  <add key="E2VaultExtractDefaultFirstRunDateTime" value="" />
  <add key="E2VaultExtractBatchSize" value="" />
  <add key="E2VaultArchivalFilePath" value="" />
  <add key="E2VaultConfiguredEkey" value="" />
  <add key="IsPostalTrackingEnable" value="true" />
  <add key="IsProductionTrackingEnable" value="false" />
  <add key="ProductionTrackingConfiguredEKey" value="key1" />
  <add key="MpdfFileDelimiterCharacter" value=";" />
  <add key="MrdfDateTimeFormat" value="yyyyMMddHHmmssfff" />
  <add key="MpdfDateTimeFormat" value="yyyyMMddHHmmssfff" />
  <add key="EnableOpenDJ" value="false" />
  <add key="ProtocolOpenDJServer" value="" />
  <add key="HostOpenDJServer" value="" />
  <add key="PortOpenDJServer" value="8085" />
  <add key="OpenDJAdminUserName" value="" />
  <add key="OpenDJAdminPassword" value="" />
  <add key="ExtractScanMaxPageSize" value="1000" />
</appSettings>

Mail360 Message Receiver service uses connection setting defined in the DataManager.config file.

For detailed information about the Config files, refer Section 'EngageOne Delivery Audit Configuration Settings' in EngageOne Delivery Audit install admin guide.
UPDATED:  September 27, 2017