HOW TO IMPORT DATA FROM SAP ORACLE TO MS SQL SERVER 2016

[Former Member]

Dear Gurus,

please, I need your help.

I am trying find out, how to easy connect and import (download) data from our SAP oracle database to MS SQL SERVER installed on my computer at work.

I need to make a queries but I don't want use a BI.

Is there any option, how to import data from tables in SAP to MS SQL SERVER?

For example, I need to import data from FI (account moves) in amout of milions of raws in table BKPF. Export to excel is not available.

I want to direct import data from table BKPF from SAP to my database in MS SQL SERVER.

How can I do this?

Many thanks for your help

Kind regards

Marek

[Reagan]

DBCON is possible only if the MSSQL is running with an SAP instance. If there is no SAP instance on top of the MSSQL database then it will not help you. In that case you might need to use some MSSQL specific functionality by creating a Linked Server to the Oracle database.

[JamesZ]

Hi Marek,

you can try to set up dbco connection from sql server side. Sql server side needs to install oracle client. Details please refer to SAP note 808505 .

Then you can try to write your own abap to do this.

Best regards,
James