--- schema_version: "1" id: d13f4aa6c6bd4895984cac48f15f3e38b21464a2a745f39bfc4257b6e729747c title: Build an Omnistudio Data Mapper collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/os_build_data_mapper.md canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.os_build_data_mapper.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: ce884fd4c1c54f8d0e12331bedb4299ffbfa8f5cba88f11b3c6a9041067fa365 description: "To get, save, and modify Salesforce data, build Data Mappers with the basic configurations: Input source, queries, formulas, mappings of input and output data, and output destination. The available configurations depend on the type of Data Mapper that you’re building." products: - Omnistudio release: "264" --- # Build an Omnistudio Data Mapper To get, save, and modify Salesforce data, build Data Mappers with the basic configurations: Input source, queries, formulas, mappings of input and output data, and output destination. The available configurations depend on the type of Data Mapper that you’re building. - For input and output, select the format, or type, of the data, such as JSON, XML, or sObject. For custom data, you can use an Apex class to parse that data. - Use queries to define what objects and fields you’re extracting data from. In the Data Mapper Designer, use the Extract interface to select the data. - With formulas, you can modify the input data when needed. You can reuse formula results in other formulas or mappings within the Data Mapper. Each result is stored as a key-value pair: The formula result path defines the key and the formula defines the value. - With mapping, you connect the data you’ve extracted and modified with formulas to a structure for your output data. A Data Mapper Extract has all configurations available. The Data Mapper Transform and Load types don’t include queries because they’re not retrieving data from Salesforce objects. Instead, these types use data provided in a previous step, such as a Data Mapper Extract, an HTTP action in an Integration Procedure, or an Omniscript. Because a Data Mapper Turbo Extract is a simpler type, it doesn’t have formulas or mappings. ![A diagram shows each type of Data Mapper and its available configurations: Input, Query, Formulas, Mapping, and Output.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-omnistudio-264-0-0-production-enus/f526eaa8-ae05-487a-8944-4bb99b0b78ac/omnistudio/images/os-build-data-mapper.png) - **[Omnistudio Data Mapper Best Practices](https://help.salesforce.com/s/articleView?id=xcloud.os_dataraptor_best_practices_47412.htm&release=264.0.0&type=5)** To maximize the benefits of Data Mappers, follow the best practices whenever possible. - **[Configure Date and Time Settings in Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_omni_interaction_config.htm&release=264.0.0&type=5)** Configure the default date format within Omnistudio Data Mappers. - **[Environment Variables in Omnistudio Data Mappers and Integration Procedures](https://help.salesforce.com/s/articleView?id=xcloud.os_environment_variables_in_dataraptors_and_integration_procedures_47878.htm&release=264.0.0&type=5)** You can use environment variables to define Default Values and Filter Values, and in Formulas. - **[Inputs and Outputs for Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_inputs_outputs_for_data_mappers.htm&release=264.0.0&type=5)** The configuration of inputs and outputs in Salesforce Omnistudio Data Mappers is highly flexible. The primary data formats are JSON and XML with other options available. - **[Use Formulas in Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_use_formulas_in_dataraptors_47540.htm&release=264.0.0&type=5)** To add data to the output of a Data Mapper, define _formulas_. Several types of Data Mappers (Extract, Transform, and Load) support formulas. When you define a formula, you map its output to the output JSON (for extracts and transforms) or Salesforce object field (for loads). - **[Configure an Omnistudio Data Mapper Extract](https://help.salesforce.com/s/articleView?id=xcloud.os_define_the_initial_extraction_45906.htm&release=264.0.0&type=5)** Configure a Data Mapper Extract by specifying the object and filters. To enhance the performance of the Data Mapper Extract, you can define formulas, add fields to write data to, create mappings, and configure additional properties. - **[Configure a Data Mapper Turbo Extract](https://help.salesforce.com/s/articleView?id=xcloud.os_configure_a_dataraptor_turbo_extract_45667.htm&release=264.0.0&type=5)** To configure a Data Mapper Turbo Extract, specify the object type, filters, fields to extract, and options. - **[Configure an Omnistudio Data Mapper Load](https://help.salesforce.com/s/articleView?id=xcloud.os_object_field_mapping_47137.htm&release=264.0.0&type=5)** Configure a Data Mapper Load by specifying the object type and filters. To enhance the performance of the Data Mapper Load, you can define formulas, add fields to write data to, and configure additional properties. - **[Map Inputs and Outputs for Transformations](https://help.salesforce.com/s/articleView?id=xcloud.os_dataraptor_transform_data_mappings_46630.htm&release=264.0.0&type=5)** To map data from the input to the output, go to the Transform tab. If you're using the designer on a managed package, go to the Output tab. You can also handle null values, data types, caching, and list transforms. - **[Improving Data Mapper Performance with Caching](https://help.salesforce.com/s/articleView?id=xcloud.os_cache_for_dataraptors_and_integration_procedures_48057.htm&release=264.0.0&type=5)** Omnistudio offers multiple caching options to improve performance and minimize unnecessary data processing in Data Mappers. The two primary user-configurable caching types are Org Cache and Session Cache, which are available in the Data Mapper designer. These caching mechanisms are part of the Salesforce Platform Cache and are implemented through Scale Cache in Omnistudio with standard runtime. Each serves a distinct purpose and comes with specific configuration considerations.