New Azure Synapse database templates in public preview

Published Nov 19 2021 09:00 AM 3,364 Views
Microsoft

As a follow-up to our recent announcement at Ignite regarding the public preview availability of Synapse database templates for six industries, we’re pleased to announce today that we are making available, in public preview, additional Synapse database templates for five more industries:

  • Agriculture 
  • Energy & Commodity Trading 
  • Freight & Logistics 
  • Oil & Gas 
  • Utilities 

 

The Synapse database template for Agriculture is a comprehensive data model that addresses the typical data requirements of organizations engaged in growing crops, raising livestock, and producing dairy products, including field and pasture management and satellite and drone data.

 

The Synapse database template for Energy & Commodity Trading is a comprehensive data model that addresses the typical data requirements of organizations engaged in trading energy, commodities, and/or carbon credits, whether as a primary trading business or in support of their supply chains, operating businesses, and hedging activities.

 

The Synapse database template for Freight & Logistics is a comprehensive data model that addresses the typical data requirements of organizations engaged in providing freight and logistics services, by air, ship, barge, train, truck, or any combination thereof. A significant portion of this database template is also included as part of the previously announced Retail and CPG database templates so companies in those industries will likely find what they need to manage their transportation and supply chain data in those models but companies whose primary focus is providing transportation and logistics services will likely prefer to focus instead on the dedicated Freight & Logistics database template.

 

The Synapse database template for Oil & Gas is a comprehensive data model that addresses the typical data requirements of organizations engaged in various phases of the Oil & Gas value chain, including any or all of oil sands mining, upstream / E&P, midstream, refining, petrochemicals, and distribution and retailing. In addition, our larger energy customers have shown significant interest in the complementary database templates for Energy & Commodity Trading and the power generation portion of the database template for Utilities.

 

The Synapse database template for Utilities is a comprehensive data model that addresses the typical data requirements of organizations engaged in generating power and/or transmitting, distributing, and/or retailing electricity, gas, and water. The database template for utilities also includes detailed support for the generation of power from Biomass, Coal, Hydro, Natural Gas and Oil, Nuclear, Solar, and/or Wind sources. The database template also includes detailed support for utility-scale water desalination for companies operating in parts of the world where that activity is part of the power and water business.

 

Most of the Synapse database templates contain many different business areas that together comprise each of these very large industry-specific data models. For example, in addition to business areas such as Product, Inventory, and HR, there is also an Emissions business area which provides support for data used to report greenhouse gas emissions (including scope 1, scope 2, and scope 3 emissions), an area of significant focus for many of our large customers.

 

These 5 additional database templates can be accessed now in Azure Synapse either in the gallery or by creating a new lake database from the Data tab and selecting + Table and then From template.

newmodels.png

Learn more:

%3CLINGO-SUB%20id%3D%22lingo-sub-2955431%22%20slang%3D%22en-US%22%3ENew%20Azure%20Synapse%20database%20templates%20in%20public%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955431%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20a%20follow-up%20to%20our%20recent%20announcement%20at%20Ignite%20regarding%20the%20public%20preview%20availability%20of%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FSynapseDatabaseTemplates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESynapse%20database%20templates%3C%2FA%3E%20for%20six%20industries%2C%20we%E2%80%99re%20pleased%20to%20announce%20today%20that%20we%20are%20making%20available%2C%20in%20public%20preview%2C%20additional%20Synapse%20database%20templates%20for%20five%20more%20industries%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CU%3EAgriculture%3C%2FU%3E%3C%2FSTRONG%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CU%3EEnergy%20%26amp%3B%20Commodity%20Trading%3C%2FU%3E%3C%2FSTRONG%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CU%3EFreight%20%26amp%3B%20Logistics%3C%2FU%3E%3C%2FSTRONG%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CU%3EOil%20%26amp%3B%20Gas%3C%2FU%3E%3C%2FSTRONG%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CU%3EUtilities%3C%2FU%3E%3C%2FSTRONG%3E%26nbsp%3B%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Synapse%20database%20template%20for%20%3CSTRONG%3E%3CU%3EAgriculture%3C%2FU%3E%3C%2FSTRONG%3E%20is%20a%20comprehensive%20data%20model%20that%20addresses%20the%20typical%20data%20requirements%20of%20organizations%20engaged%20in%20growing%20crops%2C%20raising%20livestock%2C%20and%20producing%20dairy%20products%2C%20including%20field%20and%20pasture%20management%20and%20satellite%20and%20drone%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Synapse%20database%20template%20for%20%3CSTRONG%3E%3CU%3EEnergy%20%26amp%3B%20Commodity%20Trading%3C%2FU%3E%3C%2FSTRONG%3E%20is%20a%20comprehensive%20data%20model%20that%20addresses%20the%20typical%20data%20requirements%20of%20organizations%20engaged%20in%20trading%20energy%2C%20commodities%2C%20and%2For%20carbon%20credits%2C%20whether%20as%20a%20primary%20trading%20business%20or%20in%20support%20of%20their%20supply%20chains%2C%20operating%20businesses%2C%20and%20hedging%20activities.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Synapse%20database%20template%20for%20%3CSTRONG%3E%3CU%3EFreight%20%26amp%3B%20Logistics%3C%2FU%3E%3C%2FSTRONG%3E%20is%20a%20comprehensive%20data%20model%20that%20addresses%20the%20typical%20data%20requirements%20of%20organizations%20engaged%20in%20providing%20freight%20and%20logistics%20services%2C%20by%20air%2C%20ship%2C%20barge%2C%20train%2C%20truck%2C%20or%20any%20combination%20thereof.%20A%20significant%20portion%20of%20this%20database%20template%20is%20also%20included%20as%20part%20of%20the%20previously%20announced%20Retail%20and%20CPG%20database%20templates%20so%20companies%20in%20those%20industries%20will%20likely%20find%20what%20they%20need%20to%20manage%20their%20transportation%20and%20supply%20chain%20data%20in%20those%20models%20but%20companies%20whose%20primary%20focus%20is%20providing%20transportation%20and%20logistics%20services%20will%20likely%20prefer%20to%20focus%20instead%20on%20the%20dedicated%20Freight%20%26amp%3B%20Logistics%20database%20template.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Synapse%20database%20template%20for%20%3CSTRONG%3E%3CU%3EOil%20%26amp%3B%20Gas%3C%2FU%3E%3C%2FSTRONG%3E%20is%20a%20comprehensive%20data%20model%20that%20addresses%20the%20typical%20data%20requirements%20of%20organizations%20engaged%20in%20various%20phases%20of%20the%20Oil%20%26amp%3B%20Gas%20value%20chain%2C%20including%20any%20or%20all%20of%20oil%20sands%20mining%2C%20upstream%20%2F%20E%26amp%3BP%2C%20midstream%2C%20refining%2C%20petrochemicals%2C%20and%20distribution%20and%20retailing.%20In%20addition%2C%20our%20larger%20energy%20customers%20have%20shown%20significant%20interest%20in%20the%20complementary%20database%20templates%20for%20Energy%20%26amp%3B%20Commodity%20Trading%20and%20the%20power%20generation%20portion%20of%20the%20database%20template%20for%20Utilities.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Synapse%20database%20template%20for%20%3CSTRONG%3E%3CU%3EUtilities%3C%2FU%3E%3C%2FSTRONG%3E%20is%20a%20comprehensive%20data%20model%20that%20addresses%20the%20typical%20data%20requirements%20of%20organizations%20engaged%20in%20generating%20power%20and%2For%20transmitting%2C%20distributing%2C%20and%2For%20retailing%20electricity%2C%20gas%2C%20and%20water.%20The%20database%20template%20for%20utilities%20also%20includes%20detailed%20support%20for%20the%20generation%20of%20power%20from%20Biomass%2C%20Coal%2C%20Hydro%2C%20Natural%20Gas%20and%20Oil%2C%20Nuclear%2C%20Solar%2C%20and%2For%20Wind%20sources.%20The%20database%20template%20also%20includes%20detailed%20support%20for%20utility-scale%20water%20desalination%20for%20companies%20operating%20in%20parts%20of%20the%20world%20where%20that%20activity%20is%20part%20of%20the%20power%20and%20water%20business.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20of%20the%20Synapse%20database%20templates%20contain%20many%20different%20business%20areas%20that%20together%20comprise%20each%20of%20these%20very%20large%20industry-specific%20data%20models.%20For%20example%2C%20in%20addition%20to%20business%20areas%20such%20as%20Product%2C%20Inventory%2C%20and%20HR%2C%20there%20is%20also%20an%20Emissions%20business%20area%20which%20provides%20support%20for%20data%20used%20to%20report%20greenhouse%20gas%20emissions%20(including%20scope%201%2C%20scope%202%2C%20and%20scope%203%20emissions)%2C%20an%20area%20of%20significant%20focus%20for%20many%20of%20our%20large%20customers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThese%205%20additional%20database%20templates%20can%20be%20accessed%20now%20in%20Azure%20Synapse%20either%20in%20the%20gallery%20or%20by%20creating%20a%20new%20lake%20database%20from%20the%20Data%20tab%20and%20selecting%20%3CSTRONG%3E%2B%20Table%3C%2FSTRONG%3E%20and%20then%20%3CSTRONG%3EFrom%20template%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22newmodels.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326354i202F2323919F5FB2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22newmodels.png%22%20alt%3D%22newmodels.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20more%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fdatabase-designer%2Foverview-database-templates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOverview%20of%20database%20templates.%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fdatabase-designer%2Fconcepts-lake-database%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ELearn%20more%20about%20lake%20databases.%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fdatabase-designer%2Fcreate-lake-database-from-lake-database-templates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20get%20started%20with%20database%20templates%20and%20lake%20databases.%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2955431%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22newmodelsgraphic.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326352i21632AA18ED33BB9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22newmodelsgraphic.png%22%20alt%3D%22newmodelsgraphic.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAzure%20Synapse%20includes%20database%20templates%20for%205%20additional%20industries%2C%20available%20now%20in%20public%20preview.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2955431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Studio%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Nov 19 2021 01:51 AM
Updated by: