Importing Data from SAP

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.