You can run an enterprise discovery profile in multiple ways. You can run the profile from the Object Explorer view or from the Profiles tab in the Properties window. You can choose to run individual and multiple profile tasks that form a part of the enterprise discovery profile.
1. In the Object Explorer view, select the project or folder that contains the profile that you want to run.
To run a profile automatically, select Run enterprise discovery profile on finish in the New Enterprise Discovery wizard when you create the profile.
2. Double-click the profile to open it.
The profile opens in a tab.
3. In the Object Explorer view, right-click the profile and select Run Enterprise Discovery Profile.
Alternatively, you can select Profiles in the Properties window, select the profile name under the List of profiling tasks, and then click Run.
Note: When you run an enterprise discovery profile, you need to refresh the Model Repository Service before you can view the results. This step is required as the import of metadata for external connections happens in the Model repository. You need to refresh the Model Repository Service so that the Developer tool reflects the changes to the Model repository.
4. The Run dialog box appears. You can make changes to the global settings of the profile in this dialog box.
By default, the changes you make apply to the newly added data objects in the enterprise discovery profile.
5. To apply the changes to all the data object profile tasks and the system-generated foreign key profile task in the enterprise discovery profile, select Use global settings for current profiles.
The Developer tool updates all the data object profile tasks and the foreign key profile task based on the changed settings.
6. To run individual profile tasks, select a task and click Run.
7. To run multiple profile tasks, click Run Multiple.
The Run Multiple dialog box appears.
Tip: If the enterprise discovery results take a long time to load, you might want to update the statistics of the profiling warehouse database. Multiple enterprise discovery profile runs can result in significant changes to data volume and column values. When you update the statistics, the database runs an execution plan for the SQL queries based on the latest statistics and optimizes the database operations.
8. All tasks are selected by default. Clear the tasks that you do not want to run and click OK.