Teradata Microsoft SS June08

8/6/2019 Teradata Microsoft SS June08

1/2

Teradata DatabaseandTeradata Enterprise Data Warehouse (EDW)

Teradataprovidesintegrated,optimized,andextensible

enterprisedatawarehousingtechnologyandservices

thatworksynergisticallywithMicrosoft Business

Intelligence(BI)technologies.

Solution OverviewKeytechnologiesfromTeradataandMicrosoftcanbecombinedtorealizeacomprehensive

BusinessIntelligencearchitecturethatprovidesanoptimizedsolutiontojoint

customers. Thisjointarchitectureincludes:

TeradataSolution provides integrated, optimized and extensible data warehouse technology for a

single application-neutral repository of the current and historical data, forming the framework for business

intelligence and sales and marketing analysis.

The latest release, Teradata 12.0, includes advanced features such as high-performance parallel database

technology, a cost-based optimizer, the most sophisticated mixed workload management tool available, a full

suite of data access and management tools and robust data mining software. Plus, expert data warehouse

training and the advice of the industry's most experienced data warehouse consulting professionals.

Microsoft Business IntelligenceTechnologiesMicrosoftoffersabroadsetofBusiness

Intelligencetechnologiesthatinclude:

MicrosoftSQLServer2005databasetechnologiesIntegrationServices, ReportingServices, Analysis

Services, whichprovideDataIntegration, EnterpriseReportingandReal-timeDataAnalysisrespectively.

PerformancePointTechnologiesincludingProClarity, forinteractivedrill-downandanalysisof

multidimensionaldataandBusinessScorecardManagerforinteractivedashboardingand

alerting.

MicrosoftOfficeSystemincludingMicrosoftOfficeExcel clientandservertheworldsmost

popularanalytictoolset,aswellasMicrosoftOfficePowerPoint andMicrosoftOfficeWord

forpresentationsandcommunications documentauthoring.

Microsoft and Teradata are two of our

strategic industry partners and we are

thrilled with the increased collaboration

between the companies technologies.

To get the most out of our data, we

need to be able to analyze every bit of

it as quickly as possible. The improved,

real-time intersection between the

Microsoft and Teradata environments

willhelp us improve this process and

enable us to provide a solution that will

better serve our customers.BillNoakes,executivevicepresidentandchiefinformationofficeratMeijerInc.

Top ReasonsWhyCustomers Choose Microsoftand Teradata EDW SolutionsThecombinationofMicrosoftandTeradata

enablesdatawarehousing/enterpriseBIsolutions

tobeextendedbroadlytotheinformationworkers

withinenterprisecompanieswhoaremostable

toimpactbusinessperformance. Customersand

prospectswillbenefitfromthecombinationof

Microsoftslowcost, enterprise-readybusiness

intelligencesolutionsandTeradatasscalability, high

performanceandlowTCO. MicrosoftandTeradata

customerswillbenefitfrom.

1. EasierimplementationofMicrosoftBI

solutionsintotheirTeradataEDW

2. Improvedperformanceandscalabilityfrom

Microsoftintegrationand Teradata BusinessIntelligence optimization

3. Fasteravailabilityandeasieradoptionofnew

Microsoft and Teradata feature releases,

because of Teradata and Microsoft joint andcollaborative engineering

4. Deliveryofkeybusinessdatatothepeople

bestplacedtoleverageit, throughtheir

preferredproductivitytools

5. Increased breadth and depth of data

delivered to the business users and thefront line workers

6. Reduced data latency between the time the

data is captured and the time the data isdelivered to the users

7. Eliminating middle-tier cube scalability

limitations
http://www.teradata.com/t/page/148798/index.htmlhttp://www.teradata.com/t/page/148798/index.htmlhttp://www.teradata.com/t/page/173919/index.htmlhttp://www.teradata.com/t/page/173919/index.htmlhttp://www.teradata.com/t/page/148798/index.htmlhttp://www.teradata.com/t/page/148798/index.htmlhttp://www.teradata.com/t/page/148798/index.html

8/6/2019 Teradata Microsoft SS June08

2/2

Business Pain Points AddressedCompaniestodayneedtoprovidetheiremployeeswithreliableaccesstotheinformationthey

needtomakeinformeddecisionssotheycanrespondswiftlyandappropriatelytochanging

conditionsthatimpacttheirbusiness.Theseorganizationshavetheneedtodeploybusiness

intelligencequickly, easilyandwithminimaltrainingrequired,withoutsacrificingperformance,reliabilityortheabilitytoscaleastheirenterprisedatagrows.MicrosoftBItechnologiesenable

userstosurfacekeybusinessinformationcontainedwithinTeradataEDWviapopularOfficetools.

ThosewhowillbeinterestedinthesynergybetweenTeradataandMicrosofttechnologiesare:

Customerslookingforaneasytodeploy, lowcostbusinessintelligencesolutionwith

unparalleledperformanceandscalability

Customersseekingtounlockanddeliverthevaluabledetailedandhistoricaldatatoall

employeesintheenterprise

CustomersplanningonrollingoutcosteffectiveBI-basedsolutionstoallemployees

Businessuserswithrequirementstoaccessconsistentanddetaileddataregardlessofthe

deliverychannel

Operationaluserswithrequirementstoaccessreal-timebusinessdataandbusinessevents

Technical Pain Points Addressed

JointcustomersofMicrosoftandTeradatatechnologieshavehistoricallystruggledwith

connectivitybetweenthetwoenvironments.Ononehand,theyhaveaTeradataEDWcapable

ofimmensescalability. Ontheotherhand,theyhavetheiruser spreferredtoolsetOffice.Users

requireaccesstothedataatvariouslevelsoftheorganizationandhaveoftenhadtoresortto

creatingduplicatedatastoresforreportingandforanalytics.Thishasresultedinanexpensiveand

difficult-to-maintainenterprisearchitecturewithmultipleversionsofthetruth.

ThecollaborationbetweenTeradataandMicrosoftmeetstheneedsofjointcustomers. Itresponds

tocustomersneedforanintegratedandenhancedTeradata-Microsoftbusinessintelligencesolution.

Customerswanttheabilitytocurtailtheproliferationandcostofdisconnecteddata-marts, consolidate

dataandscaletoverylargedatawarehousessupportingBIforthemasses.Therelationshipbetween

TeradataandMicrosoftisanaturalpartnershipbetweentwocompanieswithcomplementaryproducts.

MicrosoftandTeradatahavecollaboratedtoensurehighperformanceinteractionbetweenthe

TeradataEDWandMicrosoftSQLServerAnalysisServices(SSAS). ThisenablesTeradataEDW

informationtobesurfacedviaaspectrumofMicrosoftreportingandanalytictechnologies. Microsoft

hasdevelopedaTeradata-specificCartridgewhichcanbeusedbyMicrosoftdeveloperstoread

metadatafromTeradatatooptimizeSQL QueriesgeneratedbySSAS. ThenewTeradata .NETData

Provider(32bit&64bit)istheadvocatedinterfacewhenconnectingtoSQLServerAnalysisServices.

AlthoughSQLServerAnalysisServicessupportsMOLAP, HOLAP&ROLAParchitectures, thecompanies

areadvocatingaROLAParchitecturewhenconnectingtotheTeradataEDW. Thisarchitecture, combined

withsuchTeradataconstructsasAggregateJoinIndexes(AJIs), providesexcellent performancewithvery

largedatabases. LeveragingaROLAParchitectureeliminatestheneedtoexport datafromTeradatatoa

middletierforanalyticpurposes, savingagreatdealofprocessingtimeand diskstorage. Eliminatingthe

needfordatamovementinthisenvironmentenablescustomerstotake advantageofMicrosoftandTeradatacorecompetencies: MicrosoftAnalysisServicesisusedforits powerfulanalytic/cubing

capabilities; andTeradatasparallelprocessingpower.

Conclusion

MicrosoftandTeradataprovideexcellentanalyticanddatawarehousingtechnologiesthat, when

combinedtogether, providejointcustomerswith: excellentflexibilitytodeployinthewaythatbest

fitstheneedsofthebusiness, powerfulscalability, aneasytodeployandmaintainenvironment, and

cost-effectivenessthatenableseveryoneinthebusinesstobenefitfromBusinessIntelligence.

2008 Microsoft Corporation. All rights reserved.Thisdocument is for information purposesonly. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THISSUMMARY. Microsoft, theMicrosoft logo, SQL Server, and Windowsareeither registered trademarksor trademarksof Microsoft Corporation in the UnitedStatesand/orother countries. All other trademarksareproperty of their respectiveowners.

Part No. 098-107455

AboutTeradataTeradata Corporation (NYSE: TDC), is a global

technology leader in enterprise data warehousing,

analytic applications and data warehousing services.

Organizations around the world rely on thepower of Teradatas award-winning solutions to

get a single, integrated view of their business to

enhance decision-making, customer relationships

and profitability.

ContactInfo

Teradata Corporation

2835 Miami Village Drive

Miamisburg, OH, 45479

Phone: (937) 445-5993

http://www.teradata.com

Primary business contact:

Wendy-An Engelmann

Teradata Alliance Director

Phone: (714) 270-2348

E-mail: [email protected]

Primarytechnical contact:

Matt Zenus

Product ManagerPhone: (858) 485-3058


Microsoft Corporation

One Microsoft Way

Redmond, WA, 98052, USA

Primary business contact

Karl Dittman

Business Development Director

Phone: (248) 797-3113


U.S. sales contactTeri Doyle

Business Development Manager

Phone: (425) 421-7646


Primarytechnical contact

Vlad Eydelman

Technical Program Manager

Phone: (267) 251-6883

http://www.teradata.com/http://www.teradata.com/mailto:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]://www.teradata.com/

Teradata Microsoft SS June08

Documents

Transcript of Teradata Microsoft SS June08