Hello all, looking for some knowledge help
In a previous life when pulling data from a MSSQL DB into SAP on an Oracle platform, we had to purchase an Oracle SQL Gateway.
Was wondering now if ECC6 and DBCO were functional and not have to use/purchase this software.
As an example this is what I would like to do (or what I used to do with the Oracle SQL Gateway
EXEC SQL PERFORMING F210_APPEND.
SELECT
"ProdOrderNo",
"OrderOperation",
"BTCHLINE",
TO_CHAR("DateTime",'YYYYMMDD HH24MISS'),
"ALT_FORM",
"BTCH_TOT",
"DEST_BIN",
"SERIAL_NUM",
"Units",
"ING_CODE",
"VendorLotNo",
"ACT_WGT",
"STEP_DESC",
"SAPProcessed",
"TargetBchWgt",
"StorageLocation"
INTO :T_BATCH
FROM "Batching"@tp_sql
WHERE "SAPProcessed" is null
AND "ProdOrderNo" <> 'NONE'
ENDEXEC.
Hopefully now by maintaining DBCON it should look something like this?
exec sql.
set connection : 'tp_sql'
endexec.
if sy-subrc 0.
exec sql.
connect to :'tp_sql'
endexec.
EXEC SQL PERFORMING F210_APPEND.
SELECT
"ProdOrderNo",
"OrderOperation",
"BTCHLINE",
TO_CHAR("DateTime",'YYYYMMDD HH24MISS'),
"ALT_FORM",
"BTCH_TOT",
"DEST_BIN",
"SERIAL_NUM",
"Units",
"ING_CODE",
"VendorLotNo",
"ACT_WGT",
"STEP_DESC",
"SAPProcessed",
"TargetBchWgt",
"StorageLocation"
INTO :T_BATCH
FROM "Batching"@tp_sql
WHERE "SAPProcessed" is null
AND "ProdOrderNo" <> 'NONE'
ENDEXEC.
EXEC SQL.
ALTER SESSION CLOSE DATABASE LINK TP_SQL
ENDEXEC.
Does this sound about right? Really hoping not to have to purchase the SQL Gateway again.... I think I had read somewhere about dll's needing to be loaded in order to connect from Oracle to MSSQL?
Any advice is greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.