Teradata Primary Use Case

SurjitChoudhury - PeerSpot reviewer
Data engineer at Cocos pt

The use cases vary based on the projects. In most projects, I worked with ETL tools like Informatica alongside Teradata. However, there was a specific project where we built a real-time data warehouse for active directory data using Teradata.

Oracle was the source system, with potential additional sources feeding into the Oracle database. We used Unix scripting to extract data from Oracle and leverage a colleague's expertise in Unix for the Teradata portion. 

We wrote ETL queries and performed data profiling before loading the data into the target data warehouse for further processing by other tools.

Our task was to create a data warehouse, an active data warehouse in Teradata.

View full review »
BS
Solution Architect at Capgemini

We use Teradata for our organization's data warehouse, where we store data from all enterprise sources. With Teradata's efficient processing, we generate business intelligence reports and support analytics initiatives. Our teams connect to Teradata for valuable insights, enabling data-driven decision-making across departments. The platform's analytics capabilities enhance our understanding of enterprise data for strategic planning and optimization.

View full review »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant

Teradata was mostly a control system for us where we were fetching the data from it on basic time intervals, on various DVs and various schema where we had to fetch the data. Reading was the main operation that we used Teradata for, but while reading, there were complex ENTs that we had to write because of a few data that was supposed to be transformed and then fetched, so that was the major use case for the solution.

View full review »
Buyer's Guide
Teradata
March 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
MartinPotgieter - PeerSpot reviewer
Services Manager at Bytes Systems Integration

We'd done a lot of replacements of sites. We've installed new systems with Unity support. We installed and deployed around about five systems for a bank in South Africa. When the old Teradata equipment became obsolete, we replaced them with new ones. 

I was involved with the whole thing from start to end. You can't just upgrade Teradata. You have to see if all of the other stuff is compatible with the new site. 

View full review »
AhmedAdel4 - PeerSpot reviewer
Product owner at Future Work

We use it as a staging database in our organization, serving as a repository for financial models.

View full review »
Asish Sahu - PeerSpot reviewer
SPM at Infosys

We use Teradata to build data warehouses for our customers.

View full review »
Rupal Sharma - PeerSpot reviewer
Data Architect at Three Ireland (Hutchison) - Infrastructure

Our use cases are all about data ingestion, data manipulation, and data exploration. It's the core database for us.

View full review »
MG
Vice President IT Architecture at a comms service provider with 1,001-5,000 employees

We use it primarily as a dedicated platform for aggregating structured data, essentially serving as our structured data repository or data warehouse.

View full review »
Al Krause - PeerSpot reviewer
Managing Director at advanced business horizons

Our use case is for data warehousing and BI reporting. We are customers of Teradata.

View full review »
JP
Data warehouse consultant at Profinit

We primarily use the solution as a relational database. We use it mainly for logistics. 

View full review »
Blaine VandeBerg - PeerSpot reviewer
Principal at Insight Data Consulting

Teradata is used for many use cases, such as clickstream, website support, and manufacturing control.

View full review »
AM
Data Engineer III at a media company with 1,001-5,000 employees

I am a Teradata administrator as well as a developer. I have about 700 users who are using our system, and we are maintaining the system in terms of tuning and in terms of all end-to-end items above the Teradata system.

We are using it as a data warehouse. In the data warehouse, we have got so many users who are doing their reporting and different types of analytics work using the solution.

View full review »
Rajdeep Biswas - PeerSpot reviewer
Technical Architect - Sr. Manager at Axtria - Ingenious Insights

My primary use of Teradata is for data warehousing.

View full review »
SD
Test Engineer at cigniti

We primarily use the solution for the EDW. 

View full review »
AY
Data Architect, Section Head at a energy/utilities company with 10,001+ employees

We primarily use the solution for data warehousing.

View full review »
HM
Big data administrator at a comms service provider with 1,001-5,000 employees

We use Teradata in our data warehouse and we extract data. We have a data department that uses many tools for data extractions.

View full review »
KA
Solution Sales and Lead Information at TechAccess Asia Distribution

My current use case is an analytical system for an oil and gas company. They have a data lake and they are getting their data from different IoTs and different SAP systems. They wanted to have some feedback about their system and check on their production.

The IoT center's data was actually our use case, then how we can use that data to prevent disaster from happening. Previously, this work was all done manually. If there is a leak in the pipes then it is a large area to search because there are hundreds of kilometers that have been run.

To tackle this problem, they use IoT sensor data. It helps them to understand how the flow is working at a specific point in time, what happens when they're drilling the oil and other types of data. To complete the analysis, we use an analytical system or a Teradata Azure system that we designed.

The ECL was designed in a manner where we were doing the transformation on Hadoop. It is more like a balanced system where you use Hadoop for what it is good for, and where you use Teradata for its purpose.

I have worked in several different environments. The largest Teradata implementation on Azure was done by me. Right now, I'm working with AWS but previously, I have implemented both on-premises and hybrid deployments.

View full review »
AO
Operations Lead at a retailer with 201-500 employees

We used the solution for our data warehouse. 

View full review »
NV
Business Intelligence Project Leader at NOUX C.A.

Primarily, Teradata is a traditional data warehouse, but we also encourage our customers to adapt to the logical data warehouse and data lab.

View full review »
it_user845499 - PeerSpot reviewer
Manager Performance Systems at Telstra

We use it for enterprise data warehouse (EDW) with on-premise hardware. The company uses EDW for most MIS functions.

View full review »
MR
Sr. Data Management Specialist at a computer software company with 1,001-5,000 employees

I mainly used Teradata as an EDW and for customizing and integrating CLDM, applying aggregation in the database, and analysis.

View full review »
it_user6057 - PeerSpot reviewer
Senior Java Developer at EPAM Systems at a tech vendor with 10,001+ employees
it_user710166 - PeerSpot reviewer
Operations Manager at a tech services company with 10,001+ employees

Its primary use is a superfast database.

View full review »
MP
Managing Director at a tech services company with 11-50 employees

Teradata is primarily for data warehousing at large customers, like banks, retailers, and government organizations. However, we don't use Teradata for Russian government organizations because it's a US tool, and the Russian government doesn't allow foreign software.

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

We use it as a data warehouse.

View full review »
Tejas Talele - PeerSpot reviewer
Software Engineer at a tech services company with 51-200 employees

The purpose that we are using Teradata for is to migrate data to the cloud.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

We are using this solution to check and validated our data.

View full review »
NV
Business Intelligence Project Leader at NOUX C.A.

We resell Teradata, but not in the cloud.

Currently, our experience with Teradata in the cloud is theoretical as we haven't started selling it to our customers yet; however, a few of our customers are interested in migrating to a cloud-based solution.

Our clients use Teradata to consolidate corporate data to provide reports. These reports are required every day — it's more like described analytics.

View full review »
GM
Teradata FSLDM Consultant at TIK IT Solutions

We implement Teradata in financial sectors, which include banks in India and Canada.

View full review »
RC
Associate Consultant at BT5 Business & Technology 5 Consulting

Our primary use case is for retail and customer behavior modeling. We handle a billion records from different sources to create a consolidated feed for KXEN analysis and customer behavior modeling.

View full review »
MH
Analytics Lead at a tech vendor with 10,001+ employees
MS
Senior Software Engineer at a tech services company with 201-500 employees

I am using Teradata Vantage Express and I'm using Teradata Studio along with it.

View full review »
it_user310206 - PeerSpot reviewer
Analyst at a tech services company with 10,001+ employees

As a contractor for various companies working in various industries, we usually find Teradata in financial organizations. It is often being used for relational data storage for huge data warehouses (usually built on Inmon principles) or as storage for building analytical data marts. Teradata is positioned as a high-performance solution for heavy analytical queries and, in fact, it is. Moreover, Teradata is typically supplied with the whole ecosystem of its tools (like Viewpoint), but I have not extensively used them.

View full review »
EB
Technical Manager at a energy/utilities company with 51-200 employees

We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata.

View full review »
it_user142503 - PeerSpot reviewer
SystemAnalyst

Business intelligence and data warehousing solutions for our client.

View full review »
it_user1210803 - PeerSpot reviewer
Senior Consultant at a tech services company with 51-200 employees

We are only consultants, so we don't use the program ourselves. 

View full review »
it_user1076391 - PeerSpot reviewer
Auditor Federal de Finanças e Controle at CGU

Our primary use case for this solution is the Transparency Portal of the Brazilian Government. Teradata provides the database infrastructure for this analytical site that is able to create an online BI experience that provides details on how the Brazilian government spends public money.

View full review »
it_user777930 - PeerSpot reviewer
Director at a tech services company with 11-50 employees

Building a single truth database (Enterprise Data Warehouse) where all the enterprise data is integrated at one place.

View full review »
Buyer's Guide
Teradata
March 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.