Hi Rajasekar, Copying the users list, since this is a usage question (pipeline development), not an Apache Hop development topic.
The first four steps in your use case are common and well-documented (Table Input -> Text File Output), (5) may require a CLI operation (Shell action), (6) depends on the Oracle REST API service. Uploading a file may be tricky with the REST client transform, but should be ok through a curl command in e,g. a Shell action. Have a look at the Getting Started guide [1] and let us know if you run into any issues. If you do, please provide details about what you tried, what worked and what didn't. Happy hopping! [1] https://hop.apache.org/manual/latest/getting-started/ Regards, Bart On Mon, Dec 9, 2024 at 10:41 AM Raja Sekar <rajasekarvisu...@gmail.com> wrote: > Dear Sir/Madam, > > I hope this email finds you well. > > I am currently working on a task that involves extracting data from an > MYSQL database and uploading it to an Oracle Fusion Rest API service. Below > are the key steps involved: > > 1. Create a connection to the Oracle EBS database. > 2. Run a SQL query to fetch the required data from EBS. > 3. Convert the response into a CSV file. > 4. Compress the CSV file into a Zip file. > 5. Encode the Zip file as a Base64 string. > 6. Upload the Base64 string to the Oracle Fusion Rest API service. > > I would appreciate your guidance and support in completing this task. > Specifically > > If you have any experience or know of any documentation that can assist me > in completing these steps, I would be grateful for your input. > > Looking forward to your response. > > Best regards, > Rajasekar >
