微软Azure SQL边缘与联想ThinkSystemSE350解决方案指南.pdf

MicrosoftAzureSQLEdge

withLenovoThinkSystem

SE350SolutionGuide

Lastupdate:01December2021

Version1.1

HighlightsthebenefitsofPresentsausecaseforSQL

ThinkSystemSE350EdgeServeronLenovoEdge

Serverdevices

ProvidesdeploymentIncludeslistofallsoftware

informationandbestpracticespackagedownloadURLs

Inpartnershipwith

DavidWest

VinayKulkarni

TableofContents

1Introduction1

2Businessvalue2

3Architecturaloverview3

4Deploymentprerequisites4

5IoTEdgedevicesetup5

5.1CreateanIoTHubinAzure5

5.2InstallMobyEngineprerequisitesonedgedevice5

5.3InstallMobyEngine5

5.4InstalltheIoTEdgecomponents6

5.5RegisterthedevicewithAzureIoTHub6

5.6ConfigureIoTHubconnection6

6AzureSQLEdge-AzureIoTEdgemethod8

7AzureSQLEdge-Dockermethod12

8ConnectingtotheSQLEdgecontainer13

8.1ConnecttothecontainerCLI13

8.2ConnecttotheSQLinstancewithSSMS13

9AdddatavolumestoSQLEdgecontainer14

10PerformanceData15

11SampleUseCase-IoTstreamingdata16

11.1Downloadthecode16

11.2PrepareVisualStudioforAzureIoTprojects16

11.3LoadtheprojectfileinVisualStudio17

iMicrosoftAzureSQLEdgewithLenovoThinkSystemSE350SolutionGuide

11.4CreateaContainerRegistryinAzure17

11.5EditthecodeandpushthebuildtoAzure17

11.6DeploythesimulatormoduletotheIoTEdgedevice18

11.7Createthedatabaseforthesimulatordata20

11.8AddroutestoIoTEdgeModule20

11.9Verifystreamingdataflowandanalyzeresults21

11.10DataRetentionsettings21