Topics: |
The SQL Wizard (also known as the Connect to Data Wizard) leads you through the creation of metadata. The Upload Wizard leads you through the process of uploading a data file from your local machine to the server. Quick Copy lets you load a new file, replace an existing file, or append a new file to an existing file.
After each process is complete, the wizard lets you run or save a test query and schedule or email the final output.
Many of the options available for the metadata creation and upload processes are shared with the Data Assist tool, described in Using Data Assist.
To upload an image file to an application, right-click the application, point to New, and click Upload Image Files.
How to: |
The SQL Wizard provides a step-by-step process for connecting to data, creating a summary table or cluster synonym and running a report. It can be used to create metadata for different types of data sources. Some of options and parameters vary depending on the type of data source. The wizard enables you to:
The SQL Wizard displays these steps as a menu, as shown in the following image.
When you complete a task, the wizard automatically moves to the next step.
To exit the wizard and return to the full console, click Full Console.
The SQL Wizard opens, as shown in the following image.
Note: You can click any of the column headings to sort the available adapters.
The Add Adapter to Configuration pane opens. Enter the parameters for the specific adapter and click Configure. For information on the parameters, see the Adapter Administration manual.
The Add Connection page opens. Enter the parameters for the specific adapter and click Configure. For information on the parameters, see the Adapter Administration manual.
Note: You can click any of the column headings to sort the available connections.
The Change Connect Parameters page opens. Change the parameters for the specific connection and click Configure.
After completing the Connection step, the wizard moves to the Import Metadata step where you can create one or more synonyms.
The Select connection to create synonyms page opens, as shown in the following image.
Note: You can click the Adapter or Connection column to sort the available adapters.
The Select Synonym Candidates pane opens.
For additional information on the parameters, see the Adapter Administration manual.
The Create Synonym page opens.
You can select or enter values for:
The synonyms are created in the application directory, as indicated on the Create Synonym Status page.
For more information about synonym creation parameters, see the chapter for your adapter in the Adapter Administration manual.
The wizard moves to the Edit Metadata step.
After completing the Import Metadata step, the wizard moves to the Edit Metadata step. This step creates a BV+ logical view in the synonym using the Business View pane. For information about BV+, see Business View Plus (BV+).
The Edit Metadata page opens, as shown in the following image.
All of the options are described in Wizard Metadata Screen Reference.
The Save As dialog box opens.
The Test Query pane opens.
The Test Query page has three panes, as shown in the following image.
The left pane lists the metadata available for the query. The right pane has categories in which you can place the data for summation, sorting, and filtering.
The ribbon provides Undo and Redo actions.
You can generate the query output:
You can use the Load Options button to specify the target adapter and table, whether to load into a new table using various techniques or to append or merge to an existing table, bulk load (if available), and the application for the target synonym.
If you clicked Save and Next, the Save As dialog box opens. Assign a name for the query, and click OK.
The Run, E-Mail, Schedule page opens
If you selected Run, the query runs and the results display in the output pane.
The Run, E-Mail, Schedule pane opens, as shown in the following image.
The Submit procedure with E-Mail pane opens, as shown in the following image.
Fill in the appropriate email fields for the email options you want.
The Manage Schedule and E-Mail for procedure pane opens, as shown in the following image.
For information on email and scheduling options, see Sending an E-mail Notification for a Procedure and Scheduling a Procedure.
WebFOCUS | |
Feedback |