Skip to Content

Extracting from CODA financials v12 into SAP BW

Hello Experts,

We have a requirement to extract data from CODA financials into SAP BW. I have been searching for some document on this but could not find any.

Can you please suggest possible approach? How to connect to CODA system? Do we need any other integration tool? Please share your experiences, it will help me in designing a solution.

Thanks,

Francis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 19, 2016 at 08:11 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2016 at 11:40 AM

    Hi,

    I think CODA is a non sap system. On which DB its there? And i think you will be moving NON SAP DB to HANA BW. Please confirm.

    One way you can extract via BODS. We did our migration recently from teradata to BW HANA and moved all the data through BODS to HANA DB.

    Let me know if you have other queries regarding the same.

    br

    SD

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2016 at 09:57 AM

    Hi Sumeet,

    We have BW 7.0 (no plan to move to HANA in near future). Database is Oracle 11.2. We currently don't have BODS, is there any other way to connect? like via UD Connect or DB Connect?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 16, 2016 at 10:12 AM

    Has anybody here used CODA?

    Does it provide facility to send data to other systems? Handle delta mechanism?

    CODA uses Oracle database is.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2016 at 08:11 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 03, 2017 at 11:32 AM

    Thanks Sumeet, your docs were helpful.

    Finally we went for DB Connect. Once the connectivity was configured by basis the communication was seamless.

    We were able to see all CODA tables from BW and managed to do a prototype by extracting table contents into a custom DSO.

    Thanks,

    Francis

    Add comment
    10|10000 characters needed characters exceeded