How to fetch data from Oracle database and push it into Sharepoint online list using Azure logic app

Question

I need to fetch data from Oracle database and push that data into Sharepoint online list using Azure logic app. I am new in this technology and have this critical requirement. Appreciate any help

Answer 1

Rashmi Goyal (SolutionsPlus) Thanks for posting your question in Microsoft Q&A. I hope you are familiar with terms such as triggers (to start the workflow), action, connectors etc. Otherwise, check out https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-overview#key-terms to get started and choose a necessary trigger for your workflow.

Let's focus about action to connect to Oracle database and push the item to SharePoint.

#1 You can use "Oracle Database - Get row" action available in Oracle connector to fetch the rows with needed credentials/authentication.

#2 Then use "Create item" action in SharePoint connector to build the workflow to post the data to SharePoint or any other actions based on your need with connection details such as site address, username/password.

Check out Connect to Oracle Database from Azure Logic Apps and https://learn.microsoft.com/en-us/connectors/sharepointonline docs for more info about the connectors.

I hope this helps and let me know if any questions.