Data Acquisition Operation

Operation Name

Data Acquisition

Function Overview

Data extraction by specifying table name, Data acquisition by calling SAP query

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic Settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Required Settings
Item name Required / Optional Use of Variables Description Remarks
Type Required Not available Select SAP Query or SAP Table.
  • [QUERY]:(Default)
  • [TABLE]:
  • The operation that you select another one makes the following values initialization.

    • [CONFIG ID]
    • [CONFIG TEXT]
    • [Item List]
    • [Execution Parameters]
    • [Definition]
    • [Conditions]
CONFIG ID Required Not available Select a ID.
  • Choosing another ID makes the following values initialization.

    • [Variable Parameters / Value]
CONFIG TEXT
-
-
The description of [CONFIG ID] you specified is displayed.  
Item List Required
-
Output fields are displayed.  
Field Name(Technical Name) Required Not available Each field name is displayed.
  • Field name displayed in [Item List] is displayed in schema of Mapper.
Description(Text) Required Not available Each field description is displayed.  
Execution Parameters
QUERY
Item name Required / Optional Use of Variables Description Remarks
Conditions
-
-
The condition of data selection which you created in Configuration Tool is displayed.  
Fields
-
-
The name of selection field is displayed.  
Comparison
-
-
The way of comparison you specified is displayed.  
Range Type
-
-
The range type is displayed.  
Value1
-
-
The value of the condition of data selection which you specified in Configuration Tool is displayed.  
Value2
-
-
The value of the condition of data selection which you specified in Configuration Tool is displayed.  
TABLE
Item name Required / Optional Use of Variables Description Remarks
Conditions
-
-
The condition of data selection which you created in Configuration Tool is displayed.  
Commons
Item name Required / Optional Use of Variables Description Remarks
Uppercase/Lowercase
-
-
In case of "OFF", the condition parameters in alphanumeric character you specified are converted into the uppercase.  
Variable Parameters Optional
-
You can specify dynamic values for conditions.  
Variable Name
-
-
The name you specified is displayed.  
Value Optional Available You can set a dynamic parameter.  
Definition
QUERY
Item name Required / Optional Use of Variables Description Remarks
Work Areas
-
-
The specified work area is displayed.  
User Group
-
-
The specified user group is displayed.  
SAP Query
-
-
The specified query is displayed.  
Variant
-
-
The specified variant is displayed.  
Conversion Type
-
-
The specified type is displayed.  
TABLE
Item name Required / Optional Use of Variables Description Remarks
Table
-
-
The specified table is displayed.  
Blank Space Cut
-
-
The selected value is displayed.  
Commons
Item name Required / Optional Use of Variables Description Remarks
Login ID
-
-
The specified id is displayed.  
Header
-
-
The status that you selected with or without the header record for the extraction results is displayed.  
Comment
Item name Required / Optional Use of Variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.
 

Schema

Input Schema

None.

Output Schema

Depending on the [Item List] setting, the number of columns may be different.
See "Schema of Table Model" for information about output schema.

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema" for any details.

Mass data processing

Mass data processing is not supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name Description Remarks
count The number of retrieving the data from SAP system.
  • The value defaults to null.
  • If error occurs, 0 is returned.
loginId Login ID in Configuration Tool
  • The value defaults to null.
tableName table name
  • The value defaults to null.
  • if [Type] is [QUERY], an empty string is returned.
userGroup user group
  • The value defaults to null.
  • if [Type] is [TABLE], an empty string is returned.
queryName SAP query name
  • The value defaults to null.
  • if [Type] is [TABLE], an empty string is returned.
variant variant
  • The value defaults to null.
  • if [Type] is [TABLE], an empty string is returned.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Returns the error type when error occurred.
java.io.FileNotFoundException format.
  • The value defaults to null.
  • If no error occurred, returns null.
  • The contents may change depending on version.
error_message Returns the error message when error occurred.
  • The value defaults to null.
  • The contents may change depending on version.
error_trace Returns trace information when error occurred.
  • The value defaults to null.
  • The contents may change depending on version.

About Configuration Tool

About this tool, refer to the user's guide of Configuration Tool of SAP TableQuery Adapter.

Specification Limits

Main Exceptions

Exception name Causes Solution
InvalidConfigIdException
No CONFIG ID found.
CONFIG ID:<CONFIG ID>
The tool failed to get [CONFIG ID] with specified ID. Please check out the [CONFIG ID].
InvalidConfigIdException
Invalid CONFIG ID found.
CONFIG ID:<CONFIG ID>
The [CONFIG ID] is invalid.

  • in case of [QUERY] in [Type]
    Check permissions on the following directories.

    • Windows
      $DATASPIDER_HOME\SAPTableQueryAdapter\config\query
    • UNIX/Linux
      $DATASPIDER_HOME/SAPTableQueryAdapter/config/query

  • in case of [TABLE] in [Type]
    Check permissions on the following directories.

    • Windows
      $DATASPIDER_HOME\SAPTableQueryAdapter\config\table
    • UNIX/Linux
      $DATASPIDER_HOME/SAPTableQueryAdapter/config/table
ExecuteCommandFailedException
Process canceled. Code:<value>
This adapter failed to connect to SAP system.
This adapter found invalid parameters in [Execution Parameters], and so on.
Check execute logs in My log of DataSpider Studio.

Notes