Create Transformation

Create Transformation

After you have registered the extractor and stored the client credentials, you can get started with data transformation.
After you have uploaded the data to the CDF project, you need to create a transformation in CDF.
Perform the following steps to create transformation:
  1. Navigate to your project in CDF and select
    Integrate
     >
    Transform Data
    .
    Select Transform Data
  2. On the Transform Data screen, click
    + Create
    .
    Select Create
  3. Provide a unique name for the transformation.
    Create Transformation
  4. Provide a unique external ID.
  5. Select a data set to limit access to the selected data set and click
    Next Step
    .
  6. In the
    Target data model
     list, select
    CDF resource types
     to ingest data.
    • If you're ingesting data into the Assets resource type, make sure a parent asset already exists in CDF.
    • If you're ingesting data into Sequence rows, specify the external ID for the sequence you want to write to. This defines the target schema.
    Create Transformation
  7. In the
    Target resource type
     list, select
    Assets
    .
  8. In the
    Action
     list, select
    Create or Update
    .  If you're updating existing data, you must specify how the transformation should set null values.
    • Select
      Keep existing values
       to not update existing data. This is the default setting.
    • Select
      Clear existing values
       to set existing values to null, for example, when a piece of equipment is removed for maintenance. Use this option to disassociate the asset from its parent in the asset hierarchy.
  9. Click
    Create
     to create the transformation. After you create a transformation, you need to select a source for data transformation.
    The Mapping editor is displayed. Mapping editor helps mapping source and target.
    Mapping Editor
  10. In the
    Mapping editor
    , select the source for transformation. Select the appropriate model, database name, and the table name.
  11. To map your source data and target, click
    Suggestions
     and select all that apply.
    Map Source Data
  12. After you select the suggestions, click
    Accept Selected
    . You can see the mappings.
    Now you are ready to run the transformation.
    Run Transformation
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.