ODBC

Objective

To use the Microsoft* “Open Database Connectivity” (ODBC) standard, enabling Third Party programs to access SYSPRO data on a read and/or write basis in order to extend the system functionality to other productivity tools.

The Value ODBC of SYSPRO

In today’s fast-paced business climate, it is highly desirable for a company’s various computer programs to have the ability to interact and exchange data. To make the most informed decisions, it is also important that business data be analyzed in a format that reflects real world scenarios, i.e., relationally.

Microsoft Corporation’s “Open Database Connectivity” (ODBC) is the de facto industry standard for data exchange or open systems functionality. Syspro has invested heavily in ODBC technology to enable SYSPRO customers to use any ODBC-compliant software (such as Microsoft Excel or Access) to access SYSPRO data. ODBC provides a transparent link between SYSPRO data and many Windows-based applications, including Microsoft Word, Crystal Reports, Forest and Trees, WordPerfect and Visual Basic.

SYSPRO’s ODBC drivers provide a seamless pipeline between Windows applications and the SYSPRO database. The drivers tell each application where to find requested data in SYSPRO files.

SYSPRO’s ODBC drivers are 100% compliant with Microsoft’s ODBC standard and are based on Structured Query Language (SQL). This feature enables the SYSPRO database to be viewed as a relational database. SQL statements can be used to query the SYSPRO data. Depending upon the Windows application in use, the SQL queries can be stored for subsequent reuse. This facilitates the setup of a number of standard queries pertinent to a company’s particular business.

ODBC is available as a multi-user Client/Server package. ODBC is also available as a standalone Windows product where the programs and data files reside on the same Windows-based workstation, or on a hard drive that is mapped as if it were a local drive.

In a multiple-tier, Client/Server environment certain ODBC programs reside on a Windows-based workstation while others, including the .UDD file, reside on a UNIX (AIX, HPUX, Sun Solaris or SCO), NetWare or Windows NT-based server. The workstation and the server are connected using TCP/IP.

The ODBC product is comprised of ODBC drivers. The ODBC U/SQL Manager maintains the ODBC dictionary and the ODBC Gateway License allows multi-user access through a client on the Microsoft Windows NT server.

System Requirements

• SYSPRO C-ISAM Database
• ODBC Driver required for each client PC (seat) that will use ODBC to access SYSPRO data
  
• TCP/IP (for Client/Server platforms)
• ODBC U/SQL Manager (optional)
• ODBC Gateway License for Windows NT-based Server connections and Internet (optional)

Features and Benefits

• Improves information management for better decision making
• The transparent link between SYSPRO and Windows applications increases functionality
• Provides a relational view of SYSPRO data that mirrors the real world
• SQL access to data files eases data retrieval
• Supports popular desktop information tools that expand system functionality
• Stand-alone and Client/Server extends scalability
• Provides high performance optimized query for rapid data retrieval
• The write back capability eliminates reentering data

*Microsoft and Windows are registered trademarks of Microsoft Corporation. All other trademarks are recognized.