Forum Stats

  • 3,837,681 Users
  • 2,262,285 Discussions
  • 7,900,357 Comments

Discussions

Using Oracle R Enterprise as a source to EPBCS

ORAHYPFDM
ORAHYPFDM Member Posts: 372 Blue Ribbon
edited Jun 3, 2020 2:40AM in Financial Data Management

I know we have only limited source systems for direct integrations to EPBCS data management.

Is there any way we can use Oracle R enterprise as a source to EPBCS using DM?

Any possible workaround?

Tagged:

Best Answer

Answers

  • SH_INT
    SH_INT Member Posts: 3,192 Bronze Crown
    edited Jun 2, 2020 8:11AM

    From what I understand Oracle R Enterprise just allows R functions to be transparently executed against data stored in an Oracle database amongst other things. If you are just looking to pull the data from the database then that can be used a source for data management as long as you can write a SQL query to get the data you want. It you need some R processing on top of that then you would have to materialise the processed data somewhere i.e. file, db tables etc and use that as the source

    ORAHYPFDM
  • ORAHYPFDM
    ORAHYPFDM Member Posts: 372 Blue Ribbon
    edited Jun 2, 2020 8:40AM

    In that case, how we can utilize to extracting data from Oracle tables using PBCS DM?

  • SH_INT
    SH_INT Member Posts: 3,192 Bronze Crown
    edited Jun 2, 2020 9:22AM Answer ✓

    You'll need to use the EPM Integration Agent thats part of latest versions of Data Management / Data Integration

    ORAHYPFDM