Skip to Content
0
Former Member
Nov 10, 2010 at 07:23 PM

SAP on Oracle to pull Shop Floor Data from MSSQL Server

31 Views

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.