What is the maximum limit of records to be updated in oracle database using Azure function? RRS feed

  • Question

  • There is a requirement for the initial load of almost 5 lakhs customers into the oracle database. We are planning to achieve this using Azure function.

    Can you please suggest if that's possible? if not, can you suggest any alternative approaches.

    Please note that connecting to client's database can only be possible using VNET as it is hosted in a private network.

    Tuesday, September 29, 2020 12:05 PM

All replies

  • Azure limits are only by what you pay for and Oracle limits only by hardware.
    Tuesday, September 29, 2020 2:41 PM
  • @Stefan - Thanks for the quick reply, can you please also answer the below two questions?

    1) we have initial load volume data of about (5 lakhs to 7 lakhs) and incremental load (2k to 5k Daily). Can you please suggest us we can use the Azure data factory solution or Azure function for both initial and incremental load.? If AD, How expensive it is when compared with Azure functions? Logic apps are scheduled to run daily for incremental load.

    2) We have used azure function o create Vnet and enable vnet peering to establish connection with client databases due to security concerns. So, can you please also suggest if we use Azure Data factory, can we implement vnet peering for the same? 

    Thanks in advance :)

    Thursday, October 1, 2020 3:50 PM
  • Not really. But some hints:

    1) What does initial load mean? Processing the data or just pushing it into your database?

    Post processing means that it need to run thru your logic and it will create cost. Just loading it into your database should be not a problem, as you can bulk load data to Oracle.

    The daily load (2k to 5k) should be for sure not a problem or cost driver.

    2) I'm a developer, so IaaS questions are better asked in Azure related forums.

    Monday, October 5, 2020 9:44 AM