Connecting a mapping to a physical file so that files can be produced for other processes is a tortuous process. Running with multiple configurations in OWB allows all of the location and configuration detail to be setup in OWB.
OWB allows you to share locations between configurations. Thus a physical directory can be reused in your DEV TEST and PROD environments.
1. Create a location in the Files section of the Locations navigator. Ensure that the OS account that will be used to read the data can actually read the physical directory.
2. Make the location available (in Data Locations) in the relevant Control Center in the Locations Navigator.
3. Make the location in the Data Locations section of the relevant Module in your project in the Project Navigator. i.e. Edit the module and move the location into the Selected Locations list in the Data Locations section.
4. Configure the module to use the relevant location. The location is configured in the Identification section of the configuration.
The results of this process need to be deployed in Control Center.
Open the Control Center where the location should appear under the project container.
5. Register the location. Right click on the location under the project container and select the Register option.
6. Deploy the Connector. The reference to the files location is called a connector in Control Center. Find and select the location within the relevant database and deploy it by selecting the Create option and invoking the Deploy action. This will create a directory object in the Oracle database.
7. Deploy and execute the package that references the location. If this fails then it may be that the service account, that the Oracle database is running under, does not have permissions to the OS share or directory.
Simples!
Making a change to a location, such as changing a UNC path, requires that it is Unregistered in all of the Control Centers that it has been registered in. If you Edit the Location in the Locations navigator you will see a Registration view that shows all of the control centers where it has been registered.
Leave a Comment so far
Leave a comment
