SQL Server Using Power BI in Hybrid IT云计算Word格式.docx
- 文档编号:22733351
- 上传时间:2023-02-05
- 格式:DOCX
- 页数:36
- 大小:1.12MB
SQL Server Using Power BI in Hybrid IT云计算Word格式.docx
《SQL Server Using Power BI in Hybrid IT云计算Word格式.docx》由会员分享,可在线阅读,更多相关《SQL Server Using Power BI in Hybrid IT云计算Word格式.docx(36页珍藏版)》请在冰豆网上搜索。
TechnicalReviewers:
EdPrice,CarlaSabotta,CindyGross,OlivierMatrat,KayUnkroth,DerrickVanArnam,AdamSaxton,DavidTorres,GregLow,RossLoForte
Published:
August,2014
Appliesto:
SQLServer,MicrosoftPowerBI,MicrosoftAzure
Copyright
Thisdocumentisprovided“as-is”.Informationandviewsexpressedinthisdocument,includingURLandotherInternetWebsitereferences,maychangewithoutnotice.Youbeartheriskofusingit.
Someexamplesdepictedhereinareprovidedforillustrationonlyandarefictitious.
Norealassociationorconnectionisintendedorshouldbeinferred.
ThisdocumentdoesnotprovideyouwithanylegalrightstoanyintellectualpropertyinanyMicrosoftproduct.Youmaycopyandusethisdocumentforyourinternal,referencepurposes.
©
2014Microsoft.Allrightsreserved.
TableofContents
Introduction4
CloudComputingDefinitions4
Cloud-OnlyModel5
Azure6
Office3656
HybridCloudModel7
HybridArchitecture10
HybridEnvironmentwithPaaS10
HybridEnvironmentwithIaaS10
AzureVirtualNetwork10
AzureVMs12
Security14
Office365Security14
AzureSecurity15
ActiveDirectoryIntegration15
ActiveDirectoryandOffice36515
ActiveDirectoryandAzureIaaS17
Office365andAzureSecurityCompliance17
PowerBI18
PowerBIFeatures18
PowerBIinExcel18
PowerBIforOffice36519
PowerBIDataRefresh20
ODataFeedsforNon-RefreshableDataSources21
PowerBICloudDataSources21
AzureVMRunningSQLServerasaDataSource24
DataManagementGateway24
DataSourceRegistration25
ODataFeedsfromPowerBIDataSources28
PowerQueryDataRefreshforOn-PremisesData31
Conclusion31
AuthorBios32
Introduction
ThisdocumentdetailsthetasksnecessarytoimplementMicrosoftPowerBIforOffice365inahybridenvironment.Itdescribesbestpracticesforsecurity,networking,andcomponentarchitectureforbuildingahybridbusinessintelligence(BI)environmentbyusingacombinationofMicrosoftOffice365,MicrosoftAzure,andon-premisesdatasources.
Inaddition,wedescribeoptionsandbestpracticesforeachserviceyoumightincludeinahybridenvironment.Thisdocumentalsoprovidesguidanceforintegratingsecurityandidentitymanagementinahybridenvironment,aswellashowtoconfigurePowerBItorefreshdatafromsupportedsourceswithinthisenvironment.
NoteBecauseAzureservicescanchangefrequently,pleaserefertotheMicrosoftAzurewebsitefortheofferingsandrangeoffeaturescurrentlyavailable.
Thegoalofthisdocumentistohelpyouunderstandhowtodesignanarchitectureinwhichtheseservicescansecurelyinteractnotonlywitheachother,butalsowithyouron-premisesenvironment.
Thetargetaudienceforthisdocumentissystemandnetworkadministratorsaswellasbusinessintelligence(BI)solutionarchitectsanddeveloperswhowanttoimplementPowerBIforOffice365inahybridenvironment.Togetthemostoutofthisdocument,youshouldhaveabasicunderstandingofvirtualprivatenetwork(VPN)connectionsandcloudcomputing.Tolearnmoreaboutcloudcomputing,seeMicrosoftAzure,theMicrosoftAzureInfographic(allAzureInfographics),andGetStartedwithOffice365.TolearnmoreaboutVPNs,seeConnectanon-premisesnetworktoaMicrosoftAzurevirtualnetwork.
CloudComputingDefinitions
Thereareafewtermsthatareuniquetocloudcomputing.Inthisdocument,thefollowingdefinitionsapply:
CloudComputingTheNationalInstituteforStandardsandTechnologydefinescloudcomputingasamodelfor“enablingubiquitous,convenient,on-demandnetworkaccesstoasharedpoolofcomputingresources(e.g.networks,servers,storage,applications,andservices)thatcanberapidlyprovisionedandreleasedwithminimalmanagementeffortorserviceproviderinteraction.”
InfrastructureasaService(IaaS)Thecapabilitytoprovisionstorage,archive,network,andserverresourcesinasharedenvironment.Typically,serverresourcesaredeployedasvirtualmachines(VMs).Themanagementoftheserveroperatingsystemsandotherresourceswithinthisenvironmentisperformedbythecustomer,butthemanagementoftheunderlyinghardwareandhypervisorisperformedbytheprovider.AzureVirtualMachinesandAzureVirtualNetworksarekeycomponentsofIaaSavailableinAzure.
HybridCloudAninfrastructurethatbridgeson-premisescomputingresourcesandapubliccloud.Ahybridcloudenvironmentmaybeusedforfunctionalitysuchascloudbursting(i.e.sendingaworkloadtothecloudwhenon-premisesresourceshavebeenexhausted)ordisasterrecovery.
PlatformasaService(PaaS)Thecapabilityforthecustomertodeployapplicationtiers,suchasadatabaseorawebservice,toacontainermanagedbytheprovider.Thecustomerdoesnotmanageoperatingsystemsorinfrastructureinthismodel,buthascontrolovertheirapplication,data,andpossiblysomeconfigurationsettings.AzureSQLDatabaseorHDInsightareexamplesofPaaSinAzure.
PowerBIThecombinedMicrosoftself-servicebusinessintelligencesolution.PowerBIisaseparateserviceforOffice365andincludesseveralfeaturesinExcel2013(PowerPivot,PowerView,PowerQuery,andPowerMap).ForthedifferencesbetweenPowerBIinExcel2013andPowerBIforOffice365,seethePowerBIsectionbelow.
PublicCloudCloudresourcesareavailableforusebythegeneralpublicandexistinthedatacentersofthecloudprovider.
PrivateCloudAvirtualizationinfrastructureprovisionedforusebyasingleorganizationordepartmentwithinthatorganization.Itmayexistonorofftheorganization’spremises.
SoftwareasaService(SaaS)Thecapabilityforthecustomertousetheprovider’sapplicationsrunningontheprovider’scloudinfrastructure.TheapplicationsarebroadlyaccessiblefromanInternetbrowser.Althoughthecustomerdoesnotmanageanyoftheunderlyinginfrastructure,thecustomermanagescontentandpossiblysomelimitedconfigurationsettings.Office365isanexampleofanSaaSoffering.
Cloud-OnlyModel
Microsoftoffersavarietyofservicesthatyoucanuseindependentlyorincombinationwithoneanothertoarchitectabusinessintelligencesolutioninthecloud.AportionofthistypeofsolutionreliesonIaaSorPaaSservicesavailablethroughAzure,whiletheremainderofthesolutionreliesonOffice365,asshowninFigure1.Althoughtheseservicesareallcloud-based,it’simportanttounderstandthatAzureandOffice365operateinseparatecontainers,includingthenetworkandauthenticationlayers.
Figure1:
Office365andAzureservicessupportbusinessintelligenceinthecloudinseparatecontainers
Azure
AzureservicesincludebothIaaSandPaaSofferings.YoucanrunSQLServerinaVMthatyoumanageinternallyandthenuseaVirtualNetworktosecurelyandreliablyaccessitfromotherVMsinAzureorfromresourcesinyouron-premisesnetwork.Asanalternative,youcanuseSQLDatabaseasacloud-basedrelationaldatabaseplatformthatrequiresminimalmanagement.Toworkwithbigdatainthecloud,youcanuseHDInsight,Microsoft’sHadoop-basedservice.
Office365
Office365isanSaaSofferingthatincludestheentireMicrosoftOfficesuite.WithOffice365,yourorganizationnolongerneedstomanageinfrastructureforMicrosoftSharePointandMicrosoftExchange,andcanstilldeliverarich,interactivebusinessintelligenceexperiencebyprovidinguserswithPowerBI.Thisexperiencebeginswhenuserscreateworkbookscontainingdatamodels,reports,businessformulas,KPIs,andvisualizationsbyusingoneormoreofthefollowingself-serviceBItoolsinExcel2013:
PowerQuery,PowerPivot,PowerView,andPowerMap.Userscanthenshare,explore,andmanagetheseworkbooksonlinebyusingthefollowingPowerBIforOffice365features:
PowerBIsites,PowerBIQ&
A,QueryandDataManagement,andthePowerBIapp.ThedatamodelsstoredintheworkbookscanuseasingledatasourceorcombinemultipledisparatedatasourcesobtainedfromwebsitesorAzureresourcesinacloud-onlymodel.
HybridCloudModel
Mostorganizationsarenotmovingtheirentireinfrastructuretothecloud.Whilethisoptionmightbeviableforstartupcompanies,largerestablishedfirmshavinganexistinginvestmentininfrastructurearemotivatedbythesavingsandagilitytheygainwhentransitioningtocloudofferings.Themostcommoncloud-basedinfrastructurescenariosatthetimeofthiswritingareamixofIaaSandSaaS.PaaSofferingshavehadsloweradoptionrates.BothIaaSandSaaSareoftenbettercandidatesfornewdevelopmentwork.Inparticular,IaaSiseasiertousewithexistingapplications.Ontheotherhand,manyorganizationsareconsideringPaaSfordevelopingfutureapplications.
Meanwhile,ahybridcloudinfrastructureisagoodmodelfororganizationsnewtocloudcomputing,whethertheywanttostartsimplywithadisasterrecoverysolutionforanon-premisesSQLServerorimplementfull-fledgedBIsolutionsthatrelyonPowerBI.Therearefourdifferentarchitecturalscenarios(variants)fromwhichyoucanchoosewhenimplementingPowerBIinahybridenvironment:
∙SaaS,IaaS,PaaS,andOn-PremisesWiththisarchitecture(sho
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SQL Server Using Power BI in Hybrid IT云计算 IT 计算
链接地址:https://www.bdocx.com/doc/22733351.html