Administration Portlets

From MT Marvelit
Revision as of 22:42, 6 August 2007 by Rmortensen (Talk | contribs)

Jump to: navigation, search

There are several administration portlets that control the functions of the DASH portal. To access them - login as an administrator and select Jetspeed Administration Portlets and click on MARVELit Admin


Admin1.jpg


Setting Defaults and Default Data Base Connection

Selecting MARVELit Administration displays a page for entering the MARVELit License Key, setting the default data source, setting data maps and adding/updating data sources.

The first entry is for entering the MARVELit License key. Copy and paste the key that you received during the trial or purchase registration process. DASH will not operate without a valid License Key entered into this field.

The next section is setting some default values and connections. The first selection Log Level tells DASH to write values to a log file on the portal server. The available selections are:

None: Nothing is written to the log file

Error: Only Errors are written

Warn: Only Warnings and Errors are written

Info: Only informational messages are written

Debug: Everything is written - including each sql query executed by every portlet

Obviously - setting the Log Level to Debug would be helpful in error correction. A production portal should have its log level set to None.

The second section is the Default Admin User Role - leave this value set to admin.

Data Edit Role - is the role that has edit capabilities over any data entered in the Editable Report Portlet. Admin and the role entered here will always have edit/delete capabilities regardless of which users have created data in those tables. See Editable Report Portlet for additional information.

Finally - specific connection values are stored for the Default Connection Database. This connection information is used by the system to access the database where the DASH specific tables are stored. Once this is established - it should not need to be changed unless their is a server migration event.


Admin2.jpg

Setting Data Maps

Data Maps enable MARVELit specific tables to be mapped (crossreferenced) to other tables at a client installation. There are X tables that need to be built as part of the installation. There tables will exist on the database of the default database connection in the previous section. To allow for flexibility in table and column naming conventions, a data map can be built. The MARVELit data names appear on the left - with the customizable name on the right. The installation defaults these entries to the MARVELit names. Only 1 table map is shown here. The following MARVELit Tables can be crossreferrenced:

Chart - contains information saved by the Chart Portlet

Chart Params - additional information saved by the Chart Portlet

Chart Type - contains information on available chart types

Editable Report - contains information on Editable Reports created

Editable Report Column - contains information on each column for every Editable Report

Meter Chart - contains information saved by the Meter Chart Portlet

Meter Chart Params - additional information saved by the Meter Chart Portlet

Meter Chart Range - additional information saved by the Meter Chart Portlet

Lever - contains information on each lever accessible

List - contains information used in report lists

List Items - contains specific values for a report list

Report Portlet - contains information saved by the Report Portlet

Report Portlet Params - additional information saved by the Report Portlet

Report Datasource - connection information for all datasources accessible by the portlets

Admin3.jpg

Complete entries for any(all) tables - when completed - click the Save Properties button after the Report Datasource data map.

Admin4.jpg

Adding Data Sources

Connection information for each data source accessible by the portlets must be added. Unlimited JDBC data sources can be added. The buttons next to each data source define actions available.

Save - update any values and click Save to write the new values to the Report Datasource table. Enter new data sources on a blank line and click Save to insert new data sources.

Delete - remove that data source from the Report Datasource table.

Admin5.jpg


The values for each data source are as follows:

Data Source Name - this is the name associated with the data source. It will be in a pull down menu in all portlets where a SQL query is entered. That pulldown determines which data source the SQL query accesses.

Driver - the name of the JDBC driver for the data source. The JDBC jar file should be stored in the /shared/lib directory.

URL/JNDI Name - the database URL/JNDI for the data source. Usually contains IP Address or name. Other parameters may be database specific. Enter a JNDI name if you have configured DASH to use connection pooling for this data source - see Using Connection Pools for additional information.

User Name - the user name to be used to logon to the data source.

Password - the password for the user name to be used to logon to the data source

is JNDI - click this check box if you are using JNDI connection pooling for this data source. Allentries are ignored except the Datasource Name and JNDI Name.

Adding JDBC Drivers to DASH

JDBC drivers for your desired databases need to be added in order to be used by DASH. These drivers need to be stored in the /shared/lib folder. Simply copy the desired drivers into that folder - than reference them in the data sources.

We have bundled the top three datasources into the application (MySQL, SQL Server, Oracle). Look in your /shared/lib folder. You should see these three items - plus several others:

  • mysql-connector-java-3.1.7-bin.jar (MySQL JDBC Driver)
  • sqljdbc.jar (MS SQL JDBC Driver)
  • classes12.jar (Oracle JDBC Driver)

If these files are not in your /shared/lib folder - you can download them from our web site Download JDBC Drivers, unzip and copy them into the /shared/lib folder.

Here are some example connection strings for each database:

Oracle

Driver Class Name = oracle.jdbc.driver.OracleDriver

URL = jdbc:oracle:thin:@10.211.55.3:1521:oracle (i.e. server = 10.211.55.3;port=1521;database=oracle)

MS SQL Server

Driver Class Name = com.microsoft.sqlserver.jdbc.SQLServerDriver

URL = jdbc:sqlserver://127.0.0.1;databaseName=dash (i.e. server = 127.0.0.1;database=dash)

MySQL

Driver Class Name = com.mysql.jdbc.Driver

URL = jdbc:mysql://localhost:3306/demo21 ( i.e. server = localhost;port=3306;database=demo21)