Login  
   

SYSPRO Information Technology

SYSPRO is a Windows-based fully integrated business software solution built on a framework of industry standard tools and objects, operating systems and databases. The technical profile of this solution is as follows:

Development Kit and Architecture
SYSPRO is developed using Merant's NetExpress development suite, based on a multi-layer architecture between end-user interface, client programs, server programs, business logic, and underlying database.

This fundamental architecture has and continues to facilitate SYSPRO's adoption of Microsoft's DNA - COM technologies, which ease the embedding and integration of other applications and processes directly into SYSPRO. COM objects are software components that retain the business logic of an application. They are easily incorporated into purpose-built web applications, while retaining data integrity. SYSPRO will ship with a set of COM objects that allow users to assemble, for example, e-procurement systems using a simple web browser as a client interface. This architecture also allows easy integration with multiple input devices other than standard PCs, such as handhelds of various types.

Multi-Platform Capabilities
SYSPRO runs with equal strength on a variety of operating systems and hardware platforms for superior flexibility and interoperability. SYSPRO easily scales from one user to several hundred.

The client/server solution supports a two or three-tier structure where the interface, the application logic and the database can be installed on separate machines. System upgrades are easily implemented since the software need only be loaded on the server, which automatically sends the required components to the client. Client/server technology is ideal for local and remote clients.

With operating systems that do not support a client/server environment, such as Novell Netware, SYSPRO functions in a mapped server configuration. In this manner, the server acts as a file server, mapping the software to the PCs or workstations where the processing is performed.

Database Options
SYSPRO offers its standard C-ISAM (Indexed Sequential Access Method) database structure, which is normally stored on the same server as the application. This database is accessible through ODBC connectivity for data access and reporting.

Alternatively, SYSPRO offers an optional SQL Server solution for RDBMS (Relational Database Management System) that helps maintain data integrity through transaction logging allowing roll backward and roll forward recovery. SQL Server has the rich functionality to analyze corporate data easily and efficiently with data analysis techniques such as Data Warehousing, Data Mining and OLAP. The SQL database structure also facilitates seamless integration with other applications and automated processes.

Integrations
SYSPRO focuses on tight integration with Microsoft productivity tools, such as Microsoft Word and Excel, and also allows unlimited relational access to data through ODBC connectivity (non-SQL) or direct SQL statements (Microsoft SQL Server).

Using the power of Microsoft Word, SYSPRO users can create documents, such as A/R statements or S/O invoices, in virtually any style imaginable. Documents printed by Microsoft Word can be faxed and/or emailed directly from the desktop.

Using the tight integration, users can easily analyze data shown in any listview directly within Microsoft Excel using automation techniques. Listviews are used extensively to display data in a grid-like control and include built-in features such as the ability to export entire databases directly into Excel for analysis or manipulation, or HTML format for display in a browser.

Tight integration means being able to create task lists and ensure that new tasks can be inserted into Microsoft Outlook for automatic reminders.

SYSPRO is also integrated with the BizTalk server technology. BizTalk, a Microsoft strategy, enables businesses to interchange documents easily with trading partners over the Internet. The documents are constructed in non-proprietary, non-rigid formats that are securely sent over the Internet and then translated from schemas into a format understood by the sending or receiving application, such as SYSPRO. SYSPRO's COM objects will take these documents and update the SYSPRO database directly.