Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

Data Mapping with Workflow Solution

Created: 05 Jun 2009 • Updated: 09 Sep 2010
ChrisBern's picture
0 0 Votes
Login to vote

This 15-minute video helps demonstrate Workflow Solution's ability to map data from one data source to another.  Specifically, the example in this video reads in a list of software titles (and their associated prices) from a database table.  The end-user is then able to choose which software items he or she is interested in procuring.  Finally, we take the selected items, plus some additional information that was derived from the process (their username), and write it all out to a second and separate database table.  The key element here is to be able to map data from one source into a differently-structured second location, and the Workflow mapping components help us to do that quickly and easily.

Keywords:  SQL, Identity, Primary Key, Get Current User, Create Integration Library, Table Generator, Import Components, Grid, ASCII merge label, Multiple Value Mapping, Single Value Mapping