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. |
Notification | |
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. |
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. This connection details are used when |
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. |
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. 