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 of ODBC for SYSPRO Database ODBC Compliant Spreadsheet 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 reﬂects 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 ﬁnd requested data in SYSPRO ﬁles. • 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 Beneﬁts 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 ﬁles 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 ﬁles eases data retrieval including the .UDD ﬁle, 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 recognized. SYSPRO Africa & Middle East Asia Paciﬁc 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 firstname.lastname@example.org Email email@example.com Email firstname.lastname@example.org Email email@example.com Email Info@us.syspro.com © 2003 Syspro. All Rights Reserved. All trademarks are recognized.
Pages to are hidden for
"ODBC for Syspro"Please download to view full document