Managing data source connections » Enabling Teradata Parallel Transporter to retrieve large amounts of data

Enabling Teradata Parallel Transporter to retrieve large amounts of data

When integrating large amounts of data from your Teradata database into MicroStrategy, you can take advantage of Teradata's Parallel Transporter functionality. Enabling Teradata Parallel Transporter can improve performance when retrieving large amounts of data, typically 0.5 Gigabytes and larger, which can occur most commonly in MicroStrategy when publishing Intelligent Cubes.

By default, ODBC is used to retrieve all data rather than the Teradata Parallel Transporter, which is the best method to support bringing back small to moderate amounts of data and allowing for advanced SQL queries.

Prerequisites

A direct (DSNLess) database connection to your Teradata database is available.
You must ensure that the Teradata Tools and Utilities 15.0.x package is installed on the MicroStrategy Intelligence Server machine. These resources are available through Teradata.
You must have the "Create and Edit Database Instances and Connections" and "Create and Edit Database Logins" privileges to modify a database connection.

To enable Teradata Parallel Transporter

1 On any page, click Create on the icon bar on the left, and then select Access External Data. Click Database. The Select Import Options dialog box opens.
2 Select one of the following:
To select single or multiple tables to import data from, select Pick Tables.
To use a graphical interface to build the SQL query to use to import your data, select Build a Query.
To manually type or paste a query to import your data, select Type a Query.
3 Hover the cursor over the name of the database connection for your Teradata database, then click the arrow icon. A pop-up menu is displayed. Click Edit. The Data Source dialog box opens.
4 Select the Use Teradata Parallel Transporter check box. You must also provide the following information:
TD TDP ID: The name or IP address of the machine on which the Teradata data source resides.
TD Max Sessions: The maximum number of sessions that can be used to log on to the Teradata database when processing queries in parallel. By default, one session per Access Process Module (AMP) is used, which is also the maximum number of sessions that can be supported. Type a value to allow fewer sessions than the number of available AMPs.
TD Min Sessions: The minimum number of sessions required for the export driver job to complete its processes. The default is one session. This value must be less than or equal to the TD Max Sessions value.
TD Max Instances: The maximum number of threads that can be used. This option can be defined if the driver has been configured as a master and slave environment that allows for multiple threads. This value must be less than or equal to the TPT Max Sessions value, as a thread can include one or more sessions.
Other parameters: Additional Teradata parameters to apply to the connection. Provide parameters with the syntax shown below:

Parameter1=Value1;Parameter2=Value2;Parameter3=Value3;

To provide multiple parameters, separate each parameter and value definition with a semicolon (;).

5 Click OK to save your changes.

Related topics

Editing, deleting, renaming, or duplicating a database connection
Creating DSNLess database connections that support third-party drivers