Products

Data Access Studio™

Built from the ground up, Data Access Studio is a tool that provides powerful reporting over JD Edwards data. Using its graphical interface, you can accomplish sophisticated tasks with ease:

Advanced data queries
Sorting, Grouping, Totaling
Report generation and printing
Ability to view ODBC and OLE DB data (from legacy systems and non-JD Edwards tables)
Ability to snapshot data and compare to any environment

All this and more in a completely visual-based environment. No programming is required!

	User Productivity Kit - See Data Access Studio in action
	Analysis of Value
	Integration with JD Edwards
	Feature Overview (Word Document)

General Capabilities

You can open JD Edwards tables and business views, Published reports, OLE DB/ODBC data, and Snapshot data
Progress bar shows percentage of table loaded
Navigation controls show which row is selected and allows you to navigate through the data
Filter boxes above each column filter as you type in values - letting you zero-in on the data
Advanced filtering
- List of values
- Ranges
- Wildcards
- Composite queries
- Distinct values
You can change the appearance of all grids: colors, fonts, lines, column headings, etc.
All grids provide export and printing

Grouping and Totaling

Create level breaks visually
Group on any combination of columns
Adding group and grand totals is a snap

Column Operations

Sort, group, hide/show columns
Select the column caption as: Alias, SQL Name, Long Name, Two-row description, or your own caption
Provide custom numeric and date formats
Auto-size your columns with the Best Fit operations

Reports and Printing

Create business views on-the-fly
Publish reports to share with other users
Publish to all, to a group, or to specific users
Print the contents of all grids
Print preview, zoom in/out, header/footers

Security

Uses standard OneWorld security -- column, row, and table-triggers
Data Access Studio application level security.

Calculations

You can derive useful data on your grid in real-time, including:

Mathematical operations (addition, subtraction, multiplication, division, etc.)
String operations (concatenation, substring, formatting, etc.)
Database table lookup
Date operations
and more

Some advantages of Calculation Columns are:

Ability to see each calculation as you design--debug as you design
Ability to hide intermediate calculations from the visible report columns
Ability to form simple joins to other tables
The Calculation Column behaves just like any other database column -- i.e., you can sort, group, summarize, etc.

Dominion Software produces Data Access Studio™. Data Access Studio™ is not a JD Edwards® (PeopleSoft®) Product. "Data Access Studio" and "DAS" are Trademarks of Dominion Software LLC.

List of Features

Browse tables and business views

Open multiple tables and views

Open most recently used tables

Create new business views on-the-fly

Visual Summarization

Summarize data

Add column totals

Group by any set of columns

Expand and collapse groups

Print grid data

Landscape/Portrait

Multiple paper sizes

Print preview

Zoom/View multiple pages at a time

Easily export rows to Excel® and third party applications

Copy rows to file

Copy rows to Excel

Copy multiple rows to the clipboard

Drag-and-drop rows from DAS to third-party application

Feature-rich column layout

Columns displayed by Description, Alias, SQL Name, or Long Data Item Name

Hide and show columns

Re-size, re-order

Change fonts, colors, lines

Save, restore, delete layouts

Publish layouts

Powerful data filter

Filters as you type

Filter with wildcards, ranges, blanks, list of values, distinct values

Visual assists

Powerful calculation engine

Lookup table values

Math operations

Date operations

System operations

Calculation results available in real-time

Sort any combination of columns

Data Navigation

Number of records shown

Go to buttons: top, previous page, next page, bottom

Progress bar shows percentage of records read

Load data without tying up the user interface

Cancel button cancels load at any time

Table and View Information

Summary, column, index, and join information

Access non-OneWorld Data

Open OLE DB and ODBC compliant tables

Use Data Access Studio™ rich formatting, printing, and exporting to manage the data

Snapshot any set of rows, columns, and tables

Compare snapshot to any environment

Comparison shows all differences between snapshot and environment data

Useful for verifying table conversions and test cases

Index Assistant

Full Help System

Performance Management Plus™

You've upgraded your hardware, database, and network; yet you still have EnterpriseOne performance problems. What is the next step? Performance Management Plus.

With the Performance Management Plus Toolset (PMP), you can control your EnterpriseOne performance problems no matter how complex your system. PMP allows you to not only identify problems and fix them; but also to ensure that your processes continue to run smoothly over time despite system changes.

How does this work? Simply by providing tools that empower you to:

Analyze
Solve
Test

Analyze. No matter how complex your system, you need to be able to identify the causes of bad performance. Performance Management Plus real-time performance monitor gives you precisely this ability. The Performance monitor measures and records the performance of your production systems. You will immediately be able to identify critical paths and likely causes. Furthermore, as your system evolves over time, you will be able to compare how the system performs compared to past versions. This powerful system analysis puts you in control of what your system is doing!

Solve. Once you have identified the critical paths and possible causes, you will need to have tools to help you solve the performance problems. Performance Management Plus toolset gives you two powerful ways to solve common system performance problems:

Better SQL
Better Caching

When your performance problems result from poor database queries, better SQL will help tremendously. The Performance Manager Plus Data Access APIs give your developers the capability of creating better SQL statements than is otherwise possible in EnterpriseOne. You can create better SQL statements that let the database do the work that it should.

When your performance problems result from poor redundancy management, better caching can be the solution. For instance, if you repeatedly fetch the same set of rows from the database, it would be much better to cache the rows and access the redundant information from memory. This will improve both database and network performance.

Test. Once you have implemented your solutions, you can test the changes with the performance monitor. The monitor will show how much you have improved things. Also, you may see new critical paths that will require additional solutions. Over time, you will cycle through this methodology to achieve ongoing performance.

Please contact us to set up a demonstration.