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. Data is converted into in-memory core and SQL Server datatypes 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)

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