OneData 10.7 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Exporting Data from OneData Objects | Creating Export Jobs | Creating a Database Update Export Job
 
Creating a Database Update Export Job
A database update job allows you to directly update a remote database or to generate a SQL script file. You can download the script file from OneData or send the script file through email or FTP. The current release of OneData supports direct updates to Oracle, SQL Sever, DB/2, Teradata, and Sybase.
For a database update job, you must configure a connection to the remote database. If you want to write the script file to an FTP destination, you must set up an FTP location.
For more information about configuring remote databases and FTP locations, see Administering webMethods OneData.
*To create a database update job
1. On the Menu toolbar, click Data Interchange > Manage Export Job.
OneData displays the existing jobs.
2. Click Add a Job and complete the Database Update Job fields:
Field
Description
Name
Enter a name for the job.
Description
Enter a description of the job.
Job Type
Select Database Update Job.
Export Type
Default is selected by default. Select an export type for the job:
*Default: Identifies full load and incremental load.
*Resynchronize: Synchronizes the target database based on the OneData database.
*Delete and Reinsert: Deletes and re-inserts a record if it already exists in the target database.
When exporting data to Apache Hive, use only Default or Delete and Reinsert.
Notification
Select the notification option. For information about notification options, see Job Notification Options.
Notification Recipients
Click the Select A Value icon to select the users or user groups to receive notifications. To search on a user or user group, enter the name in the search criteria field and click the Search Value icon or press Enter.
To clear the values, click the Clear Value icon.
Export data for all job steps...
from this date
till this date
Enter a date range to limit the records exported. For information about date fields in export jobs, see Job Date Ranges.
Execution Options
Select the Rollback on Failure to roll back all changes in the remote database when the job fails.
This option is not supported for Apache Hive connections.
Log Exports
Select whether OneData creates a log of the export job. For information about the logging options, see Job Log Options.
3. Specify the remote database connection details:
Field
Description
Remote Connection
Select a connection to the remote database from the list.
Alternate User Name Alternate Password
Specify an alternate user name and password for the selected remote connection.
4. Choose an output option for the database update job:
If you choose…
The job does this…
Run Database Update Script
Directly updates the remote database using a script file generated by the job.
This option is not supported for Apache Hive connections.
Create Script File
Creates a script file that can be used to update the remote database. The job sends this script file through email and/or to the FTP location. The job creates the script file only for the target databases that are in Oracle or SQL Server. For other databases, the script file is not generated.
E-mail Recipient(s): Enter the email addresses to receive the output file. Separate multiple emails with a comma.
File Name (Optional)
Enter a file name. OneData overwrites the file every time the job runs. If you omit a file name, OneData generates the file name and creates a new file every time the job runs.
FTP Destination
Select a FTP destination to which the job writes the output file.
5. Click Save.
6. Create job steps to specify the data that is included in the export job. For information about creating a job step, see Adding Job Steps.