Applications covers the world of Teradata apps, including apps offered by Teradata (such as TRM or DCM), as well as best practices and methodologies for building your own Teradata-connected apps.

Expand All Subscribe to Teradata Developer Exchange - Applications content The Latest
OBIEE Configuration for Teradata Temporal Tables

 

This article shows how to integrate OBIEE with Teradata Temporal Tables.  It details how to set up OBIEE for "as-is" and "as-was" type analysis.  It is a cook book style write-up and assumes the reader knows OBIEE (Oracle Business Intelligence Enterprise Edition) and assumes that the reader knows what they want to do with temporal.  It does not go into detailed analysis of different use cases for temporal tables.

Oracle BI Enterprise Edition (OBIEE) Integration with Teradata Aster SQL/MR

Beyond the typical database functions Aster has advanced analytical functionality.  For instance, the Aster nPath function allows regular pattern matching over a sequence of rows. With it, you can find sequences of rows that match a pattern you’ve specified and easily extract information from these matched patterns using symbols that represent the matched rows in the pattern.

Oracle Essbase XOLAP and Teradata

Oracle Essbase was first launched in 1992. Since then, many other OLAP tools have come and gone. Oracle Essbase has thrived and become a leading OLAP tool by continuously adding new features, adapting to new environments, and taking advantage of new technologies. Oracle Essbase XOLAP and Oracle Essbase Studio are examples of the latest improvements.

Using OBIEE Visual Analyzer with Teradata Database

OBIEE VISUAL ANALYZER

 

Background

Visual Analyzer (VA) is a web-based tool that allows the business user to explore data visually. Creating visualizations is so easy in Visual Analyzer that the data analysis work becomes more an individual experience in exploration and discovery rather than an extended process of constructing views from data.

Using the OBIEE Sample Application with the Teradata Database

The OBIEE Sample Application is a fully functioning OBIEE environment available on a VM.  It is self-contained in that demo applications can be run against data stored on the VM.  It is possible to modify the VM so that external data can also be accessed and shown in a demo or used for testing.  This article shows how to modify the VM to access a Teradata database.  Almost any Teradata database version will work with OBIEE, but see the certification matrix for supported versions.

Teradata Profiler Plug-in for Eclipse - Express Edition

The Teradata Profiler Plug-in for Eclipse is based on the Eclipse plug-in framework and the Teradata Plug-in for Eclipse Data Source Explorer (DSE). Teradata Profiler Plug-in for Eclipse enables the user to Profile Teradata and Aster tables/columns via the DSE as well as create projects containing analyses. The descriptive statistics available with the Teradata Profiler Plug-in provide a variety of functions to statistically analyze and explore data tables in a Teradata or Aster database. This is a complete version of the Teradata Profiler for Eclipse, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data. (Note that the validation of the 40 GB limit for the Express Edition requires SELECT access to the dbc.allspace view in Teradata or EXECUTE permission on the nc_relationstats SQL-MR function in Aster for the user.)

Teradata Warehouse Miner - Express Edition

The latest software available for download here is Teradata Warehouse Miner 05.04.01 Express Edition. This is a complete version of the Teradata Warehouse Miner product set, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data. (Note that the validation of the 40 GB limit for the Express Edition requires SELECT access to the dbc.allspace view in Teradata or EXECUTE permission on the nc_relationstats SQL-MR function in Aster for the user.)

Oracle BI Enterprise Edition (OBIEE) 11g Basic Configuration and Integration with Teradata Aster

The Teradata Aster Discovery Platform is engineered for all new and old data types, offering integrated analytics and revolutionary ways of analyzing data. It’s the industry’s most transformative solution for turning big data insights into outstanding customer experiences, advancements in customer service and record-breaking marketing campaigns. Teradata Aster Discovery Portfolio provides a suite of ready-to-use functions applied from a familiar SQL interface for fast and easy discovery of business insights from big data.

Oracle BI Enterprise Edition (OBIEE) Configuration and Integration with Teradata QueryGrid

Teradata QueryGrid provides a means to access Hortonworks Hadoop® data from a Teradata system.  The QueryGrid uses SQL to access and join other system’s data with the enterprise data.  QueryGrid is flexible in that Hadoop, Aster or other databases can be accessed from the integrated data warehouse.

Calibrated Marketing: The Art of the Possible in Integrated Marketing

Integrated marketing offers an omni-channel view of your customers and opens the possibilities of new kinds of data-driven marketing.

Pages