Integration Connection types

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of the Job Type 'Refresh' in an integration job?

To take a dataset from a Preprocessor.

To create a report based on data queries.

To pull data from the integrated system into the Configured Commerce database. (correct)

To run a SQL statement or stored procedure.

Which of the following options is NOT a section included in creating a Job Definition?

Details

Steps

Execution (correct)

Parameters

What happens if a computer not listed in the allowed computers calls the integration service?

The job fails without any notifications.

The job proceeds with limited functionality.

The system sends an email alert to the administrator. (correct)

The integration is processed but with an error.

Which attribute is used to identify a job definition?

Job Name Signup and view all the answers

For which purpose is the 'Execute' job type mainly used?

To schedule maintenance and archiving tasks. Signup and view all the answers

Which setting must be identified to avoid processing internal integration requests by every web server?

Computers Allowed for Integration Signup and view all the answers

What is defined as 'Internal' in the context of connections for job types?

Initiated directly by the web server. Signup and view all the answers

Which section is primarily responsible for detailing notifications and recurrence in a Job Definition?

Details Signup and view all the answers

What does the Name field in the SystemSetting type of parameter define?

The unique identifier of the parameter within the job definition Signup and view all the answers

What happens if both the Name field and Default Value field fail to resolve in a SystemSetting parameter?

The parameter cannot be set Signup and view all the answers

What is the purpose of Field mapping in integration jobs?

To connect data from a source to Configured Commerce Signup and view all the answers

In a Field Type, what does the 'Static Value' refer to?

A fixed value assigned to the parameter Signup and view all the answers

What is the significance of operating with debugging 'on' during integration jobs?

It provides real-time feedback on record counts every 100 records Signup and view all the answers

When using the Lookup Field Type, what is required to find a target object entity?

First selecting the To Property and then the From Property Signup and view all the answers

What does the Key dataset key uniquely identify?

Records for delta datasets and Refreshes Signup and view all the answers

What information is primarily displayed on the Field Mapping tab?

A list of Job Step Field Mappings Signup and view all the answers

What happens if a required job parameter is not set up?

An error message is generated indicating the parameter is missing Signup and view all the answers

What role does the Content field type serve in Field Mapping?

Specifies default values, static values, or import data values Signup and view all the answers

Which parameter is specifically required by the CleanupExportSpreadsheets post processor?

RetentionDays with a value type of number Signup and view all the answers

What does the Default Value represent for the value type of Application Setting?

The setting name Signup and view all the answers

What is the purpose of the History tab?

To display integration jobs that have run with their details Signup and view all the answers

What does the prompt in the job parameters do?

Prompts users for input when running the job Signup and view all the answers

How can users filter the jobs displayed in the History tab?

By entering a specific job name in the search box Signup and view all the answers

What must be unique within the job definition?

Parameter Name Signup and view all the answers

What does refreshing inventory generally utilize to locate a product?

Product Number and Warehouse Name Signup and view all the answers

If you want to minimize performance issues when updating categories and products, which collection should be updated with the fewer children?

Update Product with a list of categories Signup and view all the answers

What happens when the Overwrite setting is set to True during a Refresh job?

Data is completely replaced with new data Signup and view all the answers

Which property is used to define what should occur if a related entity cannot be found during a Refresh job?

Lookup Signup and view all the answers

What role does the Persona field play in content field types during refresh jobs?

Provides available personas for content elements Signup and view all the answers

What is indicated by a dataset key when determining data during Refresh jobs?

This applies only to Refresh jobs Signup and view all the answers

When the Languag field is left empty during a Refresh job, which setting is applied?

Language is set to default system language Signup and view all the answers

Which of the following statements is true regarding the Child Collection in a Refresh job?

It assigns records without data for specific selections. Signup and view all the answers

What happens if the file is missing and the 'Error' action is set?

An error message is logged, and the job ultimately fails. Signup and view all the answers

Which statement accurately describes the 'Ignore' action?

It treats the absence of files as an expected condition and ends the job successfully. Signup and view all the answers

What is the significance of the 'Skip' option regarding flat files?

It allows the job to skip the first row if a header is detected. Signup and view all the answers

When using flat files, what is required to avoid errors in the defined columns?

The number of defined columns must match the data in the flat file. Signup and view all the answers

What is the purpose of the 'From/From Clause' in a Refresh job?

To specify tables and join conditions for the Refresh job. Signup and view all the answers

How are static variables utilized in the Where clause?

Static variables must be enclosed in single quotes, e.g., Status = 'A'. Signup and view all the answers

What does the 'Parameterized Where clause' allow during refresh jobs?

It defines a separate condition when parameters are specified. Signup and view all the answers

Which function can be used in the Select clause for a flat file?

Any functions supported by the connection, like SUBSTRING. Signup and view all the answers

Study Notes

Integration Jobs

Integration Jobs are a feature of Optimizely Configured Commerce that allows you to connect and synchronize data between Configured Commerce and external systems.
You can define integration jobs using Job Definitions, which specify the process for data exchange.
There are four main types of jobs: Refresh, Submit, Report, and Execute.
Refresh jobs pull data from an external system and update the Configured Commerce database.
Submit jobs send data from Configured Commerce to an external system.
Report jobs run data queries to generate reports.
Execute jobs run SQL statements or stored procedures for tasks like maintenance or archiving.
You can configure Job Definitions using the Admin Console > Jobs > Job Definitions page.
A Job Definition has four sections: Details, Steps, Parameters, and History.

Job Details

Job Details define the overall settings of the job.
The Job Name identifies the job.
Job Type specifies the purpose of the job (Refresh, Submit, Report, or Execute).
Connection determines which external system the job connects to.
File Action specifies how the system should handle missing files.
Error - the job fails if no file is found.
Warning - the job fails if there are no errors after the missing file condition.
Ignore - the job succeeds as long as there are no other issues
Skip - Skips the first row if the flat file has a header.
Header - the system processes all rows if this setting is not enabled.
Columns/Select Clause defines the columns to retrieve from the data source for Refresh jobs.
From/From Clause specifies the tables to use and join conditions for Refresh jobs with a database connection.
Where/Where Clause defines conditional expressions for Refresh jobs.
Parameterized Where defines a separate Where clause for the Refresh job when parameters are specified.
Parameters provide additional information to processors (pre/integration/post) during job execution.
SystemSetting parameter type can use both the Name and Default Value fields to resolve setting values.

Job Steps

Job Steps define the specific actions to be performed within the job.
Details provide general information for the step.
Parameters define parameters specific to the step.
Field Mapping defines how data is transferred between the source and target systems.

Field Mapping

Field Mapping connects data from the source system to Configured Commerce.
Field Type determines the type of field to be mapped.
Field specifies the data field from the source or target system.
Static Value sets a fixed value for the field.
Application Setting uses a dynamic value from an application setting.
Content defines default values, static values, or imported data values.
Lookup references a related entity in the system.
Child Collection assigns records without specific data.
From Property defines the source of the data.
To Property defines the target for the data.
Language, Persona, and Device define settings for specific data types.
Lookup Error Handling determines the job's response if a related entity cannot be found.
Overwrite indicates whether existing data should be overwritten during refreshes.
Dataset Key identifies dataset records for delta datasets and refreshes.

Job Parameters

Job Parameters provide additional information to processors during job execution.
Sequence indicates the order of parameter prompts or passing.
Parameter Name identifies the parameter.
Value Type specifies the data type for the parameter.
Default Value defines the default value for the parameter.
Prompt allows users to provide a value for the parameter when running the job manually.

Job History

Job History logs information about all jobs that have been run.
You can view job details, including parameters and logs, by clicking View.
You can filter the job history by using the search box.
You can delete queued jobs to stop them from processing.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Explore the features and types of Integration Jobs in Optimizely Configured Commerce. This quiz covers how to define job definitions, the process of data exchange, and the four main types of jobs: Refresh, Submit, Report, and Execute. Test your understanding of the configuration and operations within the Admin Console.