Adding connections

You can add a connection in the transformation file by clicking on the 'View' tab (if its not already selected)

and then right clicking on the Database Connections and select New. You will get a window on which to enter your connection settings. In our example we need two connections:

1. a connection to the CiviCRM database to extract data from
2. a connection to the datawarehouse to load data to

There is only one detailed window here as I assume you will catch the general idea.