This section provides detailed descriptions of new features
for server applications.
x
The Upload Wizard enables you to upload
files from your local machine to server application folders and
to load them into a DBMS for use in creating synonyms and reports.
You can then run a report with or without email, or schedule it.
The wizard enables you to:
- Upload files.
- Edit synonyms.
- Create cluster synonyms using dimensions and measures.
- Generate a test report.
- Run, submit with email, or schedule the report.
- Return to the console.
The Upload Wizard displays these steps on the ribbon and in the
navigation pane, as shown in the following image.
When you complete a task, the wizard automatically moves to the
next step.
x
Procedure: How to Use the Upload Wizard to Upload a File and Create a Synonym
-
From the
Web Console, click the Upload Wizard icon,
as shown in the following image.
The
Upload Wizard opens to the Upload pane, as shown in the following image.
-
Select a
type from the Upload Type drop-down menu.
The options are:
-
Leave
file in original format. This will copy the file to
the application folder.
-
Upload
into relational DBMS. This will upload the file into
your database.
If you choose Upload into
relational DBMS, you will need to provide the target
parameters, as shown in the following image.
-
Select a
configured adapter from the Adapter drop-down menu.
-
Select a
connection from the Connection drop-down menu.
-
Select a
load type from the Load Type drop-down menu.
The options are:
-
Insert
Records From Memory. This option speeds the loading
of the data target by inserting a block of rows at once. You can
set the row interval to commit or write transactions and the number
of records to load in a block.
-
Bulk Load
Utility Via a Disk File. This option uses database bulk
loaders to insert data into a target.
-
Enter the
full path and file name in the Upload file field,
or click the Browse button and navigate to
one.
-
Click Next.
The synonym creation screens will vary, depending on the
type of file uploaded.
-
Enter parameters
for the synonym, and click Create Synonym.
The synonym is created, as shown in the following screen.
-
Click Next.
The Edit Synonym pane opens.
-
If you do not want to edit the synonym(s) or create a
cluster synonym, you can click Create Test Report from
the ribbon or navigation pane.
You
can then run the report with email or schedule it to run once or
multiple times.
To exit the Upload Wizard, click Full Console.
x
Procedure: How to Use the Upload Wizard to Edit a Synonym
After
you have created synonym(s), the wizard moves to the Edit Synonym
step, as shown in the following image.
-
For a particular synonym, double-click Edit Synonym in
the Action column, or right-click it and select Edit.
The Quick Edit pane opens, as shown in the following image.
The Quick Edit pane
has three tabs:
- Metadata.
- Data.
- Key Management.
-
Make your edits on the applicable tab.
-
Click Next or click Cluster (Dimensions) on
the ribbon or in the navigation pane to move to the Cluster Synonym
step.
x
Procedure: How to Use the Upload Wizard to Create to a Cluster Synonym
You can create a cluster synonym with the Upload Wizard
using the same process as the Metadata Wizard.
If
you do not want to create a Cluster Synonym, click Create
Test Report from the ribbon or navigation pane.
x
Procedure: How to Use the Upload Wizard Create a Test Report
If
you did not create a cluster synonym, click Create Test
Report from the ribbon or navigation pane.
The
Select Synonym for report pane opens.
-
Enter the full path to the synonym or click the
File Picker (...) and navigate to one.
-
Click Next.
The Select Report Measures pane opens, as shown in the
following image.
-
Select fields from the left side, use the arrow key to
move them to the right, and click Next.
The Select Report Rows pane opens, as shown in the following
image.
-
Select fields from the left side, use the arrow key to
move them to the right, and click Next.
The Select Report Columns pane opens, as shown in the following image.
-
Select fields from the left side, use the arrow key to
move them to the right, and click Next.
The Reporting Wizard completed pane opens, as shown in
the following image.
-
Click Run to run the procedure.
The resulting report is displayed, as shown in the following
image.
-
Click Next (Scheduler and E-Mail) to
submit the procedure with email or schedule it.
x
Procedure: How to Use the Upload Wizard to Run, Email, or Schedule a Procedure
After you have created a test report with the Upload Wizard,
you can run the procedure, submit it to run with email, or schedule
it.
-
From The
Reporting Wizard completed pane, click Next (Scheduler
and E-Mail) or click Run, E-Mail, Schedule from
the ribbon or navigation pane.
The Run, E-Mail, Schedule page opens, as shown in the following image.
-
Click Run to
run the report.
-
Click Submit
with E-Mail to submit the procedure and specify start
or completion email.
The Submit procedure with E-Mail pane opens.
-
To schedule the procedure, click Manage Schedule
and Email.
To exit the Upload Wizard, click Full Console.
xStoring Applications in an SQL Database
You can now store the contents of an application folder
in an SQL database. You must first create a new SQL Repository.
After that, this feature is available when you create a new application
folder.
Warning: It is advisable to create a separate
SQL Connection to use in creating an SQL Repository. If an existing
SQL Connection is used, only Server Administrators or users with
WSCFG privileges will be able to use the synonyms from this SQL
connection in the application. This provides protection for the
SQL Repository, preventing unauthorized users (without administrator
privileges) from accessing the contents of the SQL Repository through
a synonym.
x
Procedure: How to Create an SQL Repository to Store Applications
You
must have an adapter connection configured to an SQL database.
-
From the
Applications page, right-click the Application Directories folder
in the navigation pane, and select Manage SQL Repository,
and then Create New, as shown in the following
image.
The
Create New SQL Repository page opens, as shown in the following
image.
-
Select a
configured adapter from the Adapter drop-down menu.
-
Select a connection from the Connection drop-down menu.
-
Enter a
prefix in the Prefix field.
-
Optionally,
select the Overwrite existing repository tables and their
synonyms check box.
-
Click OK.
A warning message is displayed, as shown in the following
image.
-
Click OK.
Two SQL Repository catalog tables are created with this
connection, as shown in the following image.
The
tables are:
prefixIOHFILETABLE
prefixIOHRECORDTABLE
Two
synonyms describing the catalog tables are also created in EDACONF/catalog/IOH.
-
Optionally,
click Create New Application.
The Create New Application page opens, as shown in the
following image.
x
Procedure: How to Create an Application With SQL Content
You
must have created an SQL Repository.
-
From the
Applications page, right-click the Application Directories folder
in the navigation pane, select New, then Application
Directory, as shown in the following image.
The
Create New Application page opens.
-
Select New
Application under repository - DBMS (Connection name) from
the Application Type drop-down menu, as shown in the following image.
Note: The
choices will include the repository, adapter type, and connection
name. In this example, they are the bks repository, Adapter for
Microsoft SQL Server, and CON01 connection.
-
Enter a
name in the Application Name field.
-
Optionally,
select the Recreate application if exists check
box.
Warning: Choosing this option will overwrite the
existing application and any content in it.
-
Optionally, enter a description in the corresponding
field.
-
Optionally,
deselect the Add directory to APPPATH check
box. The application is added to the APPPATH by default.
-
Select a
position for the application from the Position in APPPATH drop-down
menu. The choices are Last or First.
The default value is Last.
-
Select a
profile from the Profile drop-down menu.
For server administrators, the default value is edaprof.
For non-administrators, their user profile is the default value.
-
Click OK.
The
application is added to the navigation tree. You can now use this
application to store procedures, synonyms, data files, and other
content.
xUsing an SQL Repository to Store Home Applications
Home applications can now be stored in an SQL Repository.
You must first create an SQL Repository, as described in Storing Applications in an SQL Database.
x
Procedure: How to Store Home Applications in an SQL Repository
You must first create an SQL Repository.
-
From the Applications page, right-click the Application
Directories folder in the navigation pane, and select Application
Settings, as shown in the following image.
The
Application Settings page open, as shown in the following image.
-
Click the
selector button (...) next to the homeapps field.
The Select physical location dialog box opens.
-
Select SQL
Repository from the drop-down menu, as shown in the
following image.
-
Select a
subfolder, and click OK.
The subfolder is entered in the homeapps field,
as shown in the following image.
-
Click Save and restart Server.