I would like to get the data from SAP HANA database. I only have SAP HANA ODBC 64bit, do not have it for 32bit. So I think I should get the data from datamapper.
I selected a table “MACH1.Extensions_Custom.CJL.COMMON/AT_BKPF” on table field and clicked Custom Query button, as a result I meet error “Cannot connect to database with the specified options”. I could not recognize reason of error.
After that, SQL Query Designer window is opened, and I inputted sql below, then the error box appeared.
Does anyone have solution?
<!-SQL!>
SELECT BKPF.BELNR,
BKPF.BKTXT,
BSAK.ZUONR,
BSAK.XBLNR,
BSAK.AUGBL,
BSAK.AUGDT,
BSAK.BLDAT,
BSAK.BUDAT,
BSAK.ZFBDT,
BSAK.XREF3,
BSAK.WAERS,
BSAK.SHKZG,
BSAK.WRBTR FROM “_SYS_BIC”.“MACH1.Extensions_Custom.CJL.COMMON/AT_BKPF” BKPF,
“_SYS_BIC”.“MACH1.Extensions_Custom.CJL.COMMON/AT_BSAK” BSAK
WHERE BKPF.BELNR = BSAK.BELNR
AND SUBSTR(BKPF.BKTXT, 1, 6) = ‘APAK02’
AND BSAK.AUGDT IS NOT NULL
Can you please share a screenshot of the SQL Query Designer window? The reason why I am asking is because I assume that some characters got lost regarding the shared SQL query after your forum post was posted.
@Marten
Hi Marten,
Thank you for your reply.
Let me ask you before SQL Query Designer window.
First of all, I tried to create new datamapping by using data mapping wizards. Authouth I could connect server correctry on ODBC Configuration window. However, when I tried setup by using data mapping wizards, I met error box. Do you know how should I setup?
