Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 21, 2016 at 02:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 09:09 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.