Learning Center
Plans & pricing Sign in
Sign Out

ODBC for Syspro


  • pg 1
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 of ODBC for SYSPRO                                                                                                  Database       ODBC Compliant
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                                                                            ODBC Driver             Word Processor
important that business data be analyzed in a format that reflects
real world scenarios, i.e., relationally.
Microsoft Corporation’s “Open Database Connectivity” (ODBC)                                                                                  IMPACT Catalog                Graphs
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                                                                                                                Reports
(such as Microsoft Excel or Access) to access SYSPRO data. ODBC
provides a transparent link between SYSPRO data and many                                                                                     SYSPRO
Windows-based applications, including Microsoft Word, Crystal                                                                                                           Application
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                                System Requirements
each application where to find requested data in SYSPRO files.
                                                                                                • SYSPRO C-ISAM Database
SYSPRO’s ODBC drivers are 100% compliant with Microsoft’s                                       • ODBC Driver required for each client PC (seat) that will use
ODBC standard and are based on Structured Query Language                                          ODBC to access SYSPRO data
(SQL). This feature enables the SYSPRO database to be viewed                                    • TCP/IP (for Client/Server platforms)
as a relational database. SQL statements can be used to query the
                                                                                                • ODBC U/SQL Manager (optional)
SYSPRO data. Depending upon the Windows application in use,
the SQL queries can be stored for subsequent reuse. This facilitates                            • ODBC Gateway License for Windows NT-based Server
the setup of a number of standard queries pertinent to a company’s                                connections and Internet (optional)
particular business.
                                                                                              Features and Benefits
ODBC is available as a multi-user Client/Server package. ODBC is                                • Improves information management for better decision making
also available as a standalone Windows product where the programs
                                                                                                • The transparent link between SYSPRO and Windows
and data files reside on the same Windows-based workstation, or
                                                                                                   applications increases functionality
on a hard drive that is mapped as if it were a local drive.
                                                                                                • Provides a relational view of SYSPRO data that mirrors
In a multiple-tier, Client/Server environment certain ODBC                                         the real world
programs reside on a Windows-based workstation while others,                                    • SQL access to data files eases data retrieval
including the .UDD file, reside on a UNIX (AIX, HPUX, Sun                                        • Supports popular desktop information tools that expand
Solaris or SCO), NetWare or Windows NT-based server. The                                           system functionality
workstation and the server are connected using TCP/IP.
                                                                                                • Stand-alone and Client/Server extends scalability
The ODBC product is comprised of ODBC drivers. The ODBC                                         • Provides high performance optimized query for rapid
U/SQL Manager maintains the ODBC dictionary and the ODBC                                           data retrieval
Gateway License allows multi-user access through a client on the                                • The write back capability eliminates reentering data
Microsoft Windows NT server.
                                                                                              *Microsoft and Windows are registered trademarks of Microsoft Corporation. All other trademarks are

     Africa & Middle East             Asia Pacific                       Canada                                                United Kingdom and Europe           USA & Americas
    Tel +27 (0) 11 461 1000     Tel +61 (2) 9889 5600          Tel +1 (604) 451 8889                                           Tel +44 (0) 161 876 7771        Tel +1 (714) 437 1000
   Email   Email        Email                                        Email        Email
                                                         © 2003 Syspro. All Rights Reserved. All trademarks are recognized.

To top