Published: October 2009 Applies to: sql server 2008 Summary

Download 162.66 Kb.
Size162.66 Kb.
  1   2   3   4   5   6   7

Microsoft Connector for Teradata by Attunity

SQL Server Technical Article

Writer: Doug Wheaton (Attunity)

Technical Reviewers: Ramakrishnan Krishnan (Microsoft), Rupal Shah (Teradata)

Published: October 2009

Applies to: SQL Server 2008

Summary: This white paper presents detailed information on Microsoft Connector for Teradata by Attunity. It contains an overview of the architecture, installation and configuration information, common use cases, and detailed technical appendices.


The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.


Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 2009 Microsoft Corporation. All rights reserved.

Microsoft, SQL Server, and Windows are trademarks of the Microsoft group of companies.

All other trademarks are property of their respective owners.



Introduction 27

Architecture 28

Prerequisites and Installation 29

SQL Server Components 29

Required Teradata Components 29

Installation 31

General Configuration in SQL Server Business Intelligence Development Studio 33

Enabling Teradata Source and Teradata Destination as Data Flow Toolbox Items 33

Configuring the Teradata Connection Manager 33

Use Case 1: Bulk Unload from Teradata to SQL Server Using TPT Export 35

Use Case Architecture Overview 35

Description 35

Defining the SQL Server Integration Services Data Flow 35

Configuring the Teradata Source Component 35

Choosing the Data Access Mode 38

Adding and Configuring the Destination Component 38

Use Case 2: Bulk Load into Teradata Using TPT Load 38

Use Case 2 Architecture Overview 38

Description 39

Defining the SQL Server Integration Services Data Flow 39

Adding and Configuring Source and Teradata Destination Components 39

Use Case 3: Incremental Load into Teradata Using TPT Stream 39

Description 39

Architecture 40

Defining the SQL Server Integration Services Data Flow 40

Adding and Configuring Source and Teradata Destination Components 40

Conclusion 40

Appendix A – Data Types 42

Supported Data Types 42

Data Type Mapping 42

Appendix B – Teradata Source Advanced Topics 46

Teradata Source 46

Error Handling 46

Parallelism 46

Troubleshooting the Teradata Source 46

Configuring the Teradata Source 47

Teradata Source Editor (Connection Manager Page) 47

Teradata Source Editor (Columns Page) 48

Teradata Source Editor (Error Output Page) 48

Teradata Source Advanced Editor 49

Teradata Source Custom Properties 49

Appendix C – Teradata Destination Component Advanced Topics 53

Teradata Destination 53

Load Options 53

Error Handling 53

Parallelism 55

Troubleshooting the Teradata Destination 55

Configuring the Teradata Destination 55

Teradata Destination Editor (Connection Manager Page) 56

Teradata Destination Editor (Mappings Page) 57

Teradata Destination Editor (Error Output Page) 58

Teradata Destination Advanced Editor 59

Teradata Destination Custom Properties 59

Appendix D – Troubleshooting Run-Time Failures 61

STEP 1– Eliminate the Common Problems 62

STEP 2 - Using the Logging Facility 62

STEP 3 - Understanding the Log File 63

Download 162.66 Kb.

Share with your friends:
  1   2   3   4   5   6   7

The database is protected by copyright © 2020
send message

    Main page