Importing Data from SAP

From QPR ProcessAnalyzer Wiki
Revision as of 19:55, 9 December 2020 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

Data can be imported from SAP based on the RFC interface using --#ImportSapQuery command in SQL scripting and ReadSap function in the expression language. Data fetched from SAP contains datatype information, and data is converted into respective datatypes of the in-memory core and SQL Server as follows:

SAP data type Expression language:
ReadSap
SQL scripting:
--#ImportSapQuery
I long INT
F double FLOAT
P double FLOAT
C string NVARCHAR(length) or
NVARCHAR(max) (if length is greater than 8000)
D datetime DATETIME2
N string NVARCHAR(length) or
NVARCHAR(max) (if length is greater than 8000)
T timespan TIME
X byte[] VARBINARY(length) or
VARBINARY(max) (if length is greater than 8000)

Notes:

  • If no conversion is defined, data is converted to strings. By default --#ImportSapQuery (in SQL scripting) does not make any conversions, and by default ReadSap (in expression language) makes all conversion.
  • If T type of column (time) appears directly after the the D type of column (date), the time part in the T column is added to the D column data, and no new column in the result is created for the the T column. This is done only if both D and T types are among the converted types.
  • In the C datatype, spaces from both side are trimmed away.

More information about SAP data types: https://help.sap.com/saphelp_nwpi71/helpdata/en/fc/eb2fd9358411d1829f0000e829fbfe/content.htm?no_cache=true.

In addition to the RFC interface, data can be fetched from SAP HANA with ODBC using the ImportODBCSecure function and ImportOdbcQuery.