| PowerMart 3.5 Enhancements III
The following is a list of feature/functionality enhancements that will be in
the FINAL version of PowerMart 3.5 (some of this functionality may not be
available in the beta). Please use this as a guideline when setting
customer/prospect expectations.
Note that some of the features are marked as "tentative". This means that we
intend to provide this functionality in the final release, but it is not
guaranteed.
- Enablement of CDC 1.0
- Incremental aggregates
- Improved support for updates with PowerCapture (previously know as
Change Data Capture)
- Support for Sybase log reader and Oracle deferred triggers
- Optional bulk/insert load
- The Sybase identity problem is fixed in 3.5. Basically, it is fixed
by the fact that we now have
insert capability in addition to Bulk load.
- ODBC support for 3.5 for NT.
- Test load
- Test load row count can be specified in the Server Manager. When
specified, the reader process
will read the designated number of rows and execute. If not specified,
the test load will be done
for all of the data.
- Support for passing nulls in stored procedures (bug fix)
- Scheduling/monitoring
- Users can start from a session from within a batch. The session is a
starting point, so all sessions
be run from that point in the batch. Scheduled sessions, and the
schedule, are displayed in the
monitor mode on a separate pane.
- A new column has been added ("First Error") in Monitor Mode which
displays the first error
during a session run. Any error that causes a session to stop is
shown.
- Support for Sybase 4.9.2 (source and target)
- Microsoft BackOffice Certification
- Unified login
- SMS support
- Command line scheduler support
- Used for integration with third part schedulers (e.g. Autosys)
- Sequence # generation for rejected rows
- Functions:
- TOP
- Date diff
- Pivot function
- Support for continuous polling (aka contant reading)
- Support for copy mappings on the client (Repository Manager)
- Support for Synonyms
- Attributes added to Repository Manager. Some of these include:
- DBD name for sources,
- Table Constraint and Table Options for Targets,
- NULLable flag for source and target fields,
- Log file, email user, email text,
writer load type, source data type,
reader type, and writer type for Sessions,
- Domain, database type, and Trusted Connection
for Database Connections. Note that Trusted
Connections and Domain apply to Microsoft
SQL Server only.
- Image Table Type for CC Sources.
- SQL query override (allows you to override the entire SQL statement - not
just the WHERE clause)
- Ability to specify packet size on connect (for Sybase and MS SQL Server)
|