This is my monthly routine process:

1. I received a text file from another company.
2. I load the file into the Oracle database by calling sqlldr.exe.
3. Run a couple of store procedures in the Oracle database.
4. Export output of one store procedure to CSV file I would like to automate this process by using the Azure Logic App or Azure function, is it possible? 

CodePudding user response：

Thanks Skin for bringing up the Usage of Azure. There are numerous building blocks you can use, a virtual machine. You can trigger that on the virtual machine it can be flexible to use whatever you want.

But in your requirement, you have to use the below steps to achieve this.

I don’t think using sqlldr.exe will be complicated while using this module in the azure function and logic app.

So you can use BCP to achieve this which is the ease of use in azure function to load your file data into the database.

Here you can use the Logic App & Azure function to achieve this.

Create an azure function to do the below tasks

1. I received a text file from another company.
2. I load the file into the Oracle database by calling sqlldr.exe.

Instead of using SQLDIR.EXE, you can use the BCP.

Check the reference to use BCP to load the file into the database.

Once done with the above process create the Logic App and include the azure function in the flow.

Select the Azure Function and add your created azure function.

3. Run a couple of store procedures in the Oracle database.
4. Export output of one store procedure to CSV file

And next flow you can use the oracle database and use action as Execute Stored Procedure and configure your oracle server and run your Stored procedure.

Refer here for more information