MicroStrategy ONE

Data Retrieval Parameters

The Data Retrieval Mode VLDB property defines the parameters used to retrieve data using third-party, native APIs.

For this VLDB property to take effect, you must defined the Data Retrieval Mode VLDB property (see Data Retrieval Parameters) as Allow Native API. You can then define the required parameters to retrieve data using the third-party, native API. For example, you can enable Teradata Parallel Transporter by defining the following parameters:

  • TD_TDP_ID: The name or IP ad
  • dress 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 TD_MAX_SESSIONS value, as a thread can include one or more sessions.
  • You can include any additional parameters to apply to the connection. Provide each parameter with the syntax: ParameterName=ParameterValue.

When providing the parameters and their values, each parameter must be of the form:

ParameterName=ParameterValue

Separate each parameter definition with a semicolon (;). An example of the full definition of this VLDB property is provided below:

TD_TDP_ID=123.45.67.89;TD_MAX_SESSIONS=3;TD_MIN_SESSIONS=1;TD_MAX_INSTANCES=3

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

You can also define this VLDB property 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