MDM Extension for Databricks > Predefined MDM Extension for Databricks assets > Batch jobs
  

Batch jobs

MDM Extension for Databricks includes predefined egress batch jobs and Data Integration taskflows. Use the egress batch jobs to publish master data from MDM SaaS to the staging tables in Databricks. You can then use the taskflows to load data from the staging tables into the analytical tables in Databricks.

Assets for customer data

Use predefined egress jobs to export master data from Customer 360 SaaS to the staging tables in Databricks. Then use the predefined Data Integration taskflow to publish data from the staging tables into the analytical tables in Databricks.
The following table lists the predefined egress jobs and their dependent assets to export master data from Customer 360 SaaS to the staging tables in Databricks:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360databricks_customer_egress_org_outbound_org_stage
infa360databricks_customer_tf_org_outbound
  • - infa360databricks_customer_mt_org_address_outbound
  • - infa360databricks_customer_mt_org_alternateName_outbound
  • - infa360databricks_customer_mt_org_document_outbound
  • - infa360databricks_customer_mt_org_email_outbound
  • - infa360databricks_customer_mt_org_financial_outbound
  • - infa360databricks_customer_mt_org_identifier_outbound
  • - infa360databricks_customer_mt_org_indicator_outbound
  • - infa360databricks_customer_mt_org_insurance_outbound
  • - infa360databricks_customer_mt_org_keyexecutive_outbound
  • - infa360databricks_customer_mt_org_phone_outbound
  • - infa360databricks_customer_mt_org_root_outbound
  • - infa360databricks_customer_mt_org_segment_outbound
  • - infa360databricks_customer_mt_org_socialhandle_outbound
  • - infa360databricks_customer_mt_org_status_outbound
  • - infa360databricks_customer_mt_org_stockexchange_outbound
  • - infa360databricks_customer_mt_org_taxdetails_outbound
  • - infa360databricks_customer_m_org_address_outbound
  • - infa360databricks_customer_m_org_alternateName_outbound
  • - infa360databricks_customer_m_org_document_outbound
  • - infa360databricks_customer_m_org_email_outbound
  • - infa360databricks_customer_m_org_financial_outbound
  • - infa360databricks_customer_m_org_identifier_outbound
  • - infa360databricks_customer_m_org_indicator_outbound
  • - infa360databricks_customer_m_org_insurance_outbound
  • - infa360databricks_customer_m_org_keyexecutive_outbound
  • - infa360databricks_customer_m_org_phone_outbound
  • - infa360databricks_customer_m_org_root_outbound
  • - infa360databricks_customer_m_org_segment_outbound
  • - infa360databricks_customer_m_org_socialhandle_outbound
  • - infa360databricks_customer_m_org_status_outbound
  • - infa360databricks_customer_m_org_stockexchange_outbound
  • - infa360databricks_customer_m_org_taxdetails_outbound
Exports customer data from Customer 360 SaaS to the staging tables in Databricks.
infa360databricks_customer_egress_outbound_org_xref_stage
infa360databricks_customer_tf_org_xref_outbound
  • - infa360databricks_customer_mt_org_xref_outbound
  • - infa360databricks_customer_m_org_xref_outbound
Exports customer data from Customer 360 SaaS to the staging tables in Databricks.
infa360databricks_customer_egress_person_outbound_person_stage
infa360databricks_customer_tf_person_outbound
  • - infa360databricks_customer_mt_person_address_outbound
  • - infa360databricks_customer_mt_person_alternateName_outbound
  • - infa360databricks_customer_mt_person_citizenship_outbound
  • - infa360databricks_customer_mt_person_demographic_outbound
  • - infa360databricks_customer_mt_person_document_outbound
  • - infa360databricks_customer_mt_person_email_outbound
  • - infa360databricks_customer_mt_person_financial_outbound
  • - infa360databricks_customer_mt_person_identifier_outbound
  • - infa360databricks_customer_mt_person_insurance_outbound
  • - infa360databricks_customer_mt_person_lifestyle_outbound
  • - infa360databricks_customer_mt_person_loyalty_outbound
  • - infa360databricks_customer_mt_person_phone_outbound
  • - infa360databricks_customer_mt_person_professional_outbound
  • - infa360databricks_customer_mt_person_qualification_outbound
  • - infa360databricks_customer_mt_person_root_outbound
  • - infa360databricks_customer_mt_Person_segment_outbound
  • - infa360databricks_customer_mt_person_socialhandle_outbound
  • - infa360databricks_customer_mt_person_specialization_outbound
  • - infa360databricks_customer_mt_person_status_outbound
  • - infa360databricks_customer_mt_person_taxdetails_outbound
  • - infa360databricks_customer_m_person_address_outbound
  • - infa360databricks_customer_m_person_alternateName_outbound
  • - infa360databricks_customer_m_person_citizenship_outbound
  • - infa360databricks_customer_m_person_demographic_outbound
  • - infa360databricks_customer_m_person_document_outbound
  • - infa360databricks_customer_m_person_email_outbound
  • - infa360databricks_customer_m_person_financial_outbound
  • - infa360databricks_customer_m_person_identifier_outbound
  • - infa360databricks_customer_m_person_insurance_outbound
  • - infa360databricks_customer_m_person_lifestyle_outbound
  • - infa360databricks_customer_m_person_loyalty_outbound
  • - infa360databricks_customer_m_person_phone_outbound
  • - infa360databricks_customer_m_person_professional_outbound
  • - infa360databricks_customer_m_person_qualification_outbound
  • - infa360databricks_customer_m_person_root_outbound
  • - infa360databricks_customer_m_Person_segment_outbound
  • - infa360databricks_customer_m_person_socialhandle_outbound
  • - infa360databricks_customer_m_person_specialization_outbound
  • - infa360databricks_customer_m_person_status_outbound
  • - infa360databricks_customer_m_person_taxdetails_outbound
Exports customer data from Customer 360 SaaS to the staging tables in Databricks.
infa360databricks_customer_egress_outbound_person_xref_stage
infa360databricks_customer_tf_person_xref_outbound
  • - infa360databricks_customer_mt_person_XREF_outbound
  • - infa360databricks_customer_m_person_XREF_outbound
Exports customer data from Customer 360 SaaS to the staging tables in Databricks.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish customer data from the staging tables into the analytical tables in Databricks:
Taskflow
Mapping Task
Mapping
Description
infa360databricks_tf_databricks_customer_stage_databricks_retail_analytics
  • - infa360databricks_mt_databricks_person_stage_databricks_tbl_address_dim
  • - infa360databricks_mt_databricks_person_stage_databricks_tbl_email_dim
  • - infa360databricks_mt_databricks_person_stage_databricks_tbl_phone_dim
  • - infa360databricks_mt_databricks_stage_databricks_tbl_customer_dim
  • - infa360databricks_m_databricks_person_stage_databricks_tbl_address_dim
  • - infa360databricks_m_databricks_person_stage_databricks_tbl_email_dim
  • - infa360databricks_m_databricks_person_stage_databricks_tbl_phone_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_customer_dim
Publishes customer data from the staging tables into the analytical tables in Databricks.

Assets for supplier data

Use predefined egress jobs to export master data from Supplier 360 SaaS to the staging schema in Databricks. Then use predefined Data Integration taskflows to publish data from the staging tables into the analytical tables in Databricks.
The following table lists the predefined egress jobs and their dependent assets to export master data from Supplier 360 SaaS to the staging tables in Databricks:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360databricks_supplier_egress_contact_outbound
infa360databricks_supplier_tf_contact_outbound
  • - infa360databricks_supplier_mt_contact_email_outbound
  • - infa360databricks_supplier_mt_contact_identifier_outbound
  • - infa360databricks_supplier_mt_contact_phone_outbound
  • - infa360databricks_supplier_mt_contact_postal_address_outbound
  • - infa360databricks_supplier_mt_contact_root_outbound
  • - infa360databricks_supplier_mt_contact_socialmedia_outbound
  • - infa360databricks_supplier_mt_contact_status_outbound
  • - infa360databricks_supplier_m_contact_email_outbound
  • - infa360databricks_supplier_m_contact_identifier_outbound
  • - infa360databricks_supplier_m_contact_phone_outbound
  • - infa360databricks_supplier_m_contact_postal_address_outbound
  • - infa360databricks_supplier_m_contact_root_outbound
  • - infa360databricks_supplier_m_contact_socialmedia_outbound
  • - infa360databricks_supplier_m_contact_status_outbound
Exports supplier data from Supplier 360 SaaS to the staging tables in Databricks.
infa360databricks_supplier_egress_contact_xref_outbound
infa360databricks_supplier_tf_contact_xref_outbound
  • - infa360databricks_supplier_mt_contact_xref_outbound
  • - infa360databricks_supplier_m_contact_xref_outbound
Exports supplier data from Supplier 360 SaaS to the staging tables in Databricks.
infa360databricks_supplier_egress_supplier_outbound
infa360databricks_supplier_tf_supplier_outbound
  • - infa360databricks_supplier_mt_supplier_address_outbound
  • - infa360databricks_supplier_mt_supplier_alerts_outbound
  • - infa360databricks_supplier_mt_supplier_altName_outbound
  • - infa360databricks_supplier_mt_supplier_bankdetails_outbound
  • - infa360databricks_supplier_mt_supplier_contract_outbound
  • - infa360databricks_supplier_mt_supplier_diversity_outbound
  • - infa360databricks_supplier_mt_supplier_document_outbound
  • - infa360databricks_supplier_mt_supplier_email_outbound
  • - infa360databricks_supplier_mt_supplier_esg_environmental_reason_outbound
  • - infa360databricks_supplier_mt_supplier_esg_governance_reason_outbound
  • - infa360databricks_supplier_mt_supplier_esg_rating_sustainalytics_outbound
  • - infa360databricks_supplier_mt_supplier_esg_ratingdnb_outbound
  • - infa360databricks_supplier_mt_supplier_esg_social_reason_outbound
  • - infa360databricks_supplier_mt_supplier_esg_sustain_classification_outbound
  • - infa360databricks_supplier_mt_supplier_executiveMembers_outbound
  • - infa360databricks_supplier_mt_supplier_financial_outbound
  • - infa360databricks_supplier_mt_supplier_identifier_outbound
  • - infa360databricks_supplier_mt_supplier_insurance_outbound
  • - infa360databricks_supplier_mt_supplier_phone_outbound
  • - infa360databricks_supplier_mt_supplier_reference_outbound
  • - infa360databricks_supplier_mt_supplier_risk_question_outbound
  • - infa360databricks_supplier_mt_supplier_root_outbound
  • - infa360databricks_supplier_mt_supplier_segment_outbound
  • - infa360databricks_supplier_mt_supplier_socialMedia_outbound
  • - infa360databricks_supplier_mt_supplier_sourcing_manager_outbound
  • - infa360databricks_supplier_mt_supplier_stock_stg_outbound
  • - infa360databricks_supplier_mt_supplier_tax_outbound
  • - infa360databricks_supplier_m_supplier_address_outbound
  • - infa360databricks_supplier_m_supplier_alerts_outbound
  • - infa360databricks_supplier_m_supplier_altName_outbound
  • - infa360databricks_supplier_m_supplier_bankdetails_outbound
  • - infa360databricks_supplier_m_supplier_contract_outbound
  • - infa360databricks_supplier_m_supplier_diversity_outbound
  • - infa360databricks_supplier_m_supplier_document_outbound
  • - infa360databricks_supplier_m_supplier_email_outbound
  • - infa360databricks_supplier_m_supplier_esg_environmental_reason_outbound
  • - infa360databricks_supplier_m_supplier_esg_governance_reason_outbound
  • - infa360databricks_supplier_m_supplier_esg_rating_sustainalytics_outbound
  • - infa360databricks_supplier_m_supplier_esg_ratingdnb_outbound
  • - infa360databricks_supplier_m_supplier_esg_social_reason_outbound
  • - infa360databricks_supplier_m_supplier_esg_sustain_classification_outbound
  • - infa360databricks_supplier_m_supplier_executiveMembers_outbound
  • - infa360databricks_supplier_m_supplier_financial_outbound
  • - infa360databricks_supplier_m_supplier_identifier_outbound
  • - infa360databricks_supplier_m_supplier_insurance_outbound
  • - infa360databricks_supplier_m_supplier_phone_outbound
  • - infa360databricks_supplier_m_supplier_reference_outbound
  • - infa360databricks_supplier_m_supplier_risk_question_outbound
  • - infa360databricks_supplier_m_supplier_root_outbound
  • - infa360databricks_supplier_m_supplier_segment_outbound
  • - infa360databricks_supplier_m_supplier_socialMedia_outbound
  • - infa360databricks_supplier_m_supplier_sourcing_manager_outbound
  • - infa360databricks_supplier_m_supplier_stock_stg_outbound
  • - infa360databricks_supplier_m_supplier_tax_outbound
Exports supplier data from Supplier 360 SaaS to the staging tables in Databricks.
infa360databricks_supplier_egress_supplier_xref_outbound
infa360databricks_supplier_tf_supplier_xref_outbound
  • - infa360databricks_supplier_mt_supplier_xref_outbound
  • - infa360databricks_supplier_m_supplier_xref_outbound
Exports supplier data from Supplier 360 SaaS to the staging tables in Databricks.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish supplier data from the staging tables into the analytical tables in Databricks:
Taskflow
Mapping Task
Mapping
Description
infa360databricks_tf_databricks_supplier_stage_databricks_retail_analytics
  • - infa360databricks_mt_databricks_stage_databricks_tbl_esg_score_databricks_governance_reason_dim
  • - infa360databricks_mt_databricks_stage_databricks_tbl_esg_score_dnb_dim
  • - infa360databricks_mt_databricks_stage_databricks_tbl_esg_score_dnb_environmental_reason_dim
  • - infa360databricks_mt_databricks_stage_databricks_tbl_esg_score_dnb_social_reason_dim
  • - infa360databricks_mt_databricks_stage_databricks_tbl_supplier_dim
  • - infa360databricks_mt_databricks_supplier_stage_databricks_tbl_address_dim
  • - infa360databricks_mt_databricks_supplier_stage_databricks_tbl_email_dim
  • - infa360databricks_mt_databricks_supplier_stage_databricks_tbl_phone_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_esg_score_databricks_governance_reason_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_esg_score_dnb_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_esg_score_dnb_environmental_reason_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_esg_score_dnb_social_reason_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_supplier_dim
  • - infa360databricks_m_databricks_supplier_stage_databricks_tbl_address_dim
  • - infa360databricks_m_databricks_supplier_stage_databricks_tbl_email_dim
  • - infa360databricks_m_databricks_supplier_stage_databricks_tbl_phone_dim
Publishes supplier data from the staging tables into the analytical dimension tables in Databricks.

Assets for product data

Use predefined egress jobs to export master data from Product 360 SaaS to the staging schema in Databricks. Then use the predefined Data Integration taskflow to publish data from the staging tables into the analytical tables in Databricks.
The following table lists the predefined egress jobs and their dependent assets to export master data from Product 360 SaaS to the staging tables in Databricks:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360databricks_product_egress_category_outbound
infa360databricks_product_tf_category_outbound
  • - infa360databricks_product_mt_category_description_outbound
  • - infa360databricks_product_mt_category_keywords_outbound
  • - infa360databricks_product_mt_category_root_outbound
  • - infa360databricks_product_mt_relation_category_to_category_outbound
  • - infa360databricks_product_m_category_description_outbound
  • - infa360databricks_product_m_category_keywords_outbound
  • - infa360databricks_product_m_category_root_outbound
  • - infa360databricks_product_m_relation_category_to_category_outbound
Exports product data from Product 360 SaaS to the staging tables in Databricks.
infa360databricks_product_egress_classification_outbound
infa360databricks_product_tf_classification_outbound
  • - infa360databricks_product_mt_classification_outbound
  • - infa360databricks_product_mt_relation_category_to_classification_outbound
  • - infa360databricks_product_m_classification_outbound
  • - infa360databricks_product_m_relation_category_to_classification_outbound
Exports product data from Product 360 SaaS to the staging tables in Databricks.
infa360databricks_product_egress_item_outbound
infa360databricks_product_tf_item_outbound
  • - infa360databricks_product_mt_item_description_outbound
  • - infa360databricks_product_mt_item_keyword_outbound
  • - infa360databricks_product_mt_item_metainfo_outbound
  • - infa360databricks_product_mt_item_productHighlight_outbound
  • - infa360databricks_product_mt_item_root_outbound
  • - infa360databricks_product_mt_item_sellPrice_outbound
  • - infa360databricks_product_mt_item_tags_outbound
  • - infa360databricks_product_m_item_description_outbound
  • - infa360databricks_product_m_item_keyword_outbound
  • - infa360databricks_product_m_item_metainfo_outbound
  • - infa360databricks_product_m_item_productHighlight_outbound
  • - infa360databricks_product_m_item_root_outbound
  • - infa360databricks_product_m_item_sellPrice_outbound
  • - infa360databricks_product_m_item_tags_outbound
Exports product data from Product 360 SaaS to the staging tables in Databricks.
infa360databricks_product_egress_item_xref_outbound
infa360databricks_product_tf_item_xref_outbound
  • - infa360databricks_product_mt_item_xref_outbound
  • - infa360databricks_product_m_item_xref_outbound
Exports product data from Product 360 SaaS to the staging tables in Databricks.
infa360databricks_product_egress_item_relation_outbound
infa360databricks_product_tf_relation_item_to_category_outbound
  • - infa360databricks_product_mt_relation_item_to_category_outbound
  • - infa360databricks_product_m_relation_item_to_category_outbound
Exports product data from Product 360 SaaS to the staging tables in Databricks.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish product data from the staging tables into the analytical tables in Databricks:
Taskflow
Mapping Task
Mapping
Description
infa360databricks_tf_databricks_item_stage_databricks_retail_analytics
infa360databricks_mt_databricks_stage_databricks_tbl_item_dim
infa360databricks_m_databricks_stage_databricks_tbl_item_dim
Publishes product data from the staging tables into the analytical tables in Databricks.

Assets for location data

Use predefined egress jobs to export master data from Multidomain MDM SaaS to the staging schema in Databricks. Then use the predefined Data Integration taskflow to publish data from the staging tables into the analytical tables in Databricks.
The following table lists the predefined egress jobs and their dependent assets to export master data from Multidomain MDM SaaS to the staging tables in Databricks:
Job Name
Taskflow
Mapping Task
Mapping
Description
infa360databricks_egress_multidomain_location_outbound
infa360databricks_multidomain_tf_location_outbound
  • - infa360databricks_multidomain_mt_location_address_outbound
  • - infa360databricks_multidomain_mt_location_altName_outbound
  • - infa360databricks_multidomain_mt_location_coordinates_outbound
  • - infa360databricks_multidomain_mt_location_email_outbound
  • - infa360databricks_multidomain_mt_location_geoloc_outbound
  • - infa360databricks_multidomain_mt_location_identifier_outbound
  • - infa360databricks_multidomain_mt_location_indicator_outbound
  • - infa360databricks_multidomain_mt_location_operatingHours_outbound
  • - infa360databricks_multidomain_mt_location_operatingHoursException_outbound
  • - infa360databricks_multidomain_mt_location_phone_outbound
  • - infa360databricks_multidomain_mt_location_positions_outbound
  • - infa360databricks_multidomain_mt_location_root_outbound
  • - infa360databricks_multidomain_mt_location_status_outbound
  • - infa360databricks_multidomain_m_location_address_outbound
  • - infa360databricks_multidomain_m_location_altName_outbound
  • - infa360databricks_multidomain_m_location_coordinates_outbound
  • - infa360databricks_multidomain_m_location_email_outbound
  • - infa360databricks_multidomain_m_location_geoloc_outbound
  • - infa360databricks_multidomain_m_location_identifier_outbound
  • - infa360databricks_multidomain_m_location_indicator_outbound
  • - infa360databricks_multidomain_m_location_operatingHours_outbound
  • - infa360databricks_multidomain_m_location_operatingHoursException_outbound
  • - infa360databricks_multidomain_m_location_phone_outbound
  • - infa360databricks_multidomain_m_location_positions_outbound
  • - infa360databricks_multidomain_m_location_root_outbound
  • - infa360databricks_multidomain_m_location_status_outbound
Exports location data from Multidomain MDM SaaS to the staging tables in Databricks.
infa360databricks_egress_multidomain_location_xref_outbound
infa360databricks_multidomain_tf_location_xref_outbound
  • - infa360databricks_multidomain_mt_location_xref_outbound
  • - infa360databricks_multidomain_m_location_xref_outbound
Exports location data from Multidomain MDM SaaS to the staging tables in Databricks.
The following table lists the predefined taskflow, mapping tasks, and mappings to publish location data from the staging tables into the analytical tables in Databricks:
Taskflow
Mapping Task
Mapping
Description
infa360databricks_tf_databricks_location_stage_databricks_retail_analytics
  • - infa360databricks_mt_databricks_location_stage_databricks_tbl_address_dim
  • - infa360databricks_mt_databricks_location_stage_databricks_tbl_email_dim
  • - infa360databricks_mt_databricks_location_stage_databricks_tbl_phone_dim
  • - infa360databricks_mt_databricks_stage_databricks_tbl_location_dim
  • - infa360databricks_m_databricks_location_stage_databricks_tbl_address_dim
  • - infa360databricks_m_databricks_location_stage_databricks_tbl_email_dim
  • - infa360databricks_m_databricks_location_stage_databricks_tbl_phone_dim
  • - infa360databricks_m_databricks_stage_databricks_tbl_location_dim
Publishes location data from the staging tables into the analytical dimension tables in Databricks.