GETSAPDATA command

After a parallel download of SAP data to a set of Analytics tables, imports the tables to an Analytics project.

Note

The GETSAPDATA command must be preceded by one or more ACCESSDATA . . . SAP commands with the ASYNC parameter. For more information, see Importing multiple SAP tables in parallel.

Syntax

GETSAPDATA

Parameters

This command does not have any parameters.

Examples

Downloading and importing multiple SAP tables in parallel using the SAP connector

You need to download and import data from three SAP tables as the basis for subsequent analysis:

T001
T002
T003

The most efficient approach is to download the tables in parallel. You assemble a block of ACCESSDATA commands, one command for each table. Each command uses the ASYNC parameter to specify that the three download operations occur in parallel (that is, asynchronously).

Immediately following the block of ACCESSDATA commands, you use the GETSAPDATA command to import the downloaded tables to the Analytics project.

COMMENT Download three SAP tables in parallel

ACCESSDATA64 CONNECTOR NAME "SAP" USER "irosario" PASSWORD 1 TO "T001.FIL" CHARMAX 50 MEMOMAX 100 ASYNC SOURCE(server=192.0.2.255;client=800;language=EN;instancenumber=01;variablestringlength=256;TemporaryWorkingDirectory=Default)
  SQL_QUERY(
    SELECT * FROM T001
  ) END_QUERY

ACCESSDATA64 CONNECTOR NAME "SAP" USER "irosario" PASSWORD 1 TO "T002.FIL" CHARMAX 50 MEMOMAX 100 ASYNC SOURCE(server=192.0.2.255;client=800;language=EN;instancenumber=01;variablestringlength=256;TemporaryWorkingDirectory=Default)
  SQL_QUERY(
    SELECT * FROM T002
  ) END_QUERY

ACCESSDATA64 CONNECTOR NAME "SAP" USER "irosario" PASSWORD 1 TO "T003.FIL" CHARMAX 50 MEMOMAX 100 ASYNC SOURCE(server=192.0.2.255;client=800;language=EN;instancenumber=01;variablestringlength=256;TemporaryWorkingDirectory=Default)
  SQL_QUERY(
    SELECT * FROM T003
  ) END_QUERY

COMMENT Import the three downloaded tables to the Analytics project

GETSAPDATA