View PDFStarSQL: High performance ODBC/JDBC Database Drivers for your DB2 data sources
StarSQL provides fast, reliable access to your company’s DB2 host data from any ODBC or JDBC application. The StarSQL driver gives you seamless access to DB2 data from spreadsheets, reporting applications, Visual Basic applications, and development tools. StarSQL gives you out-of-the-box support for the Oracle Database Gateway for ODBC and Microsoft Linked Servers.
Streamlined data paths between DB2, Web, and Application servers. StarSQL can streamline your efforts by providing desktop access to DB2, and Linked Server access via Microsoft SQL Server, allowing your Web and Application Servers to seamlessly interface with your DB2 system. StarSQL optimizes the DB2 data path, allowing SQL Server users and utilities to access DB2 data as if it were located in another SQL Server table.
Support for the latest DRDA-compliant databases, including IBM i 7.4, DB2 12 for z/OS, DB2 11.5 for LUW and Apache Derby. StarSQL also includes both 32-bit and 64-bit versions of the ODBC driver giving you a way to unleash the power of 64-bit database applications.
Leverage your existing hardware and network connections. StarSQL uses existing TCP/IP networking and can access data on both legacy systems and the latest operating and database management systems. Also, because the StarSQL driver runs on a client computer, no host software or proprietary gateway is required.
Configuration wizard provides seamless implementation. A Data Source Configuration Wizard walks users through the tasks of configuring StarSQL to access a particular data source. You can install custom, pre-defined Data Source Name definitions along with StarSQL throughout an organization. StarSQL is compatible with most application architectures, providing users with immediate access to DB2 data. Plus StarSQL is completely thread-safe, so it can be used with web servers, transaction processors, and data replication tools.
Optimized, Secure, and Flexible DB2 Access
The StarSQL ODBC driver is compliant with the IBM CLI Version 2, the ODBC v3 standard, and DRDA Level 3. StarSQL for Java is a Type 4 JDBC driver that features comprehensive support for Version 3.0 of the JDBC standard, including support for J2EE, LOB (large object) data, encrypted passwords, connection pooling, and Two-Phase Commit (2PC) JTA-type transactions.
Robust Implementation, Performance, and Reliability
StarSQL uses open industry standards to deliver rapid access to DB2. It implements unique, built-in memory management, collapsed protocol layers, and optimized overhead data transfer methods to provide the industry’s fastest remote data access. StarSQL supports all data types and DB2 versions.
Java, Linux, UNIX, and Windows Support
StarSQL provides the same fast, reliable data access solution for all popular computing platforms. The StarSQL for UNIX driver software is currently available for Linux. StarSQL for Windows can run on all the latest Windows systems, including Windows 10 and Server 2019. The 64-bit version of StarSQL takes advantage of the Windows x64 architecture. StarSQL for Java uses JDBC to extend access from platforms such as Apple Macintosh.
Secure Data Access and Control
StarSQL encrypts user IDs and passwords to provide greater security and data access control. The StarSQL driver respects the security protocols of the host and client computers, allowing users to access only the data to which they are authorized. In addition, SSL (Secure Sockets Layer) is available when communicating with supported hosts to provide secure, encrypted communication over insecure channels.
Support for All Major Languages
StarSQL includes conversion support for all major language groups, including legacy hosts that use Extended EBCDIC for East Asian languages (Chinese, Japanese, and Korean). StarSQL v6.x is a Unicode ODBC driver and supports modern applications and hosts that take advantage of Unicode encoding.
Support for Two-Phase Commit Transactions
StarSQL supports two-phase commit transactions to IBM mainframe, mid-range, and workstation-based hosts. StarSQL’s two-phase commit support provides high transaction throughput rates, seamlessly integrated with Microsoft’s Distributed Transaction Coordinator (DTC).
Support for LOB Data Types
StarSQLprovides efficient high speed access to LOB data types-Binary Large Objects (BLOB) and Character Large Objects (CLOB). LOB data is increasingly important for storing and retrieving rich content such as video, audio, and XML-based data.
.NET, ADO, and RDO Interface Support (ODBC driver only)
StarSQL for Windows implements Microsoft’s ODBC application programming interface so it works with the most tools, such as Microsoft Transaction Server and Internet Information Server. StarSQL for Windows supports all ODBC calls that users demand when working with the parameter marker features of PowerBuilder or Microsoft’s access methods, including .NET, Active Data Objects (ADO) and Remote Data Objects (RDO).
Very cost-effective, flexible deployment options
StarSQL is offered with flexible packaging and licensing options. Licenses are priced according to the maximum number of StarSQL concurrent connections needed. StarSQL is licensed for use on the network for any combination of servers and workstations, including Windows, UNIX and Java platforms and works with a wide array of application servers, Java and ODBC clients. You pay only for the number of connections needed at the same time with either the ODBC driver or the JDBC driver. Contact StarQuest for attractive entry-level pricing and volume-purchase discounts.