Scheduled Export: Export Data Extracted into Your SqlServer AutomaticallyThursday, July 21, 2016 2:06 AM
Octoparse allow you to configure a scheduled task to export data extracted into your SQLServer automatically.
Before exporting data to your database, check the data extracted by hovering your mouse over the task.
( “View data” function is only available when using Cloud Extraction.)
Let's get started!
In the “My task” list, hover your mouse over the task.
Click the task and choose the “View data”. Then all the date extracted will be showed in the screen.
At the bottom of the window, click “Export Current” button and choose “Export to Database (Automatic)”.
In the pop-up window, click “next” to complete the database connection information.
In the “Export To Database(Automatic)” window:
Select a database type. You can choose from SqlServer, MySql and Oracle.
Enter the server name.
Select authentication. Window authentication or SqlServer authentication.
Enter “UserID” and password.
Select database name. (I will choose “Test” here for example)
Then hit “Test Connection”.
When the connection is available, move on to the next step.
We see that all the field are listed. Select the data table from the list. (I will choose “Test” here for example) And you can set field mapping information.
After you completed the information for database connection, you can schedule the automatic export operation at regular intervals.
Enter the schedule name. (“Test” for example)
Set up an hourly plan. Choose “Interval” option and choose a period from the list. (One hour for example)
Click “Finish” when export data to database completed.
After you schedule an import or export operation, you will need to start your export operation.
In the pop-up window named “Export task outputs to database on schedule”, we click the Start button to start the export operation.
We can also check and manage the scheduled export tasks.
You can also find the window by clicking the "Export plan" icon in the top-left corner of the Octoparse interface.
Once you start the export operation, you can't close Octoparse but you can close the "Export task outputs to database on schedule" window.
Because if you close Octoparse, you also close the Export scheduler and will stop/kill the export process.
If Octoparse is closed by accident and the export process is stopped, you can open Octoparse and restart your export task. The system will continue the export operation.
Happy Data Hunting!
Author: The Octoparse Team
For more information about Octoparse, please click here.
Sign up today.