Creating export jobs
Learn more by watching the video!
Follow these steps to export either a data object or segment to an external destination.
Create an export job
To create an export job:
- Click the Oracle icon in the bottom-right corner to open the navigation menu.
- Select Data feeds.
- In the top-right corner, click Create data feed, then select Export job.
The Create export job page is displayed.
Note: You can open and close the different sections on the page by clicking the Arrow button , or anywhere else in the section heading.
Step 1: Define your job details
The job details section allows you to define how the export job will display in Oracle Audience Segmentation. You will also need to select the destination that Oracle Audience Segmentation will use to send the data to.
To define your job export fields:
- Enter the details for the export job.
- Name: Enter a name. The name must be 1 or more characters, up to a maximum of 50. Other than underscores (_) and hyphens (-), special characters are not allowed. The first character cannot be a space. You can use characters from all languages supported in the language settings.
-
Job ID: The unique system identifier for your job. You can't change this value after you create the job.
- If the job name uses English characters, the Job ID field is auto-populated from the job name you enter. You can change this value before the job is created.
- If the job name uses characters from another language supported in the language settings, the Job ID field will be left blank. You will need to enter a name using English characters.
- Description: Enter a description. This field is optional, but it is highly recommended to add descriptions for any entity created. This helps all other users get additional context when using and navigating Oracle Audience Segmentation. The description can have a maximum of 512 characters with no restrictions on characters used. You can use characters from all languages supported in the language settings.
- Destination: This is the destination of the data you want to export out of Oracle Audience Segmentation. Use the drop-down list to view all the destinations that have been created and make a selection. When you select a destination, the details of it will display. Review the details and make sure they are accurate and up to date. You can also create a new destination by scrolling to the bottom of the drop-down list and clicking Create destination. Learn more about Creating destinations.
- Review the Server information to ensure it is valid.
- Review and complete the File format information.
- Review and confirm the Field Delimiter.
- Enter a File name.
- We recommend using a file name that includes the export job name for easy identification.
- You can use characters from all languages supported in the language settings.
- The file name you provide will override the file name defined in the destination.
- A timestamp will be added to the custom file name you provide in the following format: yyyy-MM-dd-HH-mm-ss-SSS. For example, entering the file name export_job_customer will generate the following file name in the destination when it runs: export_job_customer_2020-05-13-08-04-13-354_0.csv.
Example: You create a Secure FTP destination with the file name sftpfile.csv and use it for the following export jobs: Address export job, Promotion export job, and Order export job. When setting up the export jobs, you can create the following unique file names for each one: sftpfile_address, sftpfile_promotion, and sftpfile_order. This allows you to quickly identify which data object was exported in each file.
Review the compression format.
The default value is generated from the value configured in the selected Destination settings.
Any changes you make to the compression format will override the configurations in the Destination settings.
If you select PGP, you will need to provide an encryption key.
If PGP compression format is selected, an encryption key is required. If you change the existing compression format to PGP, select the file that has the encryption key.
The following encryption keys are supported.
Key type Bit lengths RSA
(RSA cryptosystem)2048 3072 4096 - Once you have confirmed that the details are correctly configured, click Continue.
Step 2: Data payload
The Data payload section allows you to select the type of export job you want to create: segment export or data object export.
To set up the Data payload section:
- For Payload type, select Segment or Data object.
To set up a segment export:
- Select the segment to export. If needed, search by segment name. A list of the attributes from that segment that will be exported will display.
- Review the attributes that will export and click Continue.
To set up a data object export:
- Select the data object to export. If needed, search by data object name.
- Select the attributes you want included with the exported data object:
- To export all attributes from the data object, select All attributes.
- To export specific attributes from the data object, choose Selected attributes and use the drop-down menu for Attributes to select or search for attributes. Then, click Add .
- To delete an attribute from the list of attributes to export, click Delete .
- When done, click Continue.
Step 3: Filter records
If you export a data object, the Filter records section allows you to set filter criteria so that you limit the records that will be exported.
To filter records:
- Select the filter you want to use: Date created or modified, Date created, or All records.
- If you select Date created or modified or Date created, the following additional filter will apply to your selection: Since the export job last ran.
- Review the filter records and click Continue.
Important: If you select Data created or modified or Date created, data that was imported with the Near real-time API will not be included in the exported data. To include data imported with the Near real-time API, select All records.
Step 4: Schedule and notify
You will need to configure the schedule and notification settings for the export job.
To schedule the export job and define the notification settings:
- Configure the schedule for the export job:
- You will need to set a Recurring schedule if you export a data object and select the filter Date created or modified or Date created. This job will automatically run on a regular schedule. If a job is still running while the next one is scheduled to run, the next scheduled run will not start until the current one completes. Two scheduled instances of the same export job can't run simultaneously.
- You will need to set an On demand schedule if you export a data object and select the filter All records. You will need to start the job as needed from the Data feeds page. Learn more about Managing data feeds.
- If the job is recurring, select the Frequency, Start time, and Days it will run.
- In the field for Notify, enter the email addresses of people to be notified when the job runs. You can use characters from all languages supported in the language settings. Separate multiple emails with a comma. Only available for segment exports.
- If you only want a notification if the job fails, click the checkbox Only notify on failure. Only available for segment exports.
Step 5: Saving and publishing the export job
After saving the export job you will need to publish the changes before it can run.
To save and publish the export job:
- Scroll to the top of the page and click Save or Save and close.
- Follow the steps for Publishing changes.
When the publishing task is completed, the export job can run. Learn more about Managing export jobs.