Data transformation options in Network
Transformation rules vs Transformation Queries
Source subscriptions (Model map and NEX rules)
-
Network Expression (NEX) rules - These rules can be applied to source subscriptions and data model fields.
-
Source subscriptions - Apply to specific stages of the data load to process data as it's loaded into Network.
-
Data model fields -
-
-
Transformation Queries - Pre-process data before loading it into Network or post-process data before exporting it to downstream systems.
Example: Combine the data from the individual .csv object files from a target subscription into a single file so it can be exported to downstream systems.
-
Transformation Rules - Change field values for specific source systems before records are exported to downstream systems.
Example: Change the address status to Inactive for all mailing addresses for the CRM source system so mailing addresses do not display in Veeva CRM.
| Feature | Source Subscription
Model Map + NEX Rules |
Fields NEX Rules |
Transformation Queries | Transformation Rules |
|---|---|---|---|---|
| Data Loading | Yes | Yes | Yes | No |
| Data Exporting | No | No | Yes | Yes |
| API Retrieve/Search Results
(Records in Network instance) |
No | No | No | Yes |
| API Retrieve/Search Results
(Records in OpenData instance) |
No | Yes | No | Yes |
| Network Profile/Search Results
(Records in Network instance) |
No | No | No | No |
| Network Profile/Search Results
(Records in OpenData instance) |
No | No | No | No |
| Network Search (find records) |
No | No | No | No |