Description:

How to create a Synchronization Package pulling data from multiple tables.

This will allow you to pull data from multiple tables in a database.

Resolution:

Option 1

Create a "View" in SQL Management Studio

1) Open SQL Sever Management Studio Express

2) Go to Databases |

| Views

3) Right click on Views and click New View

4) Select the tables (hold down CTRL to select multiple tables)

5) Click the Add button

6) Select which columns to pull data from within the tables

7) Righ click the tab and click Save View

8) Enter a view name

9) Open the ALM Web Console

10) Click on the Asset tab

11) Click on the Synchronization button

12) Click on Synchronization packages

13) Click New

14) Enter the Package Name, Asset or resource , ODBC (requires System DSN on ALM Server), DSN Name, SQL Username and Password

15) Type the name of the view you created in step 8

16) Click Mapping and choose the Source Column that matches the Destination Column where you want the data stored in ALM

17) Click on Matching and Select the Columns that will be compared to ensure that a new record is not created when an existing record contains matching data

18) Click the green check button to save the Synchronization Package

19) Click the Synchronization Package Name and click Run