Extract the table data (csv format) in ATP Database
Summary
Extract the table data (csv format) with some filter criteria in ATP DatabaseContent
We are using ATP to store the data and do some enrichment before sending to target system.The target systems(non oracle) are accepting the data in csv files only.It needs to be done through the automated integration program. Hence I am looking for guidance that how we can achieve the automated way to generate the csv files for a table data (based on some filter criteria).
In the normal DBCS instance, We have access to UTL_FILE which can be called inside the packaged procedure to write the csv file programatically. Is it achievable in ATP ?Just for FYI ... We are using Oracle SOA for orchestrating the process. We will like to use write file operation on database side due to high volume data and will impact the performance on SOA if we use the SOA for writing the file.