Skip to Content
avatar image
Former Member

Oracle to MaxDb ( import / synchronize )

Hello,

I have downloaded MaxDb version 7.7.06.09 32bit and i have installed it on a Windows XP Professional machine.

Also i have installed Database Studio 7.7.06.09 for Windows 32 bit.

I need to import some tables from an existing SAP R/3 Enterprise 4.7 installation that uses Oracle 9.2.0.4.0 in to MaxDb.

In the future if everything works ok i intend to synchronize the tables from Oracle with those from MaxDb but only in one way, changes to Oracle tables will be transported to MaxDb.

So my questions are :

1. can i import some tables (let's say VBRP and VBRK) from Oracle to MaxDb ?

2. can i synchronize the tables as i described ?

3. what tools should i use ?

Edited by: Cristian Radu on Jul 3, 2009 9:44 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 03, 2009 at 08:25 AM

    Hi Lars,

    thank you very much for your answer

    I have read your blog post "Suck that data out ! Connect from Oracle to MaxDB" and i've seen that it describes how to move data from MaxDB to Oracle Database. That's good to know, but i need to move data from Oracle to MaxDB.

    You said something about trying a synchronization using ABAP. Please give me more information if you think this is the best solution. I haven't done till now an ABAP program that connects to MaxDb but i have written some reports in ABAP. Can you provide some links that will give me a start.

    Also i have seen that "Database Studio" has an import feature. Can i use that somehow in order to import data from Oracle ?

    Thank you.

    PS The company that i am working for HAS licences for Oracle and Sap.

    Edited by: Cristian Radu on Jul 3, 2009 10:26 AM

    Edited by: Cristian Radu on Jul 3, 2009 10:26 AM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      Hello,

      To migrate data from the Oracle database to MaxDB, I would definitely go with an ETL tool. There are open source tools that you can download for free. Talend is one of them: it has connectors for both Oracle and MaxDB. Which means you can migrate easily and efficiently.

      About Talend Open Studio, it is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

      Check: http://www.talend.com/

  • Jul 03, 2009 at 07:50 AM

    Hi Christian,

    let's assume that you indeed do have the Oracle license that actually allows you to create objects in your oracle database (see note 581312 "Oracle database: licensing restrictions" for why this usually isn't the case for SAP customer).

    So if you really are allowed to do such things, then you may want to look at the approach I described in my blog [Suck that data out ! Connect from Oracle to MaxDB|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6225] [original link is broken] [original link is broken] [original link is broken];.

    Of course you've to be extremely careful about data types and everything will be manual labour, but you possibly can use triggers to propagate data changes from Oracle to MaxDB this way.

    Depending on your exact requirements you may also think of a solution in the ABAP layer (go for this if possible!) by simply using two database connections and a regular syncronization run between both data sets.

    hope that helps,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2009 at 06:17 AM

    Thank you for your posts

    My questions are answered but i have one more regarding the same subject.

    After searching same days on the web i found that most import-export solutions use the "IDoc Interface". This solution involves creating XML files from SAP and then importing these files with a custom application. Can someone provide me with a web link to a well structured documentation regarding this method ?

    Add comment
    10|10000 characters needed characters exceeded