The flat file is in blob dtorage I read the data from ADF and I need to update the data from ADF to oracle DB table I was not seen any option How to do this .

Yes, it is possible to update data from Azure Data Factory (ADF) to an Oracle database table. One approach is to use the Oracle E-Business adapter with BizTalk Server, which enables adapter clients to perform operations on interface tables and views with large data types such as BLOB, CLOB, NCLOB, and BFILE. The adapter exposes Read_<LOBColName> and Update_<LOBColName> operations to read and update data respectively, where <LOBColName> is the name of the column with large data type. If there is more than one column with large data type in a single interface table, the adapter exposes as many read and update operations for that interface table. For more information on how to perform operations on columns with large data types, see the Working with tables that have large data types in Oracle E-Business Suite article.

Another approach is to use the Oracle Database adapter with BizTalk Server, which supports the BFILE data type in tables and stored procedures. The adapter exposes different data types for the BFILE column/parameter based on the operation performed and the LOB artifact (table/procedure) accessed. For example, for the SELECT operation on a table with a BFILE column, the adapter exposes byte[] as the data type representing the binary data constituting the BFILE. For more information on how to perform operations on tables containing BFILE data types, see the Operations on Tables With BFILE Data Types in Oracle Database article.

References:

• Working with tables that have large data types in Oracle E-Business Suite
• Operations on Tables With BFILE Data Types in Oracle Database

@P, Pooja Thanks for posting your query on Microsoft Q&A. Yes, it is possible to achieve that by having Azure Blob storage as Source and Oracle database as Sink in the Azure data factory. Here are the steps:

Create a Data Factory: Begin by creating an Azure Data Factory (ADF) instance. ADF is a cloud-based data integration service that allows you to create, schedule, and manage data-driven workflows. You can create a new Data Factory using the Azure portal or programmatically using the Azure SDK for .NET.

Set Up Linked Services: Create linked services for both your Azure Blob Storage (as the source) and your Oracle Database (as the sink). Linked services define the connection information for your data stores.

Define Datasets: Create datasets for your source (Azure Blob) and sink (Oracle Database) data stores. The dataset specifies the data structure, location, and format.

Create a Pipeline: Design a pipeline that includes a Copy activity. The Copy activity will read data from your Azure Blob Storage and write it to your Oracle Database. Configure the source and sink datasets in the Copy activity.

Start the Pipeline Run: Trigger the pipeline run to execute the data movement. Monitor the pipeline and activity runs to ensure successful execution.

Step by Step tutorials:

-Copy data from and to Oracle by using Azure Data Factory
-Copy and transform data in Azure Blob Storage by using Azure Data Factory
-Using the .NET SDK

If you have questions, please let me know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.

Please don’t forget to "Accept Answer" and hit Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members for remediation for similar issues.