Importing Data from SAP: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 47: Line 47:


In addition to the RFC interface, data can be fetched from SAP HANA with ODBC using the [[DataFrame_in_Expression_Language#ImportOdbcSecure|ImportODBCSecure]] function and [[QPR_ProcessAnalyzer_Scripting_Commands#--.23ImportOdbcQuery|ImportOdbcQuery]].
In addition to the RFC interface, data can be fetched from SAP HANA with ODBC using the [[DataFrame_in_Expression_Language#ImportOdbcSecure|ImportODBCSecure]] function and [[QPR_ProcessAnalyzer_Scripting_Commands#--.23ImportOdbcQuery|ImportOdbcQuery]].
[[Category: QPR ProcessAnalyzer]]

Revision as of 19:51, 9 December 2020

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.
  • In the C datatype, spaces from both side are trimmed away.
  • If T type of column appears directly after the the D type of column, the time part in the T column is taken into account in the D column, and no new column in the result is created for the the T column. This occurs only if both D and T types are among the converted types.

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.