Spreadsheet: 187217d1350381678-copying-rows-to-new-worksheet-when-col-a-in-worksheet-1-vaule-in-col-a-in-worksheet-2-copy-rows
Sheet: 3000+ Rows

Product Technology
Architecture
Data Integration Technologies
Data Management Options
Relational database design | x
Normalized tables | x
SQL APIs for calls or data requests | x
Multi-RDBMS portability |  |  |  |  |  |  |  | x
Transaction tracking system | x
Replicates database master files, fields, and structures | x
Supports Disaster Recovery Institute procedures |  |  |  |  |  |  |  | x
Database Gateway Options
Microsoft SQL Server |  |  |  |  |  |  |  | x
Oracle | x
IBM DB2 |  |  |  |  |  |  |  | x
Informix |  |  |  |  |  |  |  | x
MySQL |  |  |  |  |  |  |  | x
PostgreSQL |  |  |  |  |  |  | x
Progress |  |  |  |  |  |  |  | x
Sybase |  |  |  |  |  |  |  | x
Server/Host Relational DBMS Options
Oracle | x
Microsoft SQL Server |  |  |  |  |  |  |  | x
IBM DB2 |  |  |  |  |  |  |  | x
Informix |  |  |  |  |  |  |  | x
MySQL |  |  |  |  |  |  |  | x
PostgreSQL |  |  |  |  |  |  | x
Progress |  |  |  |  |  |  |  | x
Sybase |  |  |  |  |  |  |  | x
[NAME]
Maintain basic data models | x
Storage of metadata model/global data dictionary for any applications or data sources | x
Include data in the interrelationship details, regardless of data formats | x
Includes data description/definition language (DDL) for importing, editing, printing, and generating DBMS data structures | x
Common relational model for sharing data across multiple databases | x
Interface to relational database structures |  |  |  |  |  |  |  | x
Interface to CASE tool designs |  |  |  |  |  |  |  | x
Interface to system management or network configurator for automatic job execution | x
Non-operational data warehousing | x
Logical Repository Model
House system design criteria, database structures, data element links, and interrelationships | X
Combine procedural and object-oriented components | X
Capture complex relationships between system components | X
Unify and reconcile enterprise data within and across all applications and platforms | X
Define structure of distributed databases and data stores | X
Define network components and interrelationships in enterprise of a distributed application infrastructure | X
Include inventory of hardware configurations | X
Identify hardware upgrade requirements and manage the upgrade/distribution process | X
Repository Metadata Tools
Tool for modeling metadata (information about data, its structure, and where it is stored) | x
Tools for analyzing source data, modeling target data structures, and storing information | x
Source code analyzers for documenting program interdependencies and separating application logic from core data structures | x
[NAME] source/host application data to data elements in an open system environment for coexistence, batch extraction, or system migration | x
Create objects that reference multiple sources or data formats |  |  |  |  |  |  |  | x
Repository User Interface
Uses meaningful terms and descriptions rather than data-schema terms and abbreviations | x
Central point of reference for retrieving and controlling enterprise information | x
Concurrent access to the data with data locking and check-in and check-out integrity mechanisms | x
Views information in the repository by using a browse feature | x
Guide feature identifies what data is available and where it is used |  |  |  |  |  |  |  | x
Access to business rules and predefined queries for decision support |  |  |  |  |  |  |  | x
Windows-based end user query and reporting tools | x
Combines information from different databases or data sources in one query or report | x
Business Modeling/Repository Tool
Bachman/[NAME]/DBS |  |  |  |  |  |  |  | x
Logic Works ERwin, [NAME] |  |  |  |  |  |  |  | x
Intersolv Excelerator II |  |  |  |  |  |  |  | x
Designer 2000 |  |  |  |  |  |  |  | x
IDE Software through Pictures |  |  |  |  |  |  |  | x
Intellicorp Object Management Workbench |  |  |  |  |  |  |  | x
VMARK Synchronicity |  |  |  |  |  |  |  | x
CA-OpenROAD/Architect |  |  |  |  |  |  |  | x
TI Business Design Facility |  |  |  |  |  |  |  | x
Cadre Technologies ObjectTeam |  |  |  |  |  |  |  | x
CASEwise Modeler |  |  |  |  |  |  |  | x
Ptech |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  | x
Proprietary/Other |  |  |  |  |  |  |  | x
System Architect |  |  |  |  |  |  |  | x
LBMS/System Engineer |  |  |  |  |  |  |  | x
Rational Rose |  |  |  |  |  |  |  | x
Non-operational Data Warehousing
End user database environment designed for "what-if" modifications and queries | x
Denormalized read-only database tables |  |  |  |  |  |  | x
Data effectivity rating |  |  |  |  |  |  |  | x
Data element time-sensitivity analysis | X
SQL report writer query access | x
External data warehousing tools and databases | x
Messaging Protocols
RPC Options
Asynchronous RPC | x
Synchronous RPC | x
OSF DCE RPC |  |  |  |  |  |  | x
Proprietary or other | x
Message Oriented Middleware
Sockets | x
Microsoft MSMQ |  |  |  |  |  |  |  | x
APIs
DDE | x
OLE, OLE2 , and ActiveX | x
ODBC, ADO, and OLE DB | x
Client/server API middleware | x
Published APIs to standard ERP functionality | x
Published APIs to specific vendor systems | x
Device Interfaces
Device Interface Management
Accept input transactions from a preformatted batch | x
ASCII text file | x
Accepts input transactions in a continuous process | x
Continuous data load | x
Multiple loads processed simultaneously | x
Internal data validation/error checking | x
Error file review and manipulation | x
Data reprocessing | x
Current data download processing status operator display | x
Automatic maintenance of complete audit trail | x
Automatic maintenance of error logs | x
Standard Device [NAME]
RS-232 communication protocol | x
I/O driver interfaces to bar code readers, automatic ID devices, and gauges | x
Radio frequency (RF)/bar code reader | x
Input Device Options
Pen-based systems | x
Voice recognition |  |  |  |  |  |  | x
Touch screens | x
[NAME] | x
Trackball | x
Bar code | x
Keyboard | x
Gauges |  |  |  |  |  |  | x
Scanners | x
Portable data terminals | x
Architectural Foundation
System Defaults and Parameters
Generalized codes validation tables | x
Standard messages and reason codes | x
Customized help windows | x
Company-specific field help | x
Security by user ID, password, and user group | x
User menus | x
Operating system command options | x
Database dump/load | x
Archive history file reload | x
Master file audit reporting | x
Scroll and keyword search of displayed reports | x
System cross-reference of files, fields, programs, menus, and messages |  |  |  |  |  |  |  | x
Multiple printer assignment to users and to functions | x
Bar code control character sequences for printing preformatted documents | x
Web Enablement
Degree of Web Enablement
Intranet capabilities | x
Extranet capabilities | x
Connects multiple sites and the extended enterprise using private lines or the Internet or intranet | x
Lookups processed online occur in real time | x
Browses processed online occur in real time | x
Data validation processed online occurs in real time | x
Transactions processed online occur in real time | x
Provides information on demand | x
Web Interface
Open database structures permits user or third party to write Web enabler | x
API program interface | x
Tool to build interface | x
Pre-configured screens | x
Third party tool to build interface | x
Third party tools for drag-and-drop creation of interface | x
Built-in tool for drag and drop web page design | x
Administration tool kit | x
Setup tool kit | x
Uses plug-ins, helper applications, and other existing off-the-shelf tools | x
Customization and tailoring capabilities | x
API configuration tool | x
Web Forms
Template extends basic HTML with SQL functions | x
User-friendly control features | x
Template generates web form | x
Drag and drop to create web form | x
Form creation | x
Form entry validation | x
Rich formatting functions for plain text, HTML text, or URL strings | x
Templates include cookie, session, query, shopping, and transaction features | x
Form modification and customization | x
Functionality
Dynamic, embedded URL support | x
Reference resolution |  |  |  |  |  | x
Where-used queries |  |  |  |  |  | x
Record creation | x
Record update/modify | x
Promotions and approvals | x
Check-ins and check-out files | x
Attaches references | x
Reads and writes or modifies data at the browser level | x
Manages query results from within the application | x
Robust data type sets | x
Dynamic SQL statements from all form inputs, URL strings, and environment | x
High-volume, online transaction processing | x
Function for generating e-mail, based on HTML form input | x
User-defined procedures | x
Both browser and non-browser access via TCP | x
Simultaneous access to heterogeneous databases |  |  |  |  |  |  |  | x
Deploys across multiple platforms |  |  |  |  |  |  |  | x
Message-based communication between business systems (using EDI or other document formats) | x
Integrates application and desktop applications | x
HTML push technology | x
Intuitive drag-and-drop tool for accessing ad hoc database information |  |  |  |  |  |  |  | x
Security Levels
Base product security (the level of security supplied by vendor API) | x
Encryption (SSL 3.0) | x
Encryption for password transmission | x
Encryption for data transmission | x
Cookies (to preserve state between successive pages or sessions) | x
Encryption
DCE support |  |  |  |  | x
Server authentication |  |  |  |  | x
Data integrity assurance |  |  |  |  | x
User verification |  |  |  |  | x
Digital certifications |  |  |  |  | x
DES data |  |  |  |  | x
IDEA |  |  |  |  | x
Third party tools or modules |  |  |  |  | x
Security zones | x
Security Functions
CORBA access |  |  |  |  |  |  |  | x
Accepts logins | x
Routes connections to other systems or hubs |  |  |  | x
Browser requests | x
Remote agent for database access |  |  |  | x
Moves results from one database to another database |  |  |  |  |  |  |  | x
Communicates with remote agents and other hubs |  |  |  | x
Transfers queries from agent to agent |  |  |  | x
Merges data from multiple sources |  |  |  | x
Communicates with other middleware |  |  |  | x
Time data sequence number in each transaction |  |  |  | x
Security Management
Role or task-based security scheme for individual users | X
Coordinates Internet server security with database security | X
On-spot security management | X
Administration tools | X
Tools provided to manage access | X
Administrative monitoring | X
Point and click security setup | X
Creates transaction log | X
Reads, writes, and deletes permissions at the record or row level | X
User authentication applied at data level | x
Session management tools | X
Internet Commerce Protocols
Secure Transaction Technology (STT) | X
Secure Electronic Payment Protocol (SEPP) |  |  |  |  | X
Secure Electronic Transactions (SET) | X
SSL | X
PCT | X
Transport Layer Security (TLS) | X
E-mail: S/MIME |  |  |  |  |  |  |  | X
E-mail: UUEncode | X
E-mail: MIME | X
Web browser functionality | X
Application distribution capacity | X
Business functionality web capacity | X
Organizational Structure
Graphical display of entities, business units, organizational units, departments, warehouses, employee groups, and employees | X
Graphical editor tool for structuring organizational connections | X
Hierarchical connections between organizational groups | x
Hierarchical connections between organizational groups and external processes, sources, and systems | x
Linkage of business procedures with organizational groups or individuals | x
Hierarchical link of organizational or supply chain processes | x
Linkage of manual processes and external processes or systems with groups or individuals | x
Application Security
Database-level security | x
Program-level security | x
Multilevel access passwords | x
User authentication | x
Digital signatures | x
User, object, and method access control | x
Encrypting or decrypting of messages | x
Multisite Management
Date format selection | x
Multiple date formats including month/day/year, day/month/year, and year/month/day | x
Site-specific calendars | x
Consolidation of all plant information | x
Multi-plant availability and message review | x
Networked multi-plant requirements processing | x
Consolidation of supply requirements across multiple sites | x
Consolidation of various logical or physical sites into one DRP/MPS/MRP run | x
Consolidation of operating entity requirements for common procurement functions | x
Transfer of a resupply order for a component to another plant or site | x
Passage of replenishment demand from one location to another | x
Recognition of forecasted or planned interplant demand | x
Creation of inter-facility resupply orders | x
Accounting of material and transfer costs (cost of goods) in transit between demand and supply locations | x
Accounting of site-specific product and location costs | x
Prioritization of the order in which branch relationships are used | x
Prioritization of relationships among facilities and sites | x
User Interface
User Configurability
Configurable menus | x
Drag-and-place menus per user | x
Configurable user screens | x
One-time only screen configuration | x
Configuration can be saved as user default screen | x
Configurable browse toolbars and options | x
Configurable functions and process activities | x
Platforms
Database
Oracle 7/8 |  |  |  |  |  |  |  | x
Oracle 9 | x
Microsoft SQL Server |  |  |  |  |  |  |  | x
IBM DB2 |  |  |  |  |  |  |  | x
Informix |  |  |  |  |  |  |  | x
MySQL |  |  |  |  |  |  |  | x
PostgreSQL |  |  |  |  |  |  | x
Progress |  |  |  |  |  |  |  | x
Sybase |  |  |  |  |  |  |  | x
Servers
Windows NT 4.0 |  |  |  |  |  |  |  | x
Windows 2000 |  |  |  |  |  |  |  | x
Windows XP/Server 2003 | x
[NAME] (Sun OS) |  |  |  |  |  |  |  | x
HP UX |  |  |  |  |  |  |  | x
IBM AIX | x
IBM iSeries (AS/400) |  |  |  |  |  |  |  | x
IBM Mainframe |  |  |  |  |  |  |  | x
Novell Netware |  |  |  |  |  |  |  | x
GNU/Linux (such as Debian, SUSE, or Red Hat) | x
BSD (such as FreeBSD, [NAME], or OpenBSD) |  |  |  |  |  |  |  | x
Mac OS X |  |  |  |  |  |  |  | x
Client
GNU/Linux (such as Debian, SUSE, or Red Hat) |  |  |  |  |  |  | x
Mac OS 9.x |  |  |  |  |  |  | x
Mac OS X.x |  |  |  |  |  |  | x
Windows 95 |  |  |  |  |  |  | x
Windows 98 |  |  |  |  |  |  | x
Windows NT Workstation | x
Windows 2000 | x
Windows XP | x
Windows CE | x
Palm OS |  |  |  |  |  |  | x
Linux-based handheld OS |  |  |  |  |  |  | x
Other handheld OS |  |  |  |  |  |  | x
Application Tools
Application development tools | x
Application management tools | x
Process Modeling and Updating
Graphical display of processes in flow chart diagram format |  |  |  |  |  |  |  | x
Preloaded select process models include logistics |  |  |  |  |  |  |  | x
Preloaded select process models for supply chain |  |  |  |  |  |  |  | x
Training |  |  |  |  |  |  |  | x
Planning |  |  |  |  |  |  |  | x
Course creation and maintenance |  |  |  |  |  |  |  | x
Enable attachments for course collaterals |  |  |  |  |  |  |  | x
Links certifications acquired by attending the course |  |  |  |  |  |  |  | x
Maintain course prerequisites |  |  |  |  |  |  |  | x
Defines and maintains venues (scheduled courses) for courses |  |  |  |  |  |  |  | x
Business Model Generation
Generates unlimited reference and test models |  |  |  |  |  |  |  | x
Full text editor for manually entering procedures |  |  |  |  |  |  |  | x
Approval authorization |  |  |  |  |  |  |  | x
Online model changing and updating |  |  |  |  |  |  |  | x
Separates active model and new model |  |  |  |  |  |  |  | x
Automatic system reconfiguration parameter specifications |  |  |  |  |  |  |  | x
Automatic system reconfiguration integrity checks |  |  |  |  |  |  |  | x
Model transition authorization |  |  |  |  |  |  |  | x
Automatic system reconfiguration |  |  |  |  |  |  |  | x
Workflow and Document Management
Messaging | x
Workflow | x
E-mail | x
Document management | x
Electronic commerce | x
Automatic creation of to-do list | x
Reporting
Reports available online | x
Local report printing (not centralized printing and distribution) | x
Ad hoc inquiry capability from within the ERP product | x
Active or inactive status | x