Octoparse now supports exporting data to Oracle databases. Before you export the data, please make sure that you will need to install the Oracle related components.
Step 1: Download Oracle Instant Client
Download the appropriate Instant Client packages for your platform. All installations require the Basic or Basic Light package.
Step 2: Unzip the packages into a single directory such as C:\oracle\instantclient_19_3
Step 3: Add this directory to the PATH environment variable
Right-click Computer.
On the context menu, click Properties.
In the System dialog box, click Advanced system settings.
On the Advanced tab of the System Properties dialog box, click Environment Variables.
In the System Variables box of the Environment Variables dialog box, scroll to Path and select it.
Click the lower of the two Edit buttons in the dialog box.
Click New and paste
C:\oracle\instantclient_19_3
Click OK and click on every OK button you will encounter to close every previous window.
Note:
If you still get the error message "Missing Oracle related components" after setting up the above steps, please restart the Octoparse software.
You can then set up export steps to export the data to Oracle! Check out more details here.