JSQLConnect 8’s Exceptional Features Include:
For more than 10 years, expert developers have embedded JSQLConnect in thousands of applications around the world, and during that time JSQLConnect has become the trusted connection to provide fast, secure, scalable and reliable connectivity to Microsoft SQL Server™
Security
Full Kerberos authentication support and NTLM authentication with SSL enabled. Secure connections are supported for local, cloud or hybrid SQL Server environments.
Scalable and Affordable
Whether your application is for a small internal application or part of a larger OEM project, the JNetDirect team will work closely with you during the testing period to offer the best license available.
Speed and Performance
JSQLConnect’s Bulk Loading Feature is 1.5 times faster than our nearest competitor and requires no code changes. With a small footprint and reduced CPU usage, maximize your data moving capabilities – especially with large data volumes.
Stability
From a new application project to numerous applications that have been running for more than 10 years with unlimited connections at thousands of locations, JSQLConnect is the trusted component to ensure reliable connectivity with maximum performance.
Compatibility
JSQLConnect is designed to be backwards and forward compatible. Staying current with the latest release of SQL Server while supporting previous versions, spend less time trouble shooting version issues. Different from "free" drivers which may force untimely or unplanned upgrades.
specs JSQLConnect 8.4.0
Now with the release of JSQLConnect Version 8 (see press release), we continue to outperform other drivers while exceeding the latest industry standards.
- Type 5 JDBC driver
- SQL Server 2017 Compatible
- Java SE 8, 9, 10, 11 and 12
- JDBC 4.0/4.1/4.2/4.3
- Now compatible with Windows 10
- TDS 7.4
- Supports both 32-bit and 64-bit
- Streaming of LOB to partlen types
- Improved BLOB/CLOB performance
- Supports for Always Encrypted SQL Server feature
White papers
Automate Daily Admin Tasks
With Combine you can:
- Deploy objects, schema, jobs, users, logins, and custom scripts on all your servers in one click
- Synchronize all passwords with one-click
- Monitor databases, SQL jobs & backup status across the enterprise
- Restart SQL services on all servers & instances on the network
Deploy custom admin projects, execute scripts, and run distributed queries on all databases and server in one click.
Scale Out without Losing Data
With Combine you can:
- Get performance metrics from all SQL servers & instances
- Schedule data collection tasks
- Send email notifications to track data collection tasks
Automatic data collection, aggregation, and auto-storage to one or more output databases.
Automate Projects & Deployments
With Combine you can:
- Move projects between Dev, QA and Production with one-click deployment to all databases and servers
- Save detailed deployment results and audit trail
- Command line deployment for application automation or automated builds
- Automated deployment notification
- Industry-leading intellisense and SQL code editing options
- Support for ALL versions of SQL Server
In one click: Deploy changes to all Databases & servers in each environment.
new FEATURES version 6.4
With every release of Combine, we are excited to continue our leadership in new flexible features to improve your change management tasks. The main feature of JNetDirect Combine 6.4 is an improved Change History database.
- Compression for big fields in the Change History database.
- Filling the Change History database in real time.
- An ability to uncheck scripts and folders in a package during the package deployment.
- Automatic script restart on deadlock errors.
Features
JDataConnect enables your organization to quickly connect Java applications to data sources for which only Open Database Connectivity (ODBC) database drivers exist. Now Microsoft Access, Excel, Microsoft Visual Foxpro, Clipper and other data sources can be leveraged from Java. JDataConnect adds a critical server component to traditional "desktop databases" and provides flexibility, performance, data security and stability.
Connection Pooling
Increase performance with connection pooling, even if you are not using a J2EE platform.
Remote Monitoring
Empower system administrators with advanced query capabilities for secure database monitoring.
Simplified Certificate and Key Management
Use the same authentication certificates and private/public key pairs as your secure server.
Reduced Driver Size
By leveraging the cryptography support of the host browser, the driver size remains small.
Full Strength Encryption Keys
The SSL/TLS encryption protocol supports a range of full strength keys and cipher suites.
JDataConnect Specs
Software developers with the need to support multiple databases, including Oracle, DB2, and Informix can select JDataConnect as a common data server. At the time of deployment, a simple ODBC configuration enables your Java application to run seamlessly on nearly any database platform.
- JDBC 2.0/3.0/4.0
- Java 1.3 -- 1.6, Java7, Java8
- Microsoft Windows 2000, 2003, 2008, Vista, 7, 8, 10, including 64-bit versions
- Any database server which has ODBC driver
- Compatible with Windows Server 2016