Data Retrieval Mode

The Data Retrieval Mode VLDB property determines whether data is retrieved using third-party, native APIs. You have the following options:

• Only ODBC: Standard methods are used to retrieve data. This option must be used in all cases, except for connections that are expected to make use of the Teradata Parallel Transporter API.
• Allow Native API: Third-party native APIs can be used to retrieve data. MicroStrategy supports the use of the Teradata Parallel Transporter API. Enabling Teradata Parallel Transporter can improve performance when retrieving large amounts of data from Teradata, typically 1 Gigabyte and larger, which can occur most commonly in MicroStrategy when publishing Intelligent Cubes.

  Using MicroStrategy Web, you can create a connection to Teradata and import your data. When creating this connection, enabling the Teradata Parallel Transporter options automatically defines this VLDB property as Allow Native API for the connection. For steps to create this type of connection in MicroStrategy Web, see the Web User Help.

  You can also select this VLDB property option for the database instance for Teradata connections that are not created through the use of Data Import.

Levels at Which You Can Set This

Database instance and report