webMethods, OneData, and Terracotta  10.2 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Exporting Data from OneData Objects | Creating Export Jobs | Creating a Hook Execution Export Job
 
Creating a Hook Execution Export Job
A Hook Execution job allows you to run a hook that is defined in OneData. A hook is used to run a stored procedure in the database. The data is distributed using a stored procedure, and the logic for distribution is in the stored procedure.
* To create a hook execution 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 Hook Execution Job fields:
Field
Description
Name
Enter a name for the job.
Description
Enter a description of the job.
Job Type
Select Hook Execution Job.
Export Type
Select an export type for the job:
*Default: Identifies the full load and incremental load at the job level. This is also the export type selected by default.
*Resynchronize: Synchronizes the target database based on the OneData database as follows:
*Records that are new in OneData, but are not present in the target database are inserted into the target database.
*Records present in both OneData and the target database, but modified only in OneData are modified in the target database as well.
*Records deleted in OneData, but present in the target database are deleted. Any record present only in the target database is not affected by this process.
*Delete and Reinsert: Deletes and re-inserts a records that are present in both OneData and the target database. If a record deleted in OneData is not present in the target database, all records in the target database are deleted. Then, only the undeleted records in OneData are inserted into the target database.
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.
Log Exports
Select whether OneData creates a log of the export job. For information about the logging options, see Job Log Options.
3. In Hooks, select the hook.
4. Click Save.
5. Create job steps to define which data to include in the export job. For information about creating a job step, see Adding Job Steps.
Copyright © 2011-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release