The field migration mapping screen allows you to configure source object sand fields to map into Salesforce.
NOTE: DataTools Pro is designed for mapping meta-data and not executing migration and movement of data between systems. Due to the wide range of source applications we opted to release DataTools Pro with a manual meta data import process as we look to build out an integrate new direct meta data connectors.
Features
- Click to Map– For every field you can click to map any field to a source object. View Adding a Source Object and Fields to view the step by step process.
- Edit – Edit function will allow you to edit each individual field Status, Logic and Notes.
- Object Refresh– The Object refresh button will fetch updates from Salesforce on demand. To reduce credit / API usage we do not auto-refresh the Salesforce schema.
- Launch Salesforce Object Manager – Will open the Salesforce object manager in a new window. The Salesforce object manager uses native Salesforce.com. Please check your permissions or work with you Salesforce admin to access this native Salesforce feature.
- Migration Navigation – Migrate to another Salesforce object using the dropdown or view a complete list of objects on the Migration Scorecard
Adding a Source Object and Fields to Map to Salesforce:
1. From the Migration Field Dictionary, select “Click to Map”
2. In the side properties window, to Add a new source object click the “+” button.
3. Enter the Source Data dropdown
4. Enter the Object Label
5. Enter the Object Identifier. We recommend using the exact object name that exists in your source application. This will help reduce the re-work for building your migration process (this value cannot be changed after creating the object)
6. Enter Object Description – Many times we use the object description for developer notes.
7. Click Create
Adding Source Object Fields for Migration:
Once you have defined the source object, you will need to import the column names and optional data types to help you map and track where your source data is coming from.
Note: You can always edit and add fields as you continue working on your migration project.
DataTools Pro uses a spreadsheet control to make it easy to copy, paste and edit your column meta data.
Field Name– You will want to use the exact field names your data team will use to query and migrate data
Data Type – DataTools Pro does not have any restrictions or controls on Data Type. The “data type” meta data will differ for source applications and may or may not map to Salesforce.
Note: DataTools Pro does not enforce data types for mapping currently.
