Spreadsheet: 187217d1350381678-copying-rows-to-new-worksheet-when-col-a-in-worksheet-1-vaule-in-col-a-in-worksheet-2-copy-rows
Sheet: 7000+ 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
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
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
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
SaaS and Hosting Options
Automatic system deployment and maintenance | X
Vendor addresses customization requirements for business functionality, data security, user interface, etc. | X
Secure application and data access via vendor's provisioning | X
Secure application and data access via administration | X
Secure application and data access via LDAP provisioning or single sign-on | X
Secure application and data access via management tools | X
Audit trail | X
Scalable to thousands of potential users | X
Application can be hosted within customer's secured environment | X
Multitenant SaaS application to allow all users to receive application updates at the same time |  |  |  |  |  |  |  | X
SAS-70 Level II Audit Certification of the hosted partner | X
SAS-70 Level II Audit Certification of the vendor per se | X
Hosted single-tenent ASP delivery |  | X
Use of AJAX eliminates a need to reload an entire page every time user submits data to the server |  |  |  |  |  |  |  | X
User side is pure HTML, does not require any applets, Active X controls, or any other plug-ins | X
The same application is used when the user is is working both on-line and off-line and has an identical look and feel |  |  |  |  |  |  |  | X
Runs with any browser on any platform and over slow connections (like dial-up) |  |  |  |  |  |  |  | X
All data is maintained in a relational database, which allows third party BI tools to access the data | X
Scripting language lets administrators write and maintain advanced or complex calculations through a  point and click UI without knowing programming |  |  |  |  |  |  |  | X
Transport protocols | X
Deploys on-premise or delivered in a SaaS model | X
Users can work off-line, disconnected from the Internet, and replicate afterwards |  |  |  |  |  |  |  | X