Copying Connections

Once you have created a source or target connection in the Management Center, you can copy that connection, then edit its properties as needed. This option can save you time when you have multiple similar connections to create.  

To copy a database connection:

1. Expand the Metadata Explorer to display source and/or target connections.

2. Select a connection in the list (connections are displayed with an  icon.)

3. From the right mouse button menu, choose Copy Connection.

4. Select the location where you want to paste the new connection (either Sources or Targets.)

5. From the right mouse button menu, choose Paste Connection.

6. Modify the connection name by choosing Rename Connection from the right mouse button menu.

7. Add tables to the connection by choosing Select Tables from the right mouse button menu.

8. Modify other properties of the connection by choosing Connection Properties from the right mouse button menu.