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.
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.
Double-click the profile to open it.
The profile opens in a tab.
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
.
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.
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.
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.
To run individual profile tasks, select a task and click
Run
.
To run multiple profile tasks, click
Run Multiple
.
The
Run Multiple
dialog box appears.
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.
All tasks are selected by default. Clear the tasks that you do not want to run and click