|Headquarters||San Diego, California|
Victor L. Lund, President and CEO|
Kenneth Simonds, Former Chief Executive
|Products||Integrated Data Warehouse Hardware and Software, Unified Data Architecture, Big Data Analytics, Professional Services, Customer Services|
|Revenue||US$2.3 billion (2016)|
|$125 million (2016)|
|$112 million (2016)/>|
Number of employees
Teradata Corporation is a provider of database and analytics-related products and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers at Caltech and Citibank's advanced technology group. The company was acquired by NCR Corporation in 1991, and subsequently spun-off again as an independent public company on October 1, 2007.
Teradata is an enterprise software company that develops and sells database analytics software. The company provides three main services: business analytics, cloud products, and consulting. It operates in North and Latin America, Europe, the Middle East, Africa and Asia.
Teradata is headquartered in San Diego, California, and has additional major U.S. locations in Atlanta and San Francisco, where its data center research and development is housed. It is publicly traded on the New York Stock Exchange (NYSE) under the stock symbol TDC. Victor Lund has served as the company's president and chief executive officer since 2016. The company reported $2.3 billion in revenue, with a net income of $112 million, and 10,093 employees globally, as of December 31, 2016.
|Acquisitions and divestitures, 1979-2017.|
The concept of Teradata grew from research at California Institute of Technology and from the discussions of Citibank's advanced technology group in the 1970s. In 1979, the company was incorporated in Brentwood, California by Jack E. Shemer, Philip M. Neches, Walter E. Muir, Jerold R. Modes, William P. Worth, Carroll Reed and David Hartke. Teradata released its DBC/1012 specialized database computer in 1984. In 1990, the company acquired Sharebase, originally named Britton Lee. In September 1991, AT&T Corporation acquired NCR Corporation, which announced the acquisition of Teradata for about $250 million in December. Teradata built the first system, over 1 terabyte, for Wal-Mart in 1992.
NCR acquired Strategic Technologies & Systems in 1999, and appointed Stephen Brobst as chief technology officer of Teradata Solutions Group. In 2000, NCR acquired Ceres Integrated Solutions and its customer relationship management software for $90 million, as well as Stirling Douglas Group and its demand chain management software. Teradata acquired financial management software from DecisionPoint in 2005. In January 2007, NCR announced Teradata would become an independent public company, led by Michael F. Koehler. The new company's shares started trading in October.
Teradata has acquired several companies since becoming an independent public company in 2008. In March 2008, Teradata acquired professional services company Claraview, which previously had spun out software provider Clarabridge. Teradata acquired column-oriented DBMS vendor Kickfire in August 2010, followed by the marketing software company Aprimo for about $550 million in December. In March 2011, the company acquired Aster Data Systems for about $263 million. Teradata acquired email direct marketing company eCircle in May 2012, which was merged into the Aprimo business.
In 2014, Teradata acquired the assets of Revelytix, a provider of information management products and for a reported $50 million. In September, Teradata acquired Hadoop service firm Think Big Analytics. In December, Teradata acquired RainStor, a company specializing in online data archiving on Hadoop. Teradata acquired Appoxxee, a mobile marketing software as a service provider, for about $20 million in January 2015, followed by the Netherlands-based digital marketing company FLXone in September.
In July 2016, the marketing applications division, using the Aprimo brand, was sold to private equity firm Marlin Equity Partners for about $90 million. Aprimo moved its headquarters to Chicago and is now led by CEO John Stammen. Marlin immediately bought Revenew Inc., which offers through-channel marketing automation software, and merged it into the Aprimo business. In March 2017, Aprimo bought Belgium-based ADAM Software, which offered Digital Asset Management solutions . Teradata acquired Big Data Partnership, a service company based in the UK, on July 21, 2016. In July 2017, Teradata acquired StackIQ, maker of the Stacki software.
Teradata offers three main services to its customers: cloud and hardware-based data warehousing, business analytics, and consulting services. In September 2016, the company launched Teradata Everywhere, which allows users to submit queries against public and private databases. The service uses massively parallel processing across both its physical data warehouse and cloud storage, including managed environments such as Amazon Web Services, Microsoft Azure, VMware, and Teradata's Managed Cloud and IntelliFlex. Teradata offers customers both hybrid cloud and multi-cloud storage. In March 2017, Teradata introduced Teradata IntelliCloud, a secure managed cloud for data and analytic software as a service. IntelliCloud is compatible with Teradata's data warehouse platform, IntelliFlex. The Teradata Analytics Platform was unveiled in 2017.
Teradata Geospatial is a collection of geospatial analysis components which are integrated into the Teradata Database. Teradata geospatial allows storage and spatial analysis on location-based data which is stored using native geospatial data-types within the Teradata database.  The Teradata database implements the SQL/MM standard for geospatial implementation within a RDBMS.  The geospatial capabilities allow for business intelligence with an added new dimenstion of geospatial location based on longitude/latitude coordinates.
Teradata Parallel Transporter (TPT) is a data loading utility sold by Teradata, typically used in data warehousing. It combines the functionality of Teradata FastLoad, MultiLoad, FastExport, and TPump.
TPT is a parallel load environment, which provides access to data sources from a single interface using a single SQL-like scripting language and from a published application programming interface (API). Multiple files can be loaded using a single script. The utility allows load balancing of the workload across multiple CPUs, which is designed to reduce bottlenecks in the data loading process.
Each user can create a job (that is, a string of TPT commands) that allows them to perform operations, such as heterogeneous data access, data integrity checks, data merging, and data loads in batch or interactive.
It was designed to use the different Teradata data loading and unloading utilities under a single infrastructure. Based on the protocols of fastload, multiload, tpump and fastexport, new "operators" were developed called Load, Update, Stream and Export respectively. Other operators include Selector, Inserter, Dataconnector, and ODBC.
Executing the script:
tbuild -f TPT_Scriptname.tpt
Whenever we execute TPT there is a .out file created which is like a log file for TPT. You cannot read contents of .out file by cat or more or any other UNIX command if running on UNIX or in Notepad or any other Text Editor. To view the file use below command:
tlogview -l TPT_Script.out
Teradata Warehouse Miner (TWM) is a software application provided by Teradata for achieving data mining inside RDBMS databases without the need for migrating the data from the data warehouse. TWM is bundled with multiple statistical and machine learning algorithms for analyzing data and creating data mining models. The whole data mining process, e.g. CRISP-DM process, is supported using TWM which includes: descriptive statists and analysis, analytic data set creation, data mining model creation and data mining model scoring. This facilitates Knowledge Discovery in Databases (KDD) which provides business intelligence for organisations.
Teradata began to market with the term "big data" in 2010. CTO Stephen Brobst attributed the rise of big data to "new media sources, such as social media." The increase in semi-structured and unstructured data gathered from online interactions prompted Teradata to form the "Petabyte club" in 2011 for its heaviest big data users.
The rise of big data resulted in many traditional data warehousing companies updating their products and technology. For Teradata, big data prompted the acquisition of Aster Data Systems in 2011 for the company's MapReduce capabilities and ability to store and analyze semi-structured data.
Media related to Teradata at Wikimedia Commons
Manage research, learning and skills at NCR Works. Create an account using LinkedIn to manage and organize your omni-channel knowledge. NCR Works is like a shopping cart for information -- helping you to save, discuss and share.