My Oracle Support Banner

Improving Performance of the Siebel Marketing Server when using Teradata (Doc ID 473790.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel Campaigns - Version 7.0.4 [14068] and later
Siebel Marketing - Version 7.0.4 [14068] and later
Information in this document applies to any platform.
Release(s):V7 (Enterprise)
Database(s):Teradata
App Server OS(s):All Supported Platforms
Latest release tested against:V7 (Enterprise)
Keywords:marketing server, performance, NCR teradata, ODBC, array insert, cache, caching, saved results, DDL

This document was previously published as Siebel Technical Note 618.


Purpose

This Technical Note describes how to improve performance of the Siebel Marketing Server when using the Teradata database or its ODBC driver.
 
Sample DDL for creating Marketing cache tables and saved result set tables is provided that improves array inserts into the Teradata database and its ODBC driver.
 
This document also outlines the steps required to enable caching for a Target Level along with recommendations on parameter settings that optimize array inserts into the Teradata database and its ODBC driver. To implement these recommendations you must be on Siebel Business Analytics version 7.8.2.1 or higher (Oracle Business Intelligence Enterprise Edition, OBIEE).
 
This document also describes the proper settings to ensure that the Siebel Analytics (OBIEE) Server pushes sorts to the back-end Teradata database. This results in increased performance.
 
For information on supported versions of Teradata refer to Siebel System Requirements and Supported Platforms for Siebel Analytics Platform, version 7.8.2 (or higher, OBIEE) > Platform Requirements for Siebel Analytics > Supported Data Sources > Supported Databases > Siebel Business Analytics Platform, available on SupportWeb. The recommended version of the NCR Teradata ODBC is 3.3.0.5, and is the required version when connecting to a Teradata database on the HP-UX operating system. Teradata ODBC 3.4 or higher is not supported on any platform.
 
Bug  5535754 has been logged as a documentation enhancement request to list supported versions of the NCR Teradata ODBC driver.
(this was added to newer versions of this Guide)

Scope

This document is informational and intended for any user.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Sample DDL for creation of Marketing Cache tables and Saved Result Set tables for Teradata
 Enabling Caching for a Target Level
 Enabling Marketing Server to use Temp Table Caching
 Setting Siebel Analytics Server to Push Sorts to Back-end Teradata Database
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.