Create a Connector

Introduction:

This procedure describes how a Connector is entered into OWB. This is a Database Link between two Oracle Modules. While these can be created in OWB, any maintenance, including dropping them, is done directly on the database.

Aim:

Create a Connector in OWB.

Requirements:

At least two Oracle Modules have been created in OWB.

Procedure:

• Log on to OWB.
• Open a project.
• Expand 'Databases'
• Expand 'Oracle'
• Expand 'Locations'
• Right-click the Module Location that will own the Connector, i.e. the 'from' end.
  
• -Create Connector-
• Welcome:
• [Next]
• Name:
  
• Name: Something that informs you about its function but keep this short. Names approaching 30 characters can cause problems when debugging mappings. e.g. for a Connector from whs to ctl; WHS_CTL.
• Description: A description.
• [Next]
  
• Details:
• Database: -the 'to' end-
• [Next]
• [Finish]
  

Testing:

• A new connector appears under the 'from' end Location.
  
• Right-click the new Connector.
• -Validate...-
• This should result in the message; 'Validation completed successfully.'