Teradata Primary Use Case
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
Biplab Sahoo
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.
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.
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.
We use it as a staging database in our organization, serving as a repository for financial models.
View full review »We use Teradata to build data warehouses for our customers.
View full review »Our use cases are all about data ingestion, data manipulation, and data exploration. It's the core database for us.
View full review »MG
reviewer1306140
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 »Our use case is for data warehousing and BI reporting. We are customers of Teradata.
JP
JiriPelikan
Data warehouse consultant at Profinit
We primarily use the solution as a relational database. We use it mainly for logistics.
View full review »Teradata is used for many use cases, such as clickstream, website support, and manufacturing control.
View full review »AM
reviewer2036109
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 »My primary use of Teradata is for data warehousing.
View full review »SD
Sailaja D
Test Engineer at cigniti
We primarily use the solution for the EDW.
View full review »AY
reviewer1452633
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
HakimMoussaoui
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
Khurram Afzaal
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
reviewer1984485
Operations Lead at a retailer with 201-500 employees
We used the solution for our data warehouse.
View full review »NV
Nelson Vargas
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 »We use it for enterprise data warehouse (EDW) with on-premise hardware. The company uses EDW for most MIS functions.
View full review »MR
reviewer1953972
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 »Its primary use is a superfast database.
View full review »MP
reviewer1155168
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
reviewer1601793
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 »The purpose that we are using Teradata for is to migrate data to the cloud.
View full review »KG
reviewer1488372
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
Nelson Vargas
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
Gouri Mishra
Teradata FSLDM Consultant at TIK IT Solutions
We implement Teradata in financial sectors, which include banks in India and Canada.
View full review »RC
Rodrigo Cifuentes
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
reviewer1031826
Analytics Lead at a tech vendor with 10,001+ employees
MS
reviewer2088057
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 »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
TechMgr3486
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 »Business intelligence and data warehousing solutions for our client.
View full review »We are only consultants, so we don't use the program ourselves.
View full review »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 »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.