Artikel

AWS Data Exchange and Teradata Vantage

This how-to guide will help you connect Teradata Vantage with the AWS Data Exchange service. Read more for step-by-step instructions.

Wenjie Tehan
Wenjie Tehan
5. Oktober 2021 2 min Lesezeit
Vantage and AWS Data Exchange

Many Teradata customers are interested in integrating Teradata Vantage with Amazon Web Services (AWS) First Party Services. This guide will help you connect Teradata Vantage with the AWS Data Exchange service. 

The procedure offered in this guide has been implemented and tested by Teradata. However, it is offered on an as-is basis. Neither AWS nor Teradata provide validation of Teradata Vantage with AWS Data Exchange. 

This guide includes content from both AWS and Teradata product documentation. 

Overview 

This post describes the process to subscribe to a dataset in AWS Data Exchange, export it to Amazon S3, and then query it with Teradata Vantage, either leveraging Native Object Store (NOS) capability or the Teradata Parallel Transporter (TPT) utility. 

About AWS Data Exchange 

AWS Data Exchange makes it easy to find, subscribe to, and use third-party data in the cloud. Today, AWS Data Exchange contains data products from a broad range of domains, including financial services, healthcare and life sciences, geospatial, weather, and mapping. Once subscribed to a data product, you can use the AWS Data Exchange API to export data into Amazon S3, and then use Teradata Vantage to explore and analyze the data. 

About Teradata Vantage 

Teradata Vantage is the connected multi-cloud data platform for enterprise analytics. It enables ecosystem simplification by unifying analytics, data lakes and data warehouses. Leading the way with multi-cloud environments and priced for flexibility, Vantage leverages 100 percent of a business’s data, regardless of scale, volume, or complexity. 

Vantage combines descriptive, predictive, prescriptive analytics, autonomous decision-making, machine learning (ML) functions, and visualization tools into a unified, integrated platform that uncovers real-time business intelligence at scale, no matter where the data resides. 

Vantage enables companies to start small and elastically scale compute or storage, paying only for what they use, harnessing low-cost object stores and integrating their analytic workloads. Vantage supports R, Python, Teradata Studio, and any other SQL-based tools. You can deploy Vantage across public clouds, on-premises, on optimized or commodity infrastructure, or as-a-service. 

Teradata Vantage Native Object Store (NOS) can be used to explore data in external object stores, like Amazon S3, using standard SQL. No special object storage-side compute infrastructure is required to use NOS. You can explore data located in an Amazon S3 bucket by simply creating a NOS table definition that points to your bucket. With NOS, you can quickly import data from Amazon S3 or even join it other tables in the database. 

Alternatively, the Teradata Parallel Transporter (TPT) utility can be used to import data from Amazon S3 to Teradata Vantage in bulk fashion. Once loaded, data can be efficiently queried within Vantage. 
Screen-Shot-2021-10-07-at-10-22-15-AM.pngScreen-Shot-2021-10-07-at-10-24-07-AM.pngScreen-Shot-2021-10-07-at-10-24-46-AM.pngScreen-Shot-2021-10-07-at-10-25-15-AM.pngScreen-Shot-2021-10-07-at-10-25-45-AM.png
Screen-Shot-2021-10-07-at-10-34-47-AM.pngScreen-Shot-2021-10-07-at-10-35-13-AM.pngScreen-Shot-2021-10-07-at-10-35-34-AM.pngScreen-Shot-2021-10-07-at-10-36-03-AM.png
Screen-Shot-2021-10-07-at-10-36-28-AM.png
Screen-Shot-2021-10-07-at-10-37-11-AM.pngScreen-Shot-2021-10-07-at-10-37-36-AM.pngScreen-Shot-2021-10-07-at-10-38-05-AM.pngScreen-Shot-2021-10-07-at-10-38-34-AM.png
Screen-Shot-2021-10-07-at-10-40-18-AM.png
Screen-Shot-2021-10-07-at-10-42-54-AM.pngScreen-Shot-2021-10-07-at-10-43-24-AM.pngScreen-Shot-2021-10-07-at-10-45-02-AM.pngScreen-Shot-2021-10-07-at-10-45-33-AM.pngScreen-Shot-2021-10-07-at-10-46-01-AM.pngScreen-Shot-2021-10-07-at-10-46-27-AM.pngScreen-Shot-2021-10-07-at-10-46-54-AM.pngScreen-Shot-2021-10-07-at-10-48-35-AM.pngScreen-Shot-2021-10-07-at-10-49-47-AM.pngScreen-Shot-2021-10-07-at-10-50-08-AM.png
Screen-Shot-2021-10-07-at-10-50-35-AM.png\Screen-Shot-2021-10-07-at-10-52-04-AM.pngScreen-Shot-2021-10-07-at-10-52-31-AM.pngScreen-Shot-2021-10-07-at-10-53-05-AM.png

Tags

Über Wenjie Tehan

Wenjie is a Technical Consulting Manager, currently working with the Teradata Global Alliances team. 
 
With over 20 years in the IT industry, Wenjie has worked as developer, tester, business analyst, solution designer and project manager. This breadth of roles makes her perfect for the current role, understanding how the business needs data and how this data can be managed to meet those business needs.  
 
Wenjie has a BS in computer science from University of California at San Diego, and ME in computer engineering at Cornell University. Wenjie is also certified on both Teradata and AWS. Zeige alle Beiträge von Wenjie Tehan

Bleiben Sie auf dem Laufenden

Abonnieren Sie den Blog von Teradata, um wöchentliche Einblicke zu erhalten



Ich erkläre mich damit einverstanden, dass mir die Teradata Corporation als Anbieter dieser Website gelegentlich Marketingkommunikations-E-Mails mit Informationen über Produkte, Data Analytics und Einladungen zu Events und Webinaren zusendet. Ich nehme zur Kenntnis, dass ich mein Einverständnis jederzeit widerrufen kann, indem ich auf den Link zum Abbestellen klicke, der sich am Ende jeder von mir erhaltenen E-Mail befindet.

Der Schutz Ihrer Daten ist uns wichtig. Ihre persönlichen Daten werden im Einklang mit der globalen Teradata Datenschutzrichtlinie verarbeitet.