Forum Discussion

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

that's technically impossible. You cannot extract the data from Oracle without any performance impact. 

 

I don't know to what extent you can control your Oracle database - you could theoretically explore triggers there that would automatically push the rows upon inserts. 

 

Where does the Oracle database get the live data from?

  • razieh1990's avatar
    razieh1990
    Icon for Helper I rankHelper I
    2 years ago

    Thanks for your reaponse.

    the oracle gets data from external system.

    I every second a lot of rows are inserted in database.

    there is a video on youtube and I'd like to analyze the potential risk on oracle before implementing it.

    https://youtu.be/vpD_PKtcTj8?si=BvALkZsN_uEPWnEn

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      have the external system push the rows into the streaming dataset. Note that there are size limits - a streaming dataset won't hold more than 5 million rows.

      • razieh1990's avatar
        razieh1990
        Icon for Helper I rankHelper I
        2 years ago

        Thanks for your response. Are there any articles or sources I can read and know how to push the rows into the streaming dataset?  I don't have knowledge to do it and would like to know how to do it 

        much appreciated