Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

After defining the Source and the Destination of the Template, next step is to map the elements of the Source with the Destination.  

This screen appears only if you have selected Yes (Convert) data format while providing the definition of the Template.

  1. Select the mapping from the Select Mapping drop-down list and click Next. You can either use an existing mapping (created in the Developer's Studio) or create a new one.



    Click  to create a new mapping and do the following:

    1.  Provide the name of the mapping.

      You can also select the mapping from the Mapping Suggestion(s) drop-down list. This drop-down list will list all the existing mapping for similar data formats. Click Yes, when prompted to overwrite the existing mapping.

      Click Switch to Advanced Mapping to create the mapping using Developer's Studio Data Mapper.

    2. Create the mapping between the elements of the Source and the Destination. Mapping can be done either automatically or manually. 

      To map the elements manually, click a Source element first and then Destination element with which you want to map the Source element. This maps the elements and is shown with a green dot.

      Click  to map the Source and Destination elements automatically. You can map the elements automatically if the Source and Destination element names and hierarchy are exactly the same.

      You can perform the following operations while mapping the elements. 

       

       Mapping Functions

      You can also map the Source and Destination elements using /wiki/spaces/AC2/pages/656554. If you want to map the elements using mapping functions then click  > Expression and Variables.  

       

      Business applications accept specific values in their reference elements at the destination. When you click Expression and Variables for a reference element of such applications, Reference Selection window appears. You may use Reference and/or Lookup functions to locate the reference values using the values of their corresponding elements. 

      On the Expression Builder window, map the elements using the mapping functions displayed on the left menu.

       Copying Expression

      You can also copy the expression applied to a particular destination element and use it in another destination element. To copy the expression, click  > Copy Expression. The expression will get copied.

      Use the copied expression to another destination element by clicking  > Paste Expression. The same expression will get applied to the element.

      By default, Copy Expression and Paste Expression options are disabled. Copy Expression will get enabled if the expression is applied to a particular element. Paste Expression will get enabled after you copy the expression.

       Cloning a Node

      Cloning means generating the replica of the element. You can make a clone of a particular element or all destination elements. To clone an element or parent node:

      1. Click  > Clone Node.


         

      2. On the Clone Options window, provide the number of clones you need (maximum 300).
      3. Select Include Mapping check box to include mapping with the element.

      4. Click Create Clone(s).



        This creates the specified number of clones of the element. The element which is created using cloning is displayed with the suffix [1] after its name. Subsequent clones will have the suffix [2] and so on. For instance, if you make two clones of Name field then Name[1] and Name[2] will get cloned at the destination.

        You can delete the clone by clicking   > Delete Clone. You can delete the mapping between the elements by clicking  > Delete.

       Adding Value Map

      Use this feature to map the values of an element at the Destination application. For instance, at source, Name element has John, Smith, Daniel, and Michael as values. You want to map John and Smith with Walter and Robert as the values in the Name element at the destination. This can be done using Value Map feature. Click Value Map to map the values.

      On the Value Map window, provide a unique value map name. Type the values that you want to map in the Value and Map.



      For other values (Daniel and Micheal), either provide the default value or click Pick From Source to map the same value as appearing at Source. If you provide the default value, then the same value will be mapped to other values. For instance, if you provide Paul as the default value, then Paul will be mapped to Daniel and Micheal at the destination.

      You can also import the values using CSV file by clicking Import CSV. On the Open dialog box, browse to and select the CSV file.

      After you have created the value map, apply this to the destination element. To apply the value map:

      1. Click  > Expression and Variables.

      2. On the Expression Builder window, scroll left menu to the Value Map section, and then click the value map to apply.

        The Value Map section will also list all the value maps of Project type created in the Developer's Studio.
      3. In the Expression tab, place the cursor between the brackets, click the field from the Source, and then click Save.



        This applies the value map to the element.

       Adding Variables

      You can create a variable, assign a value, and use it while mapping the Source and Destination element. The value of a variable can be any constant, /wiki/spaces/AC2/pages/656554, or any source element.

      All the variables are listed in the Variables section in the Expression Builder window. The variables created for a particular destination element are listed in the Current category whereas variables created for the Record node are listed in the Parent category.

      To create a variable for a particular destination element or parent node:

      1. Click  > Expression and Variables. 



      2. On the Expression Builder window, click Variable tab. You can also create a variable by clicking on the Variables option from the left pane.



      3. Type a unique variable name.
      4. Type the value of a variable. The value can be any source element, any mapping function, or any constant. The following examples demonstrate how you can assign a value to a variable.

        Assigning a constant value to a variable
        Type a constant value in the box. Ensure that you have enclosed the constant value in a single quote.



        Assigning a source element as a value to a variable
        Click a field that you want to assign to the variable from the Source.



        Assigning a mapping function as a value to a variable
        Click a mapping function from the left menu and then click a field from the Source, if required.


      5. Click to add any additional comments related to the variable.
      6. Click Add Variable. This creates a variable and a suffix (LV) is displayed next to the element.



        All the variables created for a parent node or child node will get listed in the Variables section.



      7. After creating a variable, map it to an element by clicking  > Expression and Variables. 
      8. Click the variable from the Variables section.


         

        You can also apply a mapping function using a variable.
      9. Click Save.

        This maps the variable to the destination element.

       Applying Filter

      You can filter the elements from appearing in the target mapping. By filtering the elements, the values of the filtered element will not appear in the target mapping.

      You can filter both mapped and unmapped elements and also a single element or all elements of a node.

      To filter a single element or parent node:

      1. Click  > Apply Filter.

         

      2. This filters the selected element from the target mapping. The values of the filtered element (Emp_id) will not appear in the target mapping. Once the filter is applied to the element, a suffix (FL) is displayed next to the element.

       

      To filter all unmapped elements:

      1. Clickto filter all unmapped elements.
      2. On the Mapping Settings window, click Output from the left menu and then click Filter Unmapped Elements.
      3. Click Save.



        This applies the filter to all the unmapped elements.

       Indenting Mapping Output

      Indentation enables a clearer view of the mapping output. You can indent mapping output to give a structured display, thus improving readability. By default, you will get the indented mapping output, however, you can disable the indentation. Disabling the indentation will increase the mapping performance and size.

      To disable the indentation:

      1. Click .
      2. On the Mapping Settings window, click Output from the left menu and then clear Indent Output XML.
      3. Click Save.

      This disables the indentation.

       Adding Namespace

      Namespaceprovides a simple method for qualifying element and attributes names used in Extensible Markup Language (XML) documents by associating them with namespaces identified by URI references.

      You can add a namespace URL or namespace prefix while mapping the Source and Destination elements. Note that you can add a namespace prefix only in XML schema or if you have selected SOAP application at Destination.

      Namespace URLs

      To add a namespace URL:

      1. Click .
      2. On the Mapping Settings window, click Namespace from the left menu.



      3. Click Add Row.
      4. Type the namespace URL in the following format in the Namespace text box.  
        xmlns:<namepsace_name>="URL"
        where,
                  <namespace_name> is a unique namespace name.
                  <URL> is the URL that you want to set in the specified namespace name.
        for example, xmlns:samplenamespace="http://exslt.org/math"



      5. Click Add Row to add more namespaces.

      6. Click Save.

        You can delete a namespace by moving the mouse pointer on the namespace and then clicking . Click Yes, when prompted to confirm.

        You can edit a namespace by moving the mouse pointer on the namespace and then clicking .

      Namespace Prefix

      To add a namespace prefix:

      1. Click to the child node or parent node.

      2. Click Add Namespace Prefix.

        This option appears only for XML schema or if you have selected SOAP application at Destination.

      3. On the Namespace Prefix window, type the prefix name.

         

      4. Click Include Child Node(s) check box to apply the namespace prefix to all the child elements. This option is disabled if you are adding namespace prefix to the child element.

      5. Click Include Attribute(s) check box to add the namespace prefix to all the attributes elements.

      6. Click Save.

      7. After you have added a namespace prefix to the elements, a suffix (NS-<namespace_name>) is displayed next to the element.

       Filtering Empty Elements

      You can filter the empty elements from appearing in the output mapping XML by clicking Filter Empty Elements check box. On selecting thecheck box, the output mapping XML will not have empty elements; thus increasing mapping size and performance.

      To filter empty elements:

      1. Click .
      2. On the Mapping Settings window, click Output from the left menu and then click Filter Empty Elements.



        This applies a filter to the empty elements.

        You can also configure this check box for all the mappings through the abpm.dataMapper.filterEmptyElements property in the server-configure.properties file (.../<AdeptiaInstallFolder>/AdeptiaServer/ServerKernel/etc folder). If the value of this property is set to yes then Filter Empty Elements check box is selected by default. You don't need to configure the option for every mapping.
       Mapping Streaming

      Streaming processes files by streaming the part of a file rather than loading the whole file into memory. You need to enable streaming to process large size file while mapping Source and Destination elements but before enabling you must follow some /wiki/spaces/AC2/pages/659006.

       

      Prerequisites

      Ensure you have the License that supports Streaming in Adeptia Connect.

      Streaming is available with the new installer of Adeptia Connect v2.9 and onwards. However, existing customer (on version 2.7 and older) would require to upgrade the patch to v2.9 to have this feature. After upgrading to or installing the latest version, you should enable the streaming.

      Enabling Streaming

      Changing Saxonica jar name

      To enable the streaming, customers will have to change the jar name manually. Following are the steps to change the jar name.

      1. Go to ….Adeptia-installation-path\AdeptiaServer\ServerKernel\etc\launcher.properties
      2. In the launcher properties file search for JAR:SAXON.
      3. Rename old saxon9pe.jar (old jar name) to saxon9ee.jar (new jar name)
      4. Restart kernel and web runner.

      Handling Saxonica in v2.8

      With upgrade to AC 2.9, existing customers using AC v2.8 will be automatically rolled back to the older version (i.e. saxon9pe.jar) of Saxonica. If you want to use Streaming feature follow the steps mentioned above for changing the jar name.

      After you have upgraded Saxonica to ee version in latest version, you must run regression testing to ensure that all you’re existing mappings are working fine.

      Enable Streaming in Connect

      To enable streaming on Connect UI. Ensure that you have read the /wiki/spaces/AC2/pages/659006 before enabling it.

      1. Click .
      2. On the Mapping Settings window, click Streaming from the left menu and then click Enable XSL Streaming check box.

    3. Click Next to exit from the mapping.

  2. Provide the Documentation URL. This URL will have all the information related to the Template. 



  3. Click Save & Exit to save the Template.

    Next Step

    Activating a template

  • No labels